Hi all!
How are you doing?!
I have a cloud that presents the following dates:
Customer ID
Inclusion Dates
Exclusion Dates
Type (Client classification) (gold / bronze)
I need to count these customers in an evolution of time, to make a line graphs that shows the evolution, along the years, in two lines: the line of the amount of gold customers and the line of the amount of bronze customers.
To construct the graph, i have as dimension the years (where the amounts of customers will be contained) and as expression will be two: amount of gold customers / amount of bronze customers .
For the customer to belong in one year in subject, he needs to have date of smaller inclusion or same to the last day of this year
and to have the date of exclusion empty or larger than the last day of this year.
My problem is:
A customer that entered in 01.01.1999 and it stays active until today , the client needs to count in every year.
Regards
Minzinfi