How to use cyclic group

Anonymous — Tue, 31 Dec 2013 16:46:28 GMT

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,

Re: How to use cyclic group

Nicole-Smith — Tue, 31 Dec 2013 16:49:38 GMT

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.