Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to use multiple selections with respect to dimension in the line chart?
For e.g.
Name | working days |
Ramesh | 2 |
Vignesh | 4 |
Suresh | 5 |
Ritika | 6 |
Geri | 8 |
From the above table my dimension will be "Name" where measure is "working days"
How to use dimension with selections? e.g. I need only Ramesh, Suresh, Geri to be in dimension
Kindly advise, thank you.
You could define your dimension as:
Aggr(Only({$<Name={'Ramesh','Suresh','Geri'}>} Name), Name)
Or you could define it in the measure using the same set analysis:
Sum({$<Name={'Ramesh','Suresh','Geri'}>} [working days])
Hi Gary,
That's really helped, thank you.