Related threads you might find useful,
Hope this gives you some direction.
Lauren_v10.5.twbx 345.3 KB
The problem is that our goals are just a set amount per line. So POPS goal would be 50 and POLS might be 80. There is no formula to determine per line. And I can’t figure out how to get those goals into a formula to do what you’ve described on your workbook.
Business Analyst Manager
Sorry couldn't spend much time this morning to try this out, but I found these links which I hope will get you started. You might want to use Parameters to user input the goal values.
Let us know if you need further help.
Unfortunately these also do not help because our POPS and POLS are measures, not dimensions. So I can’t say “If Dimension = ‘POPS’ then , etc. That is where I am getting stuck.
1 of 1 people found this helpful
I'm not sure if this is going to work for your setup,but here is one method that might give an idea:
The main issues are, as you've seen, that:
-MeasureNames/MeasureValues can't be addressed in a calculated field or Index
-calculated fields can't be pivoted
I'm not sure if the method in the link above will work for your true dataset,
but I tried it out.
Basically, I made an external excel worksheet which is simply
a column header "MetaName" and then POPS and then POLS.
This is added as a new datasource.
Then on a new sheet with the new excel as the Primary datasource,
I created the calculated field:
CASE ATTR([Meta Name])
WHEN "POPS" THEN [OLGA Test (OLGA Test)].[POPS]
WHEN "POLS" THEN [OLGA Test (OLGA Test)].[POLS]
The Goals then became:
IF [Meta Name]="POLS" THEN 4
ELSEIF [Meta Name]="POPS" THEN 1
I'm not completely sure about the values that are showing for POLS and POPS
because it was sounding like they were supposed to be less than 1.
Regardless, I think the general idea should work.
Likely this can also all be done in Tableau Prep as well.I will investigate.
Please see workbook v10.5 attached in the Forum Thread.
That did the trick. Thanks so much!!!!