Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have created a Variable in the Variables
vCurrentSelection =SubField(GetCurrentSelections(), ':',2)
and now I am trying to use the variable in Set analysis, but it is not working
=Count({<[Session Name] = {"$(=vCurrentSelection)"}>}[Session Name])
Can someone help me with this.
thanks in advance.
Naresh
$Field is a system generated field which stores all the field names in your dashboard.... You can add it as a dimension by typing it out.
I have created a small sample for you to check out.
Sample data
Table:
LOAD * INLINE [
Field1, Field2, Field3, Field4
XYZ, JAB, ASH, XYZ
DEF, KKL, JJA, KKL
JAB, AHH, XYZ, XYZ
];
Look here for $Field and other system generated fields
Thanks Sunny Paaji... Worked absolutely fine.
Learnt couple of things from you today.
Thanks,
Naresh
I am glad I was able to help you out