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

     

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

 

I could just use Group By on my query and not include the Device column, but that would mess up other visuals in my report where I do need that column. I could also duplicate my query and Group By, but then the slicers and filters I have throughout my report wouldn't work for this new query. How can I solve this?

 

fedpar

 

I don't quite get the problem, but a calculated table based on that query can work with slicer and filters. The calculated table are data aggreagrated by date,user and EngagementTimeBucket, you can create EngagementTimePercentage on this table.

Table = SUMMARIZE(Table13,Table13[Date],Table13[id],Table13[EngagementTimeBucket],"aggreatedCount",COUNTROWS(Table13))


 

If you have any question, feel free to let me know.