Intersection of two line graphs

[Aki]

I would like to add some sort of mark, such as a vertical line or horizontal line, or a Y-axis value display, to the intersection of the circles.

Edited April 25 by Aki

[Boris Nachev]

Hi Aki,

Do you have an example of the .dxp file or a reproducible/example of your dataset? 

Also, could you provide more context on the tools (and versions) you have used ?

Kind Regards,

Boris 

 

[Atheer Al Attar]

Hi Aki, if you have the value of the intersection defined, there are several ways to achieve that:

 

1- Using Lines and Curves Option.

 

2- Creating a Custom Label Column that has Nulls and a value only at the intersection and use that to display label and also to show marker.

[David Katz]

To find the intersection, you likely need to use a data function. Are your lines straight or do you have some formula that describes them? Or you can use raw data. The method should fit the type of data or formulas you have for the lines.

[Aki]

15 hours ago, Boris Nachev said:

Hi Aki,

Do you have an example of the .dxp file or a reproducible/example of your dataset? 

Also, could you provide more context on the tools (and versions) you have used ?

Kind Regards,

Boris 

 

Thank you for your comment.
Since the data cannot be taken outside the company, it cannot be shared, but think of the x-axis as months and years and the y-axis as monetary amounts.
The blue line represents sales and the red line represents costs.
May, cumulative sales: 10,000, total cost: 7,000
June, cumulative sales 11000, total cost 7700
July, cumulative sales: 10,000, total cost: 6,900
.
.
.
It's like.
So, although it looks like a straight line on the graph, it cannot be expressed by an expression like y=ax+b.
I want to get the value of the amount when they intersect and draw a line etc. at that value.

[Aki]

9 hours ago, Atheer Al Attar said:

Hi Aki, if you have the value of the intersection defined, there are several ways to achieve that:

 

1- Using Lines and Curves Option.

 

2- Creating a Custom Label Column that has Nulls and a value only at the intersection and use that to display label and also to show marker.

Thank you for your comment.
I wanted to calculate the value of the intersection point using the spotfire function.
If you cannot calculate it with spotfire, you can calculate it with another software such as Excel, and you can have the calculated value in the input data. However, since the graph is divided by store using a trellis, it is difficult to calculate the values for each store and enter the calculated values for each store. If spotfire could automatically calculate the value at the intersection, I would like to mark it there.

[Aki]

6 hours ago, David Katz said:

To find the intersection, you likely need to use a data function. Are your lines straight or do you have some formula that describes them? Or you can use raw data. The method should fit the type of data or formulas you have for the lines.

Thank you for your comment.
Think of the x-axis as months and years and the y-axis as money.
The blue line represents sales and the red line represents costs.
May, cumulative sales: 10,000, total cost: 7,000
June, cumulative sales 11000, total cost 7700
July, cumulative sales: 10,000, total cost: 6,900
.
.
.
It's like.
So, although it looks like a straight line on the graph, it cannot be expressed by an expression like y=ax+b.
I want to get the value of the amount where they intersect and draw a line etc. at that value.

[Gaia Paolini]

To recap:

1. You have two columns with numeric values.
2. You have a grouping column (store) that you want to trellis by.
3. Your numeric columns look like two lines for each store.
4. You want to calculate the best line that fits each one of your columns, for each store.
5. Then you want the point at which these two fits intersect, for each store.
6. Then you want to show a horizontal line  for each trellis, at the height of the point where the two (fitted) lines intersect.

Is this a correct understanding? 

[Aki]

On 4/26/2024 at 4:48 PM, Gaia Paolini said:

To recap:

1. You have two columns with numeric values.
2. You have a grouping column (store) that you want to trellis by.
3. Your numeric columns look like two lines for each store.
4. You want to calculate the best line that fits each one of your columns, for each store.
5. Then you want the point at which these two fits intersect, for each store.
6. Then you want to show a horizontal line  for each trellis, at the height of the point where the two (fitted) lines intersect.

Is this a correct understanding? 

Thank you for your concern.
This is a sample of the data and an image of the results you want to achieve.

[Gaia Paolini]

Thanks, can you post the data as a text file not an image?