Forum Discussion

philip657's avatar
philip657
Regular Visitor
7 years ago

Line chart of daily adverage

I have a data set that is of user actions thought a day, for 5 months. 

 

I would like a line chart to show the  colate all Mondays data togeather ( no mater the date) and then take adverage of each task, and then do the same for the rest of the week, so we can see on adverge the tasks change over the differnt days. 

 

Also i am looking at a dataset with times, if i need a bar chart that groups everyhting that happend in a 15 min intvall into one bar, and then   repeate for the rest of the 24 hours.

 

Hope this all makes sence.

Need Help

2 Replies

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    7 years ago

    Hey philip657 ,

     

    you might consider to create a pbix file that will contain some sample data, upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.

     

    Regards,

    Tom

    • philip657's avatar
      philip657
      Regular Visitor
      7 years ago

      Thanks, 

       

      The data is here.

       

      https://www.dropbox.com/s/4ehe7n12kybp2t9/demo.pbix?dl=0

       

       I am trying to get Level 2 Dicussion of "no decision"  by  so i know what the adverage is per day of the week.  ( so all mondays show togeather, and the same for the other days.   I would  like to also try and do this in smaller blocks per day, so per 15 min blocks. 

       

      I just cant work out how to make this happen.