Forum Discussion
Heatmap Formatting - Display Days and Hours (Custom Axis Labels)
Hi manoj_0911
It is the same step as before.
Create a claulated column
HourNo = HOUR([IXN_SUBHOUR_DATE])Then sort it ascendng, then select the hour column, select sort by HourNo
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi manoj_0911
As Zang_Mi mentioned, you need to format the date, you can create two calculated columns
Weekday = FORMAT([IXN_SUBHOUR_DATE],"DDD")Hour = FORMAT([IXN_SUBHOUR_DATE],"hh AM/pm")Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi , How to sort the weekdays as like Sun, Mon, Tue, Wed, Thur, Fri and Saturday
Hi manoj_0911
You can add a calculated column
WeekNo = WEEKDAY([IXN_SUBHOUR_DATE])Then click the weekday column,select sort by 'WeekNo'
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry, I missed adding this info before also I want the hours in this order 12am,1am,2am,3am,4am,5am,6am,7am,8am,9am,10am,11am,12pm,1pm,2pm,3pm,4pm,5pm,6pm,7pm,8pm,9pm,10pm,11pm
Hi manoj_0911
It is the same step as before.
Create a claulated column
HourNo = HOUR([IXN_SUBHOUR_DATE])Then sort it ascendng, then select the hour column, select sort by HourNo
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.