Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
Sorry my bad, i have added could you please check.
Try this
=if([Issue Creation Date] >= vLast3Quarter and [Issue Creation Date] <= vYourMaxDate, [Issue Creation Date])
Thank you so much for your reply, here i have a challenge i would like to show on chart Quarter wise(Q1-2018,Q2-2018,Q3-2018) like information. Any suggestions.
='Q' & Ceil(Month(if([Issue Creation Date]>=vLast3Quarter and [Issue Creation Date]<=vYourMaxDate,[Issue Creation Date]))/3) & '-' & year(if([Issue Creation Date]>=vLast3Quarter and [Issue Creation Date]<=vYourMaxDate,[Issue Creation Date]))
using this expression i have created the Q2-2016 format, But here i want to restrict the 3 Quarters info every time.Please suggest.
i have to restrict the data to show on chart 3 latest Quarters information from current Data(Q2-2018,Q3-2018 and Q4-2018).