Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi ,
I I want to incorporate conditional dimension in straight table,How to do so..
eg:
I have data like
state id name year
haryana 1 a 2012
Gujrat 2 b 2012
haryana 3 c 2013
hp 4 d 2014
I want to make straight table which is having dimensions as state,id and name for only haryana state. and I want to do this filteration in front end..
Thanks in anticipation
You need to put set analysis into the expression {<state={'haryana'}>}.
If you don't have any measures and you're want a straight table nevertheless, I recommend you to put state, id, name as dimensions and add year as an expression using the only() function, e.g. =Only({<state={'haryana'}>} year).
This should work.
You need to put set analysis into the expression {<state={'haryana'}>}.
If you don't have any measures and you're want a straight table nevertheless, I recommend you to put state, id, name as dimensions and add year as an expression using the only() function, e.g. =Only({<state={'haryana'}>} year).
This should work.