topic Re: Counting customers in App Development

Counting customers in LOAD Script

ecabanas — Fri, 04 Oct 2019 18:02:41 GMT

Hi,

I'm loading the full table of sales, but I want to create another one to know the number of customers per month.

Custaccount	created_at	SalesBOid
C000001	1/3/2011	PV00160319
C000002	7/4/2011	PV00160333
C000002	31/5/2011	PV00160368
C000000	31/8/2011	PV00160936
C000002	16/9/2011	PV00161412
C000002	19/9/2011	PV00161447
C000002	20/9/2011	PV00161459

and this table

Month&Year	Number customers
March-11	1
April-11	1
May-11	1
August-11	1
Sept-11	3

Thank's for your help

Re: Counting customers

sunny_talwar — Fri, 04 Oct 2019 11:27:57 GMT

Do you have a MonthYear field screated in the scipt? If you do, then create a straight table like this

Dimension

MonthYear

Expression

Count(DISTINCT Custaccount)

Re: Counting customers

Anil_Babu_Samineni — Fri, 04 Oct 2019 11:28:52 GMT

Perhaps this?

Month(created_at) as Month

And create table with

Dimension : Month

Expression :

Count(TOTAL <Month> Custaccount)

Re: Counting customers

sunny_talwar — Fri, 04 Oct 2019 12:15:36 GMT

@Anil_Babu_Samineni - Why do you need TOTAL <Month> here? I think there is no point of adding TOTAL <Month> when you only have Month as the dimension.

Re: Counting customers

Anil_Babu_Samineni — Fri, 04 Oct 2019 12:26:18 GMT

@sunny_talwar

My intention adding TOTAL qualifier is, if customer added another dimension and they need for month based TOTAL count.

Re: Counting customers

sunny_talwar — Fri, 04 Oct 2019 12:30:51 GMT

Oh, so you are assuming if another dimension is added... but what if they don't want to see the total after adding another dimension... I don't think it is right to assume that when another dimension is added, it should still total by Month. But if that is needed, then you are right.

Re: Counting customers

ecabanas — Fri, 04 Oct 2019 16:38:42 GMT

Hi all

Sorry, maybe I explained bad....I want this new table in load script, to save it in a qvd and use in another app.

Thank's