Hi I am trying to make a time chart visualisation but I want it to be in IST(Indian Standard Time).
| eval received = strptime('timestamp', "%Y-%m-%dT%H:%M:%S.%3N")
| eval received_IST = received + 19800
| eval IST = strftime(received_IST,"%Y-%m-%d %H:%M")
| timechart count by Status
Status is a column which is consisting of true and false in string data type. In IST variable I have the timestamp in IST but how to implement it in the timechart? It is automatically picking up the (_time) by default
Have you tried setting the timezone for your user to IST?
Your user's timezone setting applies to your user only. In general I recommend setting the right timezone instead of messing around with adding/subtracting seconds manually.
No the timezone is set to default. I have many live dashboards on my account in which I am already using the conversion of timestamps from UTC to IST. So I do not want to make any sudden change which shall cause any malfunction in the dashboards as many people are using them. If I do the change will there be any such affect do you have any idea?