Forum Discussion
Automatic grouping data by range
I have manually grouped the data as seen in the below screenshots. Is there a way to automatically group this data so I do not have to go back and edit every time new data is added into my datas...
Hi,
Create a table like this and name it Buckets
Lower Upper Bracket 0 30,000 0 - 30K 30,000 2,50,000 30 - 250K 2,50,000 6,80,000 250 - 680K 6,80,000 10,00,000 680K - 1M 10,00,000 10,00,00,000 > 1M Write this calculated column formula
Column = CALCULATE(MAX(Buckets[Bracket]),FILTER(Buckets,Buckets[Lower]<='Table'[original contract value]&&Buckets[Upper]>='Table'[original contract value]))Hope this helps.
I cannot help without a file.
Hi Ashish,
Thank you. Please see file attached.
I would like too create groups for the column 'original contract value (groups)' that reflect the ranges in the pie chart below. These groups will be auto-updated instead of manually updated in the pie graph. Is this possible?
How do I attach a file to this thread?
Christiana
Hi,
Upload the file to Google Drive and share the download link.
Please see link below.
https://drive.google.com/file/d/1q4wj30g8gLUtfuy11cDUG9BTFr2qM1fp/view?usp=sharing
Thank you.
Hi,
Create a table like this and name it Buckets
Lower Upper Bracket 0 30,000 0 - 30K 30,000 2,50,000 30 - 250K 2,50,000 6,80,000 250 - 680K 6,80,000 10,00,000 680K - 1M 10,00,000 10,00,00,000 > 1M Write this calculated column formula
Column = CALCULATE(MAX(Buckets[Bracket]),FILTER(Buckets,Buckets[Lower]<='Table'[original contract value]&&Buckets[Upper]>='Table'[original contract value]))Hope this helps.