Skip to main content

I think this is a simple problem, but it probably isn’t. 

I have a metric (Metric - Is locked) of type: Dimension (Locked) with only Yes or No as options. 

Dimension: Version Metric: Yes/No
Actuals

Yes
Plan Yes
Forecast No

 

Can I easily flip this around to show the inverse of the metric (here using firstnonblank)?

Dimension: Locked Metric: Version
Yes Actuals
No Forecast

 

Hi @agnar,

 

You can, please see below a screenshot. You were right on the syntax!

Hope this helps, please note you will lose the “lock status” for the “Plan” version as it does get ignored because of the FIRSTNONBLANK aggegrator. Not sure what your end goals is here so might not be an issue.

 

Thank you! This does exactly what I was looking for. Too bad my end goal involves a much more complex structure. But this did indeed block my thinking 👍

Great to hear. If you need any more support with that end-goal feel free to reach out!

Reply


Ask your question here!

Terms & ConditionsCookie settings