Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi folks,
I have a table :
A | 1 |
A | 2 |
B | 4 |
B | 5 |
And i want select value from second column and put in KPI
If you User select A: then in one KPI should be value 1 and in another 2
FieldValue() works but i don't know how to connect it t current selection.
Thank you in advance
Ok, it's done
[Level2] = {"$(=SubField(concat(distint Level2, '@'),'@', 7))"}
Almost did it, but my code not working fully
Count({<[LastResultOutcome]={'Passed'},
[Level 2] = {"=SubField(concat(distinct Level2, '@'),'@', 7)"}
//[Level2] = {'OEE'}
>}distinct [Id])
Hi , @sunny_talwar, could you please help me how to put SubField(concat(distinct Level2, '@'),'@', 7) in set expression, thank you
Ok, it's done
[Level2] = {"$(=SubField(concat(distint Level2, '@'),'@', 7))"}
Hi,
I have similar requirement. I want get the value of field based on selection of another field value.
Could you please explain the above solution? Thanks!