We have a need to track trends (A percentage) in a P-Chart format with a categorical X-Axis (Fiscal Work Week). There are 4 limit lines (P-Bar, 1-Sigma, 2-Sigma, 3-Sigma) That need to be plotted. In this case the curves are not flat horizontal lines and therefore need to be generated with "Line from Column Values". Unfortunately this can not be done with categorical X-Axis. The only workaround I have found was to plot the limit lines using custom expressions, but this makes the lines look like data which is not aesthetically pleasing and is also confusing to the users. Attached is a DXP to illustrate the issue with 4 different visualizations. From my perspective there are 3 paths to close this gap in Spotfire functionality:
• Allow use of “line from columns” when X-Axis is a categorical variable
• Use a numeric axis to generate plot, but then mask the x-axis labels from the categorical column
• Allow formatting the look of each line on a line plot. If we could hide the markers and change the line style to dashed lines for the P-Bar and Sigma lines then we could create the look and feel that we need
Any of these would solve this specific problem for me, but I think that all 3 options would be useful to have.
Hi Niklas,
Sorry for my delayed response. I think you are correct that what I am looking for [Allow use of “line from columns” when X-Axis is a categorical variable] is basically the same as SPF-I-235. I am OK if we combine these 2 Ideas. This capability would be very beneficial for us at WD.
The other thing I would like to see is more line formatting options on the line plots for individual lines. Not sure if there is a separate idea for that already.
thanks,
Joe
Hi Josef, would you agree this request is the same or at least strongly related to https://ideas.tibco.com/ideas/SPF-I-235 and https://ideas.tibco.com/ideas/SPF-I-314 ?
If so I will go ahead and combine them.