Calculated dimension

[Anonymous]

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?

Tomass

Message was edited by: Tomass Kučinsks

[Anil_Babu_Samineni]

Can you take expression and show the full expression image where you receiving error?

[Anonymous]

When I calculate variable, I receive an error in dimensions, mentioned in a snap. When I run it in the text box, it returns '-'.

Formula I'm using =  if(count(DISTINCT Master_calendar_Month)>1,Master_calendar_Month,Master_calendar_Day)

[Anil_Babu_Samineni]

What this returns in text box?

if(Aggr(count(DISTINCT Master_calendar_Month),Master_calendar_Month)>1,Master_calendar_Month,Master_calendar_Day)

[Anonymous]

It still evaluates it as '-', but now at least we got a working expression in dimension group at some point. Your proposed solution is evaluated as 'Master_calendar_Day', so as I understand, it returns always FALSE from if formula. I thinking about making workaround formula in expression tab.