I have a problem regarding the creation of cards.
In a CDS View I have three columns: "ObjectsCurrentMonth", "ObjectsLastMonth", "ObjectsOlder". These columns contain a 1 if the Object was created in the relevant period. So e.g. if an object would have been created today, there would be a 1 in the column "ObjectsCurrentMonth" and the other two Columns would have a 0 as a value.
I use the @Aggregation.default: #SUM annotation to sum up the Objects created in the different periods. I used the added values in a KPI Tile "Comparison Tile Multiple measures" to show the different time periods.
I tried to achieve the same with cards, using the KPI header as well as a list card. But in the list card my values were not sumed up. And in the KPI header I can only show one sumed up value. Since I can only set one value to "dataPointAnnotationPath". I already tried setting a qualifier.
Does anybody know a way to achieve this?
Thanks in advance,