Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
How to use cyclic group in expression?
I have dimension
Time group (MYear, QYYYY)
and expression
Count({<[qID_3_Task completion]={'Yes'}>} [qID_3_Task completion])/
Count(TOTAL <[MYear,QYYYY]> [qID_3_Task completion])
What should I use instead of MYear, QYYYY?
Thanks,
Try:
Count({<[qID_3_Task completion]={'Yes'}>} [qID_3_Task completion])/
Count(TOTAL <$(=GetCurrentField([GroupName]))> [qID_3_Task completion])
Replace GroupName with the name of your cyclic group.
Try:
Count({<[qID_3_Task completion]={'Yes'}>} [qID_3_Task completion])/
Count(TOTAL <$(=GetCurrentField([GroupName]))> [qID_3_Task completion])
Replace GroupName with the name of your cyclic group.