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.
In the KPI I have used the below expression.
=if(len(GetFieldSelections(MonthYear))=0,Count({<MonthYear={'$(=MonthName(Max(Date)))'},STATUS-={'Failed'}>}distinct id),
Count({<STATUS-={'Failed', 'Completed','Withdrawn'}>}distinct id))
as per this expression by default kpi will show the max(Month) number of ids, when user selects three months then that 3months related count of ids it will show.
Requirement:
1. In the KPI,for the max month the count of ids is 1 i.e., 2130 id.
2. When user click on this KPI user need to see this id details in a report.
By default the Table is showing all the ids in the expression showing zeros, but when i have filtered the month getting correct result.as mentioned in the 2nd screens shot.
Please help me how to show the kpi results in report by default.
Thanks in advance.
Have you tried unchecking 'Include Zero Value' on the Data Handling -> Add-On section of your chart? I think that will remove all the extra 0s you are seeing when nothing is selected
Have you tried unchecking 'Include Zero Value' on the Data Handling -> Add-On section of your chart? I think that will remove all the extra 0s you are seeing when nothing is selected