Hi - I am trying to develop a an indicator card that displays a software compliance rate (%) from samp_product_result table having a formula as (Total no of products - No of non-complaint products) / Total number of products * 100. I wanted this value to be filtered based on 2 filters - 1. software publisher from samp_sw_publisher and 2. software product from samp_sw_product. These are indicator breakdowns which are also added to a formula indicator (having the above formula) and the contributing indicators (total no of products and no of non-complaint products). The formula indicator is enabled with "Allow aggregation of multiple breakdown element scores' option to aggregate the scores at the primary breakdown (which is publisher) level. The contributing indicators are all having COUNT as the aggregate.
The issue:
When I filter the publisher alone, the compliance rate is displayed correctly - both single publisher and multiple publisher and works the same for product as well. But when I have a combination filter between publisher and product, the compliance rate is displayed at the publisher level.
Is there a better solution for this issue, please?
E.g., scenario below,
1. Filter publisher alone to Microsoft, the rate is displayed correctly as 56.72%
2. Filter publisher alone to both Microsoft and Adobe, the rate is displayed correctly 76.25%.
3. Clear the Publisher filter
4. Filter the product alone to Power Apps, the rate is displayed correctly as 100%
5. Filter the product alone to Power Automate, the rate is displayed as 50%
6. Filter the publisher to Microsoft and product as Power Apps, the is displayed as of 56.72% instead of 100%.
Total number of products indicator:
No of non-complaint products uses the same source and breakdown but has status is non-complaint condition additional.
Breakdowns:
Publisher Breakdown source:
Product Breakdown source:
Both the breakdowns have mapping to samp_product_results table connected through product.publisher field for Publisher breakdown and product field for product breakdown.
Breakdown relation:
Product breakdown filter is following the publisher breakdown filter in the filter configuration within the platform analytics dashboard.
Thanbs
Fareeth
