Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Histogram using times

Hello clever people!   Can you help?  I have a LONG list of people's movements (scan in / scan out), a sample shown below.  I'd like to form a Histogram, counting the culmulative number of people i...
Need Help
  • ankitpatira's avatar
    ankitpatira
    9 years ago
    Anonymous so you create another calculated column with HOUR() function that will give you number in 24 HR format. Use that on x-axis to see peak and dips of people coming in and out during the day.

    =HOUR(timeColumn)
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Anonymous,

     

    To see the peaks and dips in one day about scan in and scan out, you can create a calculated column mentioned by ankitpatira to calculate Hour=Hour([Time]). Then drag a line chart into the report, place "Hour" in Axis property, and "Scan" in Legend and Values (with count aggregate function). See the sample below:

     

     

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks ankitpatira,

This works when all entering or leaving are within 1 hr (MINUTE >0 but <59).  Is there a way of doing this, if you're looking for the stats for people coming/going during a full day?

 

Think of it like an attendance tracker for people who are free to come and go, but we wish to see the peaks and dips through the day.

 

Thanks in advance!

ankitpatira's avatar
ankitpatira
Community Champion
9 years ago
Anonymous so you create another calculated column with HOUR() function that will give you number in 24 HR format. Use that on x-axis to see peak and dips of people coming in and out during the day.

=HOUR(timeColumn)