Flipping a metric around

  • 11 January 2023
  • 3 replies

  • Enthusiastic Pigmenteer
  • 15 replies

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


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



Best answer by Stef 11 January 2023, 16:24

View original

3 replies

Userlevel 3
Badge +2

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 👍

Userlevel 3
Badge +2

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