Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Perhaps this?
Month(created_at) as Month
And create table with
Dimension : Month
Expression :
Count(TOTAL <Month> Custaccount)
@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.
My intention adding TOTAL qualifier is, if customer added another dimension and they need for month based TOTAL count.
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.
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