Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a table in datamodel like below
Rec No | product | Flag |
1 | AB | 0 |
1 | AA | 0 |
2 | BB | 0 |
2 | BC | 0 |
3 | CV | 0 |
3 | CD | 0 |
3 | CF | 0 |
4 | GH | 0 |
4 | GT | 0 |
4 | GY | 0 |
1 | AC | 1 |
2 | BD | 1 |
3 | CN | 1 |
i want output like below , because rec_no 4 should not share with both flag values , it has value 0 only
Remaining all records share flag values 1 and 0 both
Rec_ No | Product |
4 | GH;GT;GY |
How to write chart expession in front end to get above output
is there any possible to find count in KPI measure,
here count is 3
is there possibility to find the count of product in KPI as 3