Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All , I have 1 table
ID | Flag |
1 | Yes |
2 | |
3 | Yes |
4 | |
5 | |
6 | Yes |
In Front end Table i Need
Dimension as ID with Flag is yes | Expression 1 : count of Total ID's | Expression 2 : count of ID's with Flag Yes |
1 | 6 | 1 |
3 | 6 | 1 |
6 | 6 | 1 |
How can i get this ?
Please note in Dimension i want to See only ID's with Flag Yes ( 1,3,6 )
Advance Thanks
May be this
Expression 1
If(Flag = 'Yes', Count(TOTAL ID))
Expression 2
Count({<Flag = {'Yes'}>}ID)
May be this
Expression 1
If(Flag = 'Yes', Count(TOTAL ID))
Expression 2
Count({<Flag = {'Yes'}>}ID)