Sorry, I didn't understand your question, do you want to take out the measurements units?
Sales 120,000 Profit % 15 Units Sold
or do you want to extract the measuring units into another field
Sales 120,000 $ Profit % 15 % Units Sold
This is an example,
KPI This year Last Year This year vs Last year
Sales $ $135,000 $120,000 5%
Amount # 38 # 35 # 7%
Profit % 22% 20% 10%
Each row has a different unit measure,,, and I want to be able to present those units in Tableau... so when a line refers to a percentage,,, it becomes easy to read the table...
Information from that table will be pre-processed,, there are many rows in the same report... and several columns as well.. so I decided to pre-work the table, and just present processed information in Tableau... but I cant get to display % and # depending on the KPI name...
I am trying something like this, but It doesnt work..
THEN [amount with #] ELSE [amount]
The idea is to put an amount including the % or #... or putting just the amount (without symbol) depending on columns content.
THEN [25 #] ELSE 
1 of 1 people found this helpful
Hi Cecilia, sorry for the late response, was a crazy week hehe.
so you want to concatenate the symbols. like $ + 135,000 --> $135.000. To do this you need to convert your measures to string so you can add the symbol.
THEN STR([this year]) + "#"
THEN "$" + STR([this year])
ELSEIF //All your other KPIs
you will have to be very carefull with percentages as the percentages sometimes came as 0.25, you will need to multiply for 100 then concatenate the % symbol, like:
IF [indicator] = 'percentage_field'
THEN STR([value]*100) + "%"