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.

     

ayoubb's avatar
ayoubb
Icon for Helper IV rankHelper IV
6 years ago

I have done exactly what you said, but the result in chart should be: 

from 06h-07h till 17h18

 

and not to depend to how many hours taken!

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
6 years ago

ayoubb 

 

Could you please create a chart in excel to show the expected output that you want?

 

  • ayoubb's avatar
    ayoubb
    Icon for Helper IV rankHelper IV
    6 years ago

    I have a data base of entered like this one below with a column named "Call end time":

     

    i want to do a chart like this one below that respect chronological order from 06h-07h till 17h-18h, and count how many entered by slot, like you see below:

     

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    6 years ago

    ayoubb 

    please created a column that I mentioned.

     

    put any column in the value field and change to count

    unselected blank value in timeslot

     

     

  • ayoubb's avatar
    ayoubb
    Icon for Helper IV rankHelper IV
    6 years ago

    where to find to change it to count, 

    please take a look and tell me if this is what you asked exactly, the slot still not organized chronogicaly ?

     

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    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.