Forum Discussion

fedpar's avatar
fedpar
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago
Solved

Bucketized and grouped line chart

I'm stumped with how to proceed here. I have a line chart that shows the bucketized engagement time of users on our devices. However, the line chart aggregates usage per user per device, and I only w...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    fedpar I've outlined the steps I take and formulas I use to solve this in the picture below...

     

     

    And here's the result

     

    I think this should work!

     

    I tried doing this without a Summary table but got stuck...

    Here's how far I got...

     

samdthompson's avatar
samdthompson
Icon for Memorable Member rankMemorable Member
10 years ago

assuming that the first column is user id, change the formula to:

 

calculate(sum([engagementime]),allexcept(table,table[userid]))/ denominator

fedpar's avatar
fedpar
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Thinking about it a bit more, I'm not sure how the proposed solution can work. Removing any column would not solve the problem, as the data would still not be grouped by the Device, and would thus perform no additional aggregation and change nothing.

 

Again, my guess is that the change would have to be made the moment I create the EngagementTimeBucket column, but I'm not sure how to approach this...