exclude Value report in chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have two tables one is Customer and another one is product table,I need to get Active and Inactive Customer Report

The Rules for Active and Inactive are

1.The customer who bought product which is less than a year from the current date is considered to be Active

2. The customer who bought product which is more than a year from the current date is considered to be Inactive

Result Chart:

Total no of Active Customer is 3

Total no of Inactive Customer is 1

Re: exclude Value report in chart

tresB — Mon, 29 Jan 2018 06:16:41 GMT

Try something like:

Active:

=Count( Distinct {<CustomerId={"=Addyears(Max(Date),1)>=Today()"}>} CustomerId)

Inactive:

=Count( Distinct {<CustomerId={"=Addyears(Max(Date),1)<Today()"}>} CustomerId)