Plotting values across days and time

[vrocca]

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!

[BhaveshPatel · Accepted solution]

You can use R but you would not get that slice & dice of the data interactivity.

[vrocca]

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

[v-micsh-msft]

Hi vrocca,

Have you checked the calendar visual in Visual Gallery?

Calendar Visual

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

[spuder]

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. 

line chart order count by day/hour

Greetings