Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |