Fiori Elements Chart - Only showing the value of first entity / Not adding up

[former_member602879]

Dear experts,

I'm developing a dashboard for opportunities with fiori elements. I added a new analytics card. On this card I want to show the expected sales volume for the different sales stages.

But only the value of the first enttity is shown. The values are not added up.

As an example, I created two opportunities with the same sales stage (down left corner). You can see the value on the right. As you can see only the value of the first oppy is shown in the bar chart.

You can see my annotations here:

This is from the manifest.json:

"card02": {
"model": "ZCRM_OPPORTUNITY_SRV",
"template": "sap.ovp.cards.charts.analytical",
"settings": {
"title": "{{card03_title}}",
"entitySet": "Opportunities",
"chartAnnotationPath": "com.sap.vocabularies.UI.v1.Chart#SalesStage",
"KPIAnnotationPath": "com.sap.vocabularies.UI.v1.DataPoint#TotalValue"
}
},

In the trace for the service, I can see, that both requested opportunities are part of the payload response.

If I change the sales stage of one oppy (down left corner), both oppies are shown in the chart:

Did I miss something or is this the expected behaviour? For me it would be great, if the chart would show the sums over all oppys..

Best regards,

Matthias

[co_walter_zolkin]

Hi there, do you have a solution yet? got the same problem. no aggregation of values.

[co_walter_zolkin]

Hi there, do you have a solution yet?

[Harshal92]

Hello,
Please add in your CDS view @Aggregation.default: #SUM for the field where you want to aggregate the values.