Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have this expression =count(year([Medal.Won/Lost Date])>='2015') and I want it to show only the data from 2015 and beyond but when I 'clear all', its originates back to all the data from previous years too.
What am I doing wrong? Do I need to set >= 2015 parameter in the dimensions rather than the expression? Thanks in advance.
Hi,
You can create a Calculated Dimension. If(year='2015','2015')
And expression count(medal won/last date)
But if you like always show the year youn need to use set analysis and use parameter 1.
Count(1{<Year={'2015'}>}medal won/last date)
Regards
Hi Stephen,
sorry, I don't quite understand your scenario - is this an expression in a chart?
Then it should be independent of selections and when you click "Clear all", that should not affect your chart?`
(that said, to ´promote user_friendliness, I would suggest not putting any limitation in either the chart_dimension nor the chart_expression, but to use an automatic selection (upon opening the sheet) to activate that.
HTH
Hi DN,
Thanks for the reply and I am not familiar with the automatic selection function.
My query is an expression in a straight table and when I 'clear all', my data will show from 2003 to 2020 instead of 2015 to 2020.
Hi,
You can create a Calculated Dimension. If(year='2015','2015')
And expression count(medal won/last date)
But if you like always show the year youn need to use set analysis and use parameter 1.
Count(1{<Year={'2015'}>}medal won/last date)
Regards
Hi
Try like this
Year as Dimension
exp:
If(isnull(Getcurrentselections()), count(Exp) , Count({<Year = {">=2015"}>}Exp))
isnull(Getcurrentselections()) is return null, when there is no selection in any field. suppose your expression need to based on any particular field, then change like this
= if(GetselectedCount(FieldName) = 0, count(Exp) , Count({<Year = {">=2015"}>}Exp))