LinkedIn
Twitter
Hi team,
I have a date dimension group which has date in raw form. I need to convert below chart which has hour in 12 hours format.
I have used hour_of_day but this gives me 0,1,2,3,4,5,6… 23.
I need dimension as 12:00 AM, 1:00 AM..
Can you tell me how to achieve this?
Solved
1 ACCEPTED SOLUTION
Yes the hour_of_day, as it suggest, will return an integer, no way to format it through excel-style because the underlaying data is not a timestamp. If you had a timestamp you would get your whole time series.
You have to group by something, in this case, it’s an integer, otherwise you would need to do some tweaks and perhaps create an hour_of_day dimension with always the same date (so that it only creates 24 groupings) but thanks to that you would be able to use the formatting.
I tested this like that:
