ayoubbHelper IV6 years agoSolvedCount 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...Show Moreryan_mayu6 years agoayoubb Is this what you want?timeslot = HOUR('Table'[call end time])&"h-"&(HOUR('Table'[call end time])+1)&"h"ryan_mayu to ayoubb6 years agoayoubb right click the column in the value filed to change to countClick 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_mayu6 years agoayoubb Is this what you want?timeslot = HOUR('Table'[call end time])&"h-"&(HOUR('Table'[call end time])+1)&"h"ryan_mayu to ayoubb6 years agoayoubb right click the column in the value filed to change to countClick 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_mayu6 years agoayoubb Is this what you want?timeslot = HOUR('Table'[call end time])&"h-"&(HOUR('Table'[call end time])+1)&"h"
ryan_mayu to ayoubb6 years agoayoubb right click the column in the value filed to change to countClick 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.
ayoubbHelper IV to az386 years agoNo i'm afraid i don't have this in a different column, i want to recover that from "Call end time"
ayoubbHelper IV to az386 years agoNo i'm afraid i don't have this in a different column, i want to recover that from "Call end time"
