
1. Re: Show all possible values pie chart (calculated field)
Sankarmagesh Rajan Sep 17, 2018 10:02 PM (in response to julian.ramirez.0)hi Julian
Try with sum
If SUM([Price])<5 then "<5"
elseif SUM([Price])>5 and SUM([Price])<10 then "510"
elseif SUM([Price]) >10 and SUM([Price]) <20 then "1020"
elseif SUM([Price]) >20 and SUM([Price]) <30 then "2030"
else "No range"
END

2. Re: Show all possible values pie chart (calculated field)
Chandran Sathish Sep 17, 2018 10:42 PM (in response to julian.ramirez.0) 
3. Re: Show all possible values pie chart (calculated field)
julian.ramirez.0 Sep 17, 2018 10:31 PM (in response to Sankarmagesh Rajan)Thanks for your answer Sankarmagesh but it stills the same
Regards

4. Re: Show all possible values pie chart (calculated field)
Sankarmagesh Rajan Sep 18, 2018 12:49 AM (in response to julian.ramirez.0)hi
Please attach workbook
thanks
sankar

5. Re: Show all possible values pie chart (calculated field)
julian.ramirez.0 Sep 18, 2018 7:37 AM (in response to Sankarmagesh Rajan)Can't see attached workbook

6. Re: Show all possible values pie chart (calculated field)
Eric Van Blargan Sep 18, 2018 8:47 AM (in response to julian.ramirez.0)Hi Julian,
Try this:If price > 30 THEN ’30 +'
ELSEIF price > 20 THEN ’2030’
ELSEIF Price > 10 THEN ’1020
ELSEIF Price > 5 THEN ‘510’
ELSEIF price > 0 THEN ‘< 5’
ELSE ‘No Range’
ENDStart with your highest category and work your way down to the end. Tableau will do the 'between' calcs (< x and > y) automatically, by saying "x category is bigger than y category".

7. Re: Show all possible values pie chart (calculated field)
julian.ramirez.0 Sep 18, 2018 5:33 PM (in response to Eric Van Blargan)Hi Eric,
Still the same. Values that are not now can't be shown