Forum Discussion

vrocca's avatar
vrocca
Icon for Advocate IV rankAdvocate IV
9 years ago
Solved

Plotting values across days and time

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!

 

 

Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

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

4 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Icon for Super User rankSuper User
    9 years ago

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

    • vrocca's avatar
      vrocca
      Icon for Advocate IV rankAdvocate IV
      9 years ago

      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's avatar
        v-micsh-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        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's avatar
    spuder
    Icon for Resolver IV rankResolver IV
    9 years ago

    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. :smileyhappy:

     

    line chart order count by day/hour

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Greetings