Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
Try to create a new dimension as : if( sale_amount < 3000 , Class( sale_amount , 1000) , '>= 3000' )
regards
jj
Hi,
Try to create a new dimension as : if( sale_amount < 3000 , Class( sale_amount , 1000) , '>= 3000' )
regards
jj
perfect, thanks Jean