Solved

Flipping a metric around

  • 11 January 2023
  • 3 replies
  • 18 views

Badge
  • 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
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

 

icon

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.

 

Badge

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!

Reply