Chart - line cut

[#1]

Hey Guys,

i have a problem with a specific chart.

I want to compare the development of the customer and the revenue created by them within 10 days. (Revenue divided by Amount of Clients, e.g. 100.000 Dollar / 10.000 Clients = 10 Dollar per client)

"Within 10 days" means that the client has 10 days time to generate revenue / buy the product after he has become a customer of my company.

I've created the following chart:

The picture above shows a decreasing line of the "Revenue per Customer". The reason is simple.. the new clients, which became a customer of my firm had e.g. only 2, 3 , 4 days time to bought the product, because they were only 2, 3, 4 days client of my company.

Is there a possibility to cut the line? So that the line will end ten days ago, like the following picture:

(pictures created with paint)

Anyone who has an idea?

Many thanks in advance!

[matt_crowther · Accepted solution]

Not 100% this is the solution as you sound to have a fairly one off requirement.

I'd look to use an if() statement to control your line expression eg:

=if(Sale_Date<(today(1)-10),Sum(Sales),null())

Hope that solves it.

All the best,

Matt - Visual Analytics Ltd

[#3]

Thank you very much! It works 🙂