Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone ,
I have dimension in order to show only 2012 values (=if(right(VARDIYARAP_ACILISTARIHIAYYIL_,4)=2012,VARDIYARAP_ACILISTARIHIAYYIL_))
I want count ID for 2012 values based on dimension above
Hi
Hope below expression will help you
= count(if(right(VARDIYARAP_ACILISTARIHIAYYIL_,4)=2012,VARDIYARAP_ACILISTARIHIAYYIL_))
Regards
Krishna S
What do you count here There is no ID statement
Try this
= count(if(right(VARDIYARAP_ACILISTARIHIAYYIL_,4)=2012,ID))
Since you already filtered out the 2012 dates in your dimension, I don't think you have to put another filter in your expression.
Doesn't just =Count(ID) give you correct result?
It is a pie chart and there is no date dimension there
Then how about using 'set' in the expression
=Count({<right(VARDIYARAP_ACILISTARIHIAYYIL_,4)={'2012'}>} ID)