topic Make Count of Dimensions as a new Dimension in App Development

Make Count of Dimensions as a new Dimension

calvintang — Tue, 28 Dec 2021 06:43:51 GMT

Data frame:

Date | Customer ID | Item Code

12/12/2021 | 12 | 74

12/12/2021 | 12 | 90

13/12/2021 | 1 | 89

13/12/2021 | 90 | 92

On the 12th, it should have a Count(Distinct [Item Code])) of 2, where there will be a count of 1 customer.

On the 13th, it should have a Count(Distinct [Item Code])) of 1, where there will be a count of 2 customers.

I am not sure of the syntax on Data Load Editor to achieve this.

Thanks!

Re: Make Count of Dimensions as a new Dimension

MarcoWedel — Tue, 28 Dec 2021 18:15:00 GMT

You expect Count(Distinct [Item Code])) to deliver only one distinct Item Code in this case?

Re: Make Count of Dimensions as a new Dimension

calvintang — Wed, 29 Dec 2021 00:36:07 GMT

I wish to have a measure as a dimension, then from that dimension, I will pair it with a measure in a bar chart to show the number of customers grouped by the number of distinct purchases made in that particular date.

Is this clearer?

Re: Make Count of Dimensions as a new Dimension

calvintang — Wed, 29 Dec 2021 06:56:12 GMT

Hi Marco,

I see your point now. What I meant was:

On the 13th, I know that there were 2 different products sold, but from a customer viewpoint, they bought only 1 item.

For both customers, they are grouped under those who purchased only 1 item.

The formula used in the example above should be ignored. I hope this is clearer.