Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
in this thread i asked Expression - Filter for dimension
if i use a dimension in a chart and want to filter the values of the dimension, how can i do it?
The answer was for example
=if(Name='*Samsung*',Name,Null())
Now i want to use Max() in an expression like this:
=if(date = Max(Total date,2),Sales,Null())
The editor shows "ok", but the chart table shows only grey fields.
I test this expression
Max(total date,2)
and this one
=if(date = Max(Total date),Sales,Null())
Both shows the correct data.
What´s wrong in this expression?
=if(date = Max(Total date,2),Sales,Null())
regards,
sam
Try this
=Aggr(FirstSortedValue(Number, -sDate) - FirstSortedValue(Number, -sDate, 2), Product)
What is the dimension here? and I am guessing that you are using this as an expression?
I use a chart table, create a new dimension and in the fieldname i write this expression:
=if(date = Max(Total date,2),Sales,Null())
You need an aggregation, you have to choose by which field
Maybe this
Aggr(if(date = Max(Total date),date,Null()),date)
Do you have more than one dimension?
yes 8 dimensions
And are you only looking to get the 2nd highest date across all these 8 dimensions?
No, in other dimensions i´m looking for the 1st highest date.
Not sure I am understanding the requirement... would you be able to share some sample data or a sample app?
Yes...