Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

make time slots of 15 mins.

Hi all,     Need a help.   1)I want to create a time slots of 15 min as 00:00-00:15,00:15-00:30,00:30-1:00,.....23:45-00:00 . also, 2)I have a calculated column as activity start time and end t...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

1. create a time slots of 15 min

Refer to this link :

http://datacornering.com/how-to-generate-date-and-time-interval-list-using-power-query/

 

2. What would you like finally?

A visual which shows counts of activities during each time period(every 15 minutes)?

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

     Thanks for the link but it is not useful.

I want to create heatmap (using matrix visual) to show  all timeslots (from 00:00-00:15 ....,23:45-00:00)for 24 hours(with 15 min gaps) on x axis and on y axis activity name.I need a count corresponding  to any activity happens for how many time in which time slots.

 

for time slots ,i need in a way that if activity no 5 is  starts at 2:09  and ends at 2:58 then it ll give me count 1 in all the time slots from when it starts till when it ends.

2:00-2:15,2:15-2:30,2:30-2:45,2:45-3:00