How can we create dynamic KPI boxes that can cater to both of the following requests:
1. When report is opened, default view of numbers for YTD performance
2. When a fiscal year/ year month/ quarter filter is applied, specific numbers to the selected period to show up
Currently, we are able to configure only one of this conditions at a time i.e. if we restrict data for YTD in the default view, some filters applied for period apart from the YTD scope do not show correct numbers or when we keep unrestricted KPI boxes, filters work correctly but the default YTD view is not possible.
How can we code both these requirements in a single metric?
