Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have data like below
ID | Description |
1 | yes 100% |
2 | No |
3 | yes 100% |
4 | it was Compliant |
1 | Y it was |
Need to create flag for Column Description where value is yes or y.
even what would be set analysis to only count Description where is yes or Y ?
Hi
maybe you could use something like this
If(Upper(Left(Description,1))='Y','Y','N') AS FLAG
what would be the set analysis ?
Count ({<FLAG={'Y'}>} Description)
without using flg column then write the set analysis
Count({<Description={'y*'}>}Description)