Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Visualization
Created by Guest
Created on Nov 8, 2016
Merged idea
This idea has been merged into another idea. To comment or vote on this idea, please visit SPF-I-235 Line from column values on a categorical axis..

Trend Lines (Line from Column Values) with Categorical X-Axis Merged

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.  

  • Guest
    Reply
    |
    Apr 27, 2017

    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

     

  • Admin
    Niklas Amberntsson
    Reply
    |
    Feb 20, 2017

    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.