Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
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)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94k users

Browse Categories

...