Forum Discussion
Bucketized and grouped line chart
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!