Let's say for customer A
If you want to show 3, use should use Max function
If 1 then min function
I'm having trouble understanding your problem. I've mocked up an example of a count of customers by year using superstore data (Alan Haines was a customer twice in 2016, and three times in 2017 and 2018).
Can you please show me what you are doing to make the customers appear as an asterisk ?
295023.twbx 2.3 MB
sorry, my DB has sensitive data
what is the average age of customers in each year-so as a proxy:
- calc the days between the last day of each year (proxy for Date of Birth) and the last ship date in each year
- then calculate the average for all of those customers for each year/period
- with a bar graph representing each year's average