Forum Discussion

Icon for Helper IV rank

Helper IV

6 years ago

Solved

Count by TimeSLOT

Hello,,

Thank you for your support and reply,

Please could you help me to calculate reporting interactionID per timeslot by using the column Call end time:

06h-07h

07h-08h

08h-09h

09h-10h

10h-11h

11h-12h

12h-13h

13h-14h

14h-15h

15h-16h

16h-17h

17h-18h

Is this what you want?

timeslot = HOUR('Table'[call end time])&"h-"&(HOUR('Table'[call end time])+1)&"h"

ryan_mayu
6 years ago
ayoubb
right click the column in the value filed to change to count
Click three dot on the top right of your chart, choose sort by time slot and click sort by asc or des to show in order.

16 Replies

ryan_mayu
Super User
6 years ago
ayoubb
Is this what you want?
timeslot = HOUR('Table'[call end time])&"h-"&(HOUR('Table'[call end time])+1)&"h"
- ayoubb
  Helper IV
  6 years ago
  Thanks a lot RYAN, this is exactly what i want, this is below the result i just want to show that from 06h till 18h in chronological order, is this anything i need to add?
  - ryan_mayu
    Super User
    6 years ago
    ayoubb
    maybe try
    column= var timeslot = HOUR('Table'[call end time])&"h-"&(HOUR('Table'[call end time])+1)&"h" RETURN IF (HOUR('Table'[call end time])>=6&& HOUR('Table'[call end time])<=17), timeslot, "")
az38
Community Champion
6 years ago
ayoubb

do you have time slots list in a separate tables?
- ayoubb
  Helper IV
  6 years ago
  No i'm afraid i don't have this in a different column, i want to recover that from "Call end time"
Anonymous
Not applicable
6 years ago
Hi ayoubb ,

See if this solution helps

https://community.powerbi.com/t5/Desktop/Need-help-Creating-a-line-chart-with-time-slots-of-5-minutes/td-p/520987
https://community.powerbi.com/t5/Desktop/Grouping-date-time-stamp-into-5-mins-time-interval/td-p/220458
https://community.powerbi.com/t5/Desktop/How-to-Create-24-rows-for-hour-of-day/td-p/764523

Regards,
Harsh Nathani

Related content