Count non-distinct values in calculation view

[Former Member]

In calculation view, the counter function will provide the distinct count.

Is there a way to get the non distinct count in graphical calculation view?

Regards,

Sneha Bajaj

[sreelatha_reddy2]

If you want to do it by SQL, below is the sample query.

2.

If you want to go by a simple way , you can drag and drop the Attribute in Value axis as I shown in the earlier reply.

3. If you want to go with the aggregated column , Below is the code.

Create a calculated measure and keep the default value 1. Make the column as aggregated column in the aggregation layer below the   semantics node.

[Former Member]

Hi Sneha,

There are 2 ways through which we could populate the count:

1) Count (obvious )

2) Create a calculated measure, hard code a value of 1. Add this column as aggregated column.

[lucas_oliveira]

Hi Sneha,

Well you won't use Data Preview as your front-end so you can definitely go with the good old select col, count(*) ...

However, take care with count(*) expression especially when using calculation views on top of analytic views specially. Further info in SAP Note 1791464 - Select count(*) on graphical Calculation Views.

BRs,

Lucas de Oliveira

[sreelatha_reddy2]

Hi Sneha,

If you want non-distinct counter values , you can drag and drop the Attribute in Value axis. PFB my example.