4 Replies Latest reply: Sep 13, 2017 12:44 PM by Tomass Kučinsks RSS

    Calculated dimension

    Tomass Kučinsks

      Hi lads,

       

      [skip introduction],

       

      I have made a graph with group dimension, (day, week, month and quarter). Things are nice and smooth, default dimension is set day. When not a single month is selected QV sums all days, (like normal BI), but what I want is when none month selected graph shows data by months not by days. Bellow is in pictures what I meant.

      Variable = if(count(DISTINCT Master_calendar_Month)>1,Master_calendar_Month,Master_calendar_Day)

      'Master_calendar_Month','Master_calendar_Month' and 'Master_calendar_Day' are dimensions in table. Sadly I receive '//Error in calculated dimension'

      Any tips?

      help.png

      Tomass

       

      Message was edited by: Tomass Kučinsks