1 Reply Latest reply: Feb 18, 2017 7:13 AM by Marcus Sommer RSS

    Create Dimension based on Calculated Measure

    Prasanna Chandran

      In my chart, I calculate a measure. Let's say the calculated measure name is 'Difference' which is populated using the variable v_diff.

       

      Now I want to set flags based on the value of 'Difference'.

       

      I create a new dimension named 'Flag' and put the expression as follows.

       

      if($(v_diff) > 1000, 'Yes','No'). When I complete this, I get the result as invalid dimension. But it works if I define it as measure. Unfortuantely, I want it as only dmension so that I can filter based on the value of 'Flag'.

       

      Is there any way to do this?