Hi,
I was able to create the calendar heatmap visuvalization but havig difficulty with the accurate display.
convert ctime(DATE),timeformat="%Y-%m-%d" |eval BankCTime=case(BankCTime>="0" AND BankCTime<="13.30","0", BankCTime>="13.30" AND BankCTime<="14.00","1", BankCTime>"14.00" AND BankCTime>="14.01","2") |eval GCTime=case(GCTime>="0" AND GCTime<="15.0","0",GCTime>="15.01" AND GCTime<="15.30","1", GCTime<="15.30" AND GCTime>="15.31","2")|eval _time=strptime(DATE,"%Y-%m-%d")|timechart span=1d max(BankCTime) as IBTime values(GCTime) as GCTime
When I select Statistic visualization, the data is all correct, but when I select the Calendar Visualization for the same, I see that the Friday's data is listed for Thursday and Monday data is listed as Sunday's. I am not sure about this shift of data. Please help.
... View more