8 Replies Latest reply: Nov 3, 2015 9:02 AM by Andrew Mein RSS

    User selected x-axis

    Andrew Mein

      afternoon,

       

      I have created an Inline table as:

      LOAD * INLINE

      [

      Date_Num,Date_Group

      1,'Date'

      2,'Week'

      3,'Month'

      4,'Quarter'

      5,'Year'

      ];

       

      and would like the user to select an option from the drop down and have it change the grouping of a chart.

      I created the Master Item:

      IF(Date_Num=1,Active_Date,IF(Date_Num=2,Active_Week.... etc.

      but when nothing is selected, it shows all groupings on the x-axis (once the user selects a single option it works as expected)

       

      I have tried adding a MIN(Date_Num) in - but I don't think the x-axis likes that

      IF(MIN(Date_Num)=1,Active_Date,IF(MIN(Date_Num)=2,Active_Week....etc.

       

      Has anyone got something like this working before?