I have a below table and as you can see there is only one "Loss" for each model per location.
If I want to show the absolute difference between the models per location, can I do it in Tableau while I have them all in one column?
My concern is creating a calculated field within one column having a condition (the result should look like below).
Hi Mehdi ,
Create a calculation like below
SUM(IF MODEL = 'AIR' THEN Loss END)
SUM(IF MODEL = 'RMS' THEN Loss END)
Drag the Long and Lat to columns and the created calc field to text
you will get the O/P
hope this helps
Plz mark this answer as correct & helpful to close the thread
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...