funnel chart using a range as a dimension

[#1]

I have a column called sale_amount. I want to have a funnel chart that shows (by percentage) which sales are over 3000, between 2000 - 3000, between 1000 - 3000, and below 1000. So one colored area of the funnel chart would be sales over 3000 and so on. Here's an example of a funnel chart for sale_amount based off location ( blue is northeast and the others are other areas):

so i want basically the same thing but with the ranges described above. Not sure how to do this. Maybe through a calculated dimension?

[#2 · Accepted solution]

Hi,

Try to create a new dimension as : if( sale_amount < 3000 , Class( sale_amount , 1000) , '>= 3000' )

regards

jj

[#3]

perfect, thanks Jean