8

Trend lines - Take away the math function and build input it with click

I would like to see trendlines become easier. I am surprised that trendlines for Klipfolio are not as easy as excel. I believe it should be as easy as a button click to pull information from an excel data source and drop in a trendline into your Klip, just like excel would do it.

The math function is not a very good option.

Also with this, I would like to see it act like Excel where it ignores cells that have #N/A in them.

12 comments

  • 2
    Avatar
    Donny Stiefel

    Arshad,

    I tried the formula on the page you linked and my trendline ended up going just the opposite direction of the actual data. I understood how to get &series but I got confused with the "x" as a string and x as a variable part. What exactly is "x" supposed to be? Your post says it should be a string but what string would it refer to?  And what about the x variable? Apologies for seeming a bit ignorant but the reporting software we used in the past made adding trend lines very simple without the need for formulas.

  • 1
    Avatar
    Steve Baumgartner

    Agreed Joe. Klipfolio is a wonderful application for visualizations, but for most businesses trends are important to keep our minds on, without them our numbers are static and don't mean much. Right now it is hard to trust the trendlines on my visualizations because they have to be manually manipulated and if they are off from what people are used to looking at, they stop trusting them.

  • 0
    Avatar
    Joe Schnerr

    Yes please!  This really is vital to our business...as we use Klipfolio to monitor (among many other things) the depletion of our product we would LOVE to be able to insert trendlines for estimating how long our supplies will last over a range of many different product types.  Thank you!

  • 0
    Avatar
    Jason Tran

    +1 I agree.

    The addition of a confidence interval to the forecast/trend line would be great

  • 0
    Avatar
    Scott Lawrence

    Hi Jason,

    Thank you for adding your voice and the additional use case wrt forecasting.

    I've added your name and use case to the feature request to discuss with the product team.

    Cheers,

    Scott.

  • 0
    Avatar
    Lenore Kennedy

    Hi Scott,

    Just wondering if you were any further forward on the Trend Line - as we would also like it added as a function.

     

    Many thanks

    Lenore

  • 0
    Avatar
    Scott Lawrence

    Hi Lenore,

    Thank you for raising your voice in the community and adding your support for this feature request.  It is still on our backlog, however has not yet been scheduled.

    Can you share more about what you are trying to do?

    In the meantime, I have added your name and support to the feature request.

    Cheers,

    Scott.

  • 0
    Avatar
    Arshad Hayat

    Hi Lenore,

    Have you tried this post to add a trendline. There are updated formulas which refer just the Series result and would work even with date values on X-Axis.

    -Arshad

  • 0
    Avatar
    Kenny Hughes

    Trend lines would be great for us to see our event attendance over time and estimate when we would reach capacity in an event space.

    It would be even cooler if we could have different types of trend lines (regression, moving averages, etc.)

  • 0
    Avatar
    Angelica Velasco

    Hello, I'd like to follow up with this thread. Has there been any update to this feature? My team and I are trying to add trendlines to our klips as well.

  • 0
    Avatar
    Ali Pourshahid

    Angelica, 

    Have you tried our new Metrics capabilities? You can easily enable a Trend line by simply choosing a drop-down menu. 

    Check out this video:

    https://www.youtube.com/watch?v=nG-KXobF9l8

    Ali

  • 0
    Avatar
    Annemieke Mol

    I would love to see this as well, also within the multimetric possibility. 

Please sign in to leave a comment.