search

tableau / extension-quick-what-if

A dashboard extension that allows you to create a list of controllable inputs based on values of a dimension for quick what-if analysis.
MIT License
2 stars 3 forks source link

Multiple Dimensions in LOD #4

Closed Krishnakanthdev closed 3 years ago

Krishnakanthdev commented 3 years ago

Hi I am unable to pass mutiple dimensions in the LOD function. *eg: SUM([Net Sales])(1+(MIN(

{FIXED [Class],[Sub Class]: MIN(FLOAT(REGEXP_EXTRACT([What if extension ], [Class],[Sub Class}+"|(-?\d.?\d)")))}

)/100))**

here I would like to do a what-if analysis at the SUBCLASS level.

KeshiaRose commented 3 years ago

Hi @Krishnakanthdev, instead of using multiple dimensions you will need to select just one for your setup and calculation. So in this case you should just use [Sub Class]. If a Sub Class can belong to multiple Classes then create a combined field with a calculation like: [Class] + "-" + [Sub Class] and use that as your dimension instead. Let me know if you get it working! -Keshia