4 Replies Latest reply on Jun 9, 2018 7:29 AM by Chris McClellan

# How to show difference between two points on a line chart?

I want to show difference between two points on line chart on the line connecting two points. It should look somewhat like the below image

Can anyone help me out here ASAP?

Message was edited by: shristy sundaram

• ###### 1. Re: How to show difference between two points on a line chart?

More information on the measure is required - is it simply sum([Measure]) or a running total ?

Creating a calculation that references the prior value ie LOOKUP(sum([Measure]), -1) would be part of your solution but a preview of your data would be great.

Can you upload some dummy data so we can show you exactly how to solve this ?

• ###### 2. Re: How to show difference between two points on a line chart?

Thank you Chris!

I am Attaching sample data where the total is plotted against months. I want to display the difference between two consecutive months on the line joining them.

data:

• ###### 3. Re: How to show difference between two points on a line chart?

Hi Shristy,

You want to see difference like This

Or

Like This?

OR

Thanks

Deepak

If it Helps, Pl mark it Helpful and CORRECT to Close Thread

• ###### 4. Re: How to show difference between two points on a line chart?

Here's how to do the running sum:

and just a normal sum(rides)