Hi Team,
=Count(DISTINCT{<Incident={"=resolved_Date<=Targetdate"}>}Incident_Number)/count(DISTINCT{<resolved_Date={"*"},Targetdate={"*"}>}Incident)
I am facing a issue on finding the YTD percentages in barchart.
I need to show Month and YTD percentages in barchart in seperate bars for every month of current Fiscal year I.e April 2016 to March 2017
I am able to get the exact percentage values for Month bars by using above expresion.
but for YTD I am not getting correct outputs.As per my knowledge It is not taking accumulation
So can any one please give the expression for YTD by using above expression ....
The calculation of YTD would be if it is september month it should be taken from April to september
August month it should be taken from April to August
There is no filters like Month and Year
Thanks,
Chinnu
