timeline by time of the day

[salqthami]

Hi guys,

I have a retail store in a mall and I would like to monitor in/out traffic of my store. the issues are I do not know how to deal with the timestamp how to convert it to a group of times which shows how many people entering/exiting my store per hour.

can anyone help me to understand how to do that?

Thanks in advance

[v-shex-msft · Accepted solution]

HI @salqthami,

I'd like to suggest you add calculated column to extract hour from timestamp, then you can use hour as axis to create visualization graph. (hour to axis, distinctcount of customers to value fields)

Regards,

Xiaoxin Sheng

[salqthami]

Hi guys, I have a retail store in a mall and I would like to monitor in/out traffic of my store. the issues are I do not know how to deal with the timestamp how to convert it to a group of times which shows how many people entering/exiting my store per hour. can anyone help me to understand how to do that?

Thanks in advance