Forum Discussion

fedpar's avatar
fedpar
Microsoft 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
Memorable 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
    Microsoft Employee
    10 years ago

    Wouldn't I have to do something before I generate the buckets? By creating the buckets as they are now, the rows are incorrectly bucketized because they are taking the Device into account.

  • fedpar's avatar
    fedpar
    Microsoft 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...