Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to compare shopping habits of two customers. A simple data sample data is laid-out
Month | CustomerId | Product Category | Sub Category | Amount Spend |
Jan | 1 | Entertainment | Music | 50 |
Jan | 1 | Entertainment | Games | 50 |
Jan | 1 | Electronics | Mobile | 500 |
Jan | 1 | Electronics | Home | 200 |
Jan | 1 | Books | Audio | 50 |
Jan | 1 | Entertainment | Music | 20 |
Feb | 2 | Entertainment | Music | 20 |
Jan | 2 | Electronics | Home | 300 |
Jan | 2 | Books | Audio | 50 |
Jan | 2 | Books | Hard Copy | 20 |
Jan | 2 | Entertainment | Music | 20 |
Feb | 2 | Books | Hard Copy | 100 |
Feb | 2 | Entertainment | Games | 100 |
Jan | 3 | Entertainment | Music | 150 |
Feb | 3 | Entertainment | Games | 10 |
And I want to create a view where I can compare two customers (for a period of time). The view would look something like
Thanks
you rock !
Petter,
how do I 'escape' a list of dates i.e.
TxnDate={$(=Concat(DISTINCT TxnDate1,','))}
I tried
TxnDate={$(=Concat(DISTINCT TxnDate1,'","'))}
and
TxnDate={"$(=Concat(DISTINCT TxnDate1,','))"}
but they don't seem to work
found it
for posterity, you use 'Chr' function. I was messing up the braces.
TxnDate={$(=Concat(DISTINCT Chr(39)&TxnDate1&Chr(39),','))}
If you are looking for a free music app that has hundreds of mp3 songs then Sonnerie 2022
Per scaricare le suoneria telefono, rimani qui con noi.