Counting Number of records in CDS View (SAP Marketing Cloud)

[cblaickn]

Hello experts,

does someone know how to achieve counting by Ids in SAP Marketing cloud cds views?

I would like to create a measure called "Number of records" that counts the Ids but I do not know how it is possible to achieve that?

Can someone help me here?

BR Christof

[isathore]

Hi Christof,

I rechecked with the expert, and it is indeed, not possible at the moment with custom CDS views.

There was an influence request Improvements to custom CDS (row aggregation & consolidation) for this requirement, but it seems it is not planned as of now.

Best Regards, Isabelle

[KunalBansal]

Hello cblaickn,

As far as my experience, this is not possible to do; maybe the Aggregate option can help here?

I hope this information was helpful in closing this thread.

Thanks and Regards,

Kunal Bansal, SAP CX Architect