Skip to Content
0
Sep 13, 2023 at 12:32 AM

Distinct Count in HANA View

127 Views

Hi,

I have the Billing Document in the Projection (in my HANA Calculation View) with following records:

screenshot-2023-09-13-101750.png

How can I create the Distinct Count of Location grouped by Area.

In above example:

1. the Distinct Count of Location for Area A1 is 1.

2. the Distinct Count of Location for Area A2 is 2.

3. the Distinct Count of Location for Area A3 is 1.

In the Aggregation Node, I tried create the Count for this using Column Area and Location but doesn't seem working.

Any suggestion?

Thanks in advance.

Attachments