Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)
I have a column with an amount ranging from 0-500. I need to group it into 3 sections 0-100,100-250 and 250 and above. I need to showcase them in the report using diff color.

How can I achieve this?
closed

1 Answer

0 votes
by (47.2k points)
selected by
 
Best answer
  • You can distinctly label the sections using a calculated field:

IF [FieldName] <= 100 THEN "Color 1"

ELSEIF [FieldName] <= 250 THEN "Color 2"

ELSE "Color 3"

END

  • Place the newly created calculated field onto the Color shelf and edit accordingly.

Related questions

0 votes
1 answer
asked Jul 20, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
asked Jul 17, 2019 in BI by Vaibhav Ameta (17.6k points)
+2 votes
3 answers
0 votes
1 answer
asked Feb 11, 2020 in BI by Anup (1.6k points)

Browse Categories

...