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.