Secondary Indicator Widget
Good morning - I would like to create a 'simple' numerical indicator widget with a sales value as the primary metric and the target sales value as the secondary metric. The target sales value is stored in an excel sheet with a structure like this:
I would like to show the latest sales and target values in the primary and secondary metric of the indicator widget respectively. I am able to show the latest sales value in the primary metric using a value filter, but the widget aggregates the secondary value automatically for me. Is there any way I can just show the latest target value in the secondary metric without any aggregation?
It should be 84 and 100, but the value is summing up
Hi amelia
To resolve this you'd have to add a custom field into both tables on your data model. The custom field should use a RANK (decending) function based on the date field. This way, the latest value will always be the one with the '1' value
Use the '1' as a formula filter in both fields:
(SUM(Price),RANK=1)
