3 Replies Latest reply: Apr 6, 2018 2:09 PM by Sunny Talwar RSS

    General Reference to X Axis Dimension

    Jamey Copeland

      Hello,

       

      I am creating a reference line on a scatter chart where the x axis is set by a drop down from the variable extension. I would like to change the reference line expression depending on the axis value.

       

      So far I have tried something like this:

      Median(Aggr(Sum({$<BookFscYearStr = {'2017'}, FiscalQuarter = {'Q1'}>}NETSALESAMTUSD), If(vVariableSelector = 1, Region,Platform))

       

      The expression doesnt seem to like the If Statement in the Aggr function.

       

      I was thinking that if there was a generic way to refer to the x dimension than this wouldnt be an issue.

       

      Something like:

      Median(Aggr(Sum({$<BookFscYearStr = {'2017'}, FiscalQuarter = {'Q1'}>}NETSALESAMTUSD), x.dim)

       

      However I havent found a way to generically refer to the x dimension.

       

      Any ideas?