3 Replies Latest reply: Dec 22, 2016 5:39 AM by ExtremelyFrustrated ToFillinThisFormForEachUpgrade RSS

    Use the key as dimension but show values from other fields

    ExtremelyFrustrated ToFillinThisFormForEachUpgrade

      I have an ID filed, which I want to use as dimension, but what should be displayed is the value of other fields on a condition.

      So, let's say the data is:

       

           ID, type, label 1, label 2, measure

       

      I want measure to be for the ID, but what should be displayed in chart as dimension, is 'label 1', if type='A', or 'label 2' if type='B', and the ID when the type filed is empty.