Forum Discussion
Convert to 30min interval
Hello All,
I am trying to plot a line graph with two variables—time in 30min intervals on the x-axis and count of #ppl in that time frame.
How to convert this column to represent time in every 30min interval? Many thanks for considering my request.
You can make it easily:
1. Adjust the formulas to AM PM format2. Create a table in power query with you categories and add index (make sure to filter cate category by the index)
3. Create relationship between the two tables
4. Voila
5 Replies
Here you go 🙂
Thanks for this solution. will use this if I cannot make it to this format below: (not sure how to aggregate to this model tho)
You can make it easily:
1. Adjust the formulas to AM PM format2. Create a table in power query with you categories and add index (make sure to filter cate category by the index)
3. Create relationship between the two tables
4. Voila
