DISTINCT COUNT Not Rolling to Quarters

[dunnalahk123]

Hi,

I have Wrote  Below Expression for one of my report but its not rolling to Quarters

=count({$<[NumValue]={1}>}distinct([Project ID])) 

for example Nov =10

Dec=10

Jan=10

Its not showing 30 in Quarter.

Can some help guide me here

[sunny_talwar]

What is it showing when you use the expression?

[dunnalahk123]

Hi Sunny,

Thank you so much for your response.

example i have given.

I guess what happening here is

if we have project ID in Nov and Same Project ID it is in Dec and Jan when it rolls to quarter it is counting only once.

[sunny_talwar]

You want to count it 3 times? Try this

Sum(Aggr(Count({$<[NumValue] = {1}>} DISTINCT [Project ID]), MonthField))

[dunnalahk123]

Hi Sunny,

Thanks a lot Sunny.

It working 🙂 but when i am adding in Chart and all i think i have to add what all Dimensions i am using in my report i have to add along with monthField.

once again thank you so much For your time .