I've been looking for similar issue, but i'm getting confused with the keyword
so, I have this table
I want to sum the quantity based on time and ignore the type. (I'm using type there so if i use "type" as filter, the quantity will be changed).
my issues are if I load the table like that, the sum result is not correct. But if I didn't load the "type" column, the quantity (in KPI) won't change based on the filter which is "type" but the sum results is correct.
the result that i want is a table like this:
I want to use the new table to display the time with highest quantity (as a KPI chart) and add comment with the quantity
the current expression I'm using is: FirstSortedValue(distinct time, aggr(sum(quantity),time))
MAX(aggr(sum(quantity),time,type)) won't work because you want to aggregate your data towards a time and not the type, right ? Othterwise you also won't get 12 for the first output.
As you can see a KPI Window cannot express more than one output. So you got the wanted output after you add a Max() function, because it rightly tells you only to display the MAX VALUE which is unique.