Solved
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 stor...
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)
