Forum Discussion

ayoubb's avatar
ayoubb
Icon for Helper IV rankHelper 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 09...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    ayoubb 

    Is this what you want?

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

  • ryan_mayu's avatar
    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.

     

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper 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's avatar
    ayoubb
    Icon for Helper IV rankHelper 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's avatar
      ryan_mayu
      Icon for Super User rankSuper 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, "")
      • ayoubb's avatar
        ayoubb
        Icon for Helper IV rankHelper IV
        6 years ago

        Something goes wrong, please advise?