Good afternoon!
I have a set of filters - Year, Quarter, Month, Week.
And also the measure is a fact on the scales. This indicator cannot be summed up because the balance for yesterday + the balance for today <> the balance for today.
I have data for the end of months for closed quarters, Mondays for an open quarter, days for an open week.
What I want to see:
balance for the 1st quarter of 22 years = balance for March 22,
balance for the year (if open, then for the last loaded date),
if closed, then for the last day of the year,
balance for the open quarter = balance for the last loaded Monday.
I read articles about semi-additive indicators, met the FirstSortedValue function.
Tried something similar:
FirstSortedValue({$<[METRIC_TYPE] = {'NUMBER OF ACCOUNTS'}>} Aggr(Amount({$<[METRIC_TYPE] = {'NUMBER OF ACCOUNTS'}>} INDICATOR), PERIOD), -PERIOD);
FirstSortedValue({$<[METRIC_TYPE] = {'NUMBER OF EVENTS'}>} Aggr(Sum({$<[METRIC_TYPE] = {'NUMBER OF EVENTS'}>} METRIC), PERIOD), -PERIOD)
A dash is placed in the visual representation of the measure when