topic Re: How many customers are repeats within 12 months in App Development

How many customers are repeats within 12 months

PurplePills555 — Sat, 16 Nov 2024 04:09:15 GMT

Hi All,

I have a table of customer IDs and the date at which they visited.

I need a graph on the front end that tells me each month how many repeat customers there have been within 12 months for that particular month.

Any ideas of how I can display this, it's like a rolling month problem.

For instance if I selected April 18 I would want to know how many in the 12 months prior to April 18 as a %.

Or June 19, how many repeats in the 12 months prior to that month.

How would I calculate this rolling problem according to what is selected in the front end or a graph that displays all months.

Re: How many customers are repeats within 12 months

mahaveerbiraj — Mon, 11 Nov 2019 09:02:39 GMT

Hi Purplepills,

I hope below expression helps you ,

Count(DISTINCT {<MonthYear= {'$(=Max(MonthYear))'},[Customer Id]= p({<MonthYear= {">=$(=<Max(MonthYear) -12 ) <= Max(MonthYear)"}>} [Customer Id])>} [Customer Id])

I dint check with syntax please correct the syntax if needed,

I will just explain the logic below what I am trying above

i m checking current month customer are exist or not in last 12 moths using E() function

Please feel free to reply if you have any doubt

Thanks & Regards

Mahaveer

Re: How many customers are repeats within 12 months

PurplePills555 — Thu, 14 Nov 2019 16:33:44 GMT

Hi,

Sadly I couldn't get this to work. I just get 0. Not sure why!?

Re: How many customers are repeats within 12 months

mahaveerbiraj — Thu, 14 Nov 2019 17:39:10 GMT

Could you please attach QVF , so that I can check