Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below requirement.
I have a date field called [Report Date] in DD/MM/YYYY format.
I have to calculate the YTD in the below set analysis
i.e, The number of issues that have been completed from jan 01 to till the previous month.
I have many years in filter pane i have to restrict to max(year) jan 01 to till the previous month
My set analysis expression is
=count({<Status={'Completed'}>}distinct Issues)
Please help me to write the above YTD expression.
Thanks in advance.
Or this
=Count({<Status = {'Completed'}, [Report Date] = {">=$(=Date(YearStart(Max([Report Date])), 'DD/MM/YYYY'))<$(=Date(MonthStart(Max([Report Date])), 'DD/MM/YYYY'))"}, Month, Day, Week, Quarter>} DISTINCT Issues)
try this
=count({<Status={'Completed'},[Report Date]={">=YearStart(Max([Report Date])) <MonthStart(Max([Report Date]))"}>}distinct Issues)
this will calculate from 1 st of Jan to Previous month end
Can you try this?
Count({<Status={'Completed'},[Report Date]=, DateNum={">=$(=Num(YearStart(Max(DateNum))))<=$(=Max(DateNum)-1)"}>} distinct Issues)
..
where DateNum = Floor([Report Date])
May be this?
=count({<Status={'Completed'}, DateField = {">=$(=YearStart(Max(DateField)))<=$(=AddMonths(Max(DateField),-1))"}, Month, Day, Week, Quarter>}distinct Issues)
Or this
=Count({<Status = {'Completed'}, [Report Date] = {">=$(=Date(YearStart(Max([Report Date])), 'DD/MM/YYYY'))<$(=Date(MonthStart(Max([Report Date])), 'DD/MM/YYYY'))"}, Month, Day, Week, Quarter>} DISTINCT Issues)