Error on calculated dimension

[NavinReddy]

Hello All,

Can someone help me on calculated dimension its not working for me,
i would like to disply 3Quarters info on dimention.
pleases check attached sample QVW for reference.

Thanks in Advance,
Niranjan

[NavinReddy]

im able to see two Quarters information on chart,for One Quarter i do not have any data reason its not visable on chart,

Could you please help me with logic, i want to display 3rd Quarter info with zero values.

[sunny_talwar]

Can you post the updated qvw file to see what you have? Thanks

[NavinReddy]

i have added the qvw, i am able to only one quarter info, how could i get 3 Quarters information.

[sunny_talwar · Accepted solution]

Try this

Dimension

=if([Issue Creation Date]>=vLast3Quarter and [Issue Creation Date]<=vYourMaxDate,'Q' & Ceil(Month([Issue Creation Date])/3) & '-' & Year([Issue Creation Date]))

Expression

=Count(DISTINCT{<[Issue State Name]={'New and Open','ReOpened'}, Year, Month>}[Issue ID])
=Count(DISTINCT{<[Issue State Name]={Completed}, Year, Month>}[Issue ID])
=Count(DISTINCT{<[Issue State Name]={Open}, Year, Month>}[Issue ID])

[NavinReddy]

Thank you very much sir, its working