Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
Wondering if anyone has some ideas/suggestions on a way to visualize the number of x occurences by Day and Time, with the goal of easily seeing the intersection where most occurences occur (i.e. X event happens most often on Fridays at 6PM).
I was thinking of a scatter chart, but I can't put non-aggregatable values on my X , Y axis. Thoughts?
Thanks!
Solved! Go to Solution.
You can use R but you would not get that slice & dice of the data interactivity.
You can use R but you would not get that slice & dice of the data interactivity.
Thanks Bhavesh. I was thinking I may have to go down that route as well, though I'm not as familiar with R so it may prove more challenging.
Below is a screenshot of how the data is currently visualized in a different tool. From this chart, you can easily spot the day and time when most events occur.
Thanks,
Victor
Hi vrocca,
Have you checked the calendar visual in Visual Gallery?
Which would show the date in a calendar format, and display the values in color. Check the article and see if it would help here.
Regards
Hi vrocca,
I'm not sure if I understood you right.
But I suggest to use a simple line chart. Extract Weekday and hour from your DateTime Values and count the values.
The result should be something like that.
You can even add a hierarchy to drill from the day to day/hour level.
Don't be irritated by the names of the days. It is German language.
Greetings
User | Count |
---|---|
99 | |
90 | |
85 | |
74 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |