Forum Discussion
Bucketized and grouped line chart
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?
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.
But...if I summarize after creating the buckets, wouldn't that lead to incorrect data? Correct me if I'm wrong, but let's say I have the following table:
And I summarize with like in your example. This should be the result:
Thus, looking at the first three rows, the buckets are now incorrectly labelled. Additionally, because I now have another table in my report, any Report level filters I apply using the original table's values will not be applied on the new table's values.
Thank you! :)
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...
That looks awesome! Guess it's not possible to do it without the additional table, then. Thank you!
