Aki Posted April 25 Share Posted April 25 (edited) 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 Link to comment Share on other sites More sharing options...
Boris Nachev Posted April 25 Share Posted April 25 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 1 Link to comment Share on other sites More sharing options...
Atheer Al Attar Posted April 25 Share Posted April 25 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. 1 Link to comment Share on other sites More sharing options...
David Katz Posted April 25 Share Posted April 25 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. 1 Link to comment Share on other sites More sharing options...
Aki Posted April 26 Author Share Posted April 26 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. Link to comment Share on other sites More sharing options...
Aki Posted April 26 Author Share Posted April 26 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. Link to comment Share on other sites More sharing options...
Aki Posted April 26 Author Share Posted April 26 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. Link to comment Share on other sites More sharing options...
Gaia Paolini Posted April 26 Share Posted April 26 To recap: You have two columns with numeric values. You have a grouping column (store) that you want to trellis by. Your numeric columns look like two lines for each store. You want to calculate the best line that fits each one of your columns, for each store. Then you want the point at which these two fits intersect, for each store. 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? 1 Link to comment Share on other sites More sharing options...
Aki Posted April 30 Author Share Posted April 30 On 4/26/2024 at 4:48 PM, Gaia Paolini said: To recap: You have two columns with numeric values. You have a grouping column (store) that you want to trellis by. Your numeric columns look like two lines for each store. You want to calculate the best line that fits each one of your columns, for each store. Then you want the point at which these two fits intersect, for each store. 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. Link to comment Share on other sites More sharing options...
Gaia Paolini Posted April 30 Share Posted April 30 Thanks, can you post the data as a text file not an image? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now