Trendlines in line charts

Great!
I’ve put it on the Template library for you guys to make use of: <Bar chart with Trendline | Custom charts Library - GitHub>.

Pinging @sm_mk also, since it might be useful for you as well!

Cheers! :beers:

Hi @sm_mk @david-ri @Guido_Stark @hari @DataGeekDude,

We’re currently reviewing our backlog and would greatly appreciate your insights regarding the trendline feature. Could you kindly share your use cases for trendlines with us? Specifically, we would like to know:

  • In which types of charts do you want to create trendlines?
  • Which types of trendlines do you find most important (linear, moving average, exponential, etc.)?
  • What specific use cases or types of analysis do you intend to achieve with trendlines?
  • Are there any styling options you expect to have (dashed lines, labels, tooltips, etc.)?

Any additional information you can provide on this matter would be incredibly valuable.Your inputs will greatly help us better understand your needs and inform our solution design should we support the trendline feature in the future :smiling_face_with_three_hearts:

1 Like

Hi @sm_mk @david-ri @Guido_Stark @hari @DataGeekDude!

We’re thrilled to announce that trend line feature is already in progress and will be released to you soon :rocket:

Here’s a sneak peak of how it will look like :wink:

1 Like

This is awesome news, I appreciate Holistics keeping our requests in the queue. Also really loving canvas as-code so get that into prod asap, saved me sooooo much time!

2 Likes

Fantastic work team - this is very good news!

3 Likes

Any idea on an ETA? Will there be multiple trendline options?

Hi @sm_mk This function is going to be available within this month :blush:

In the meantime, could you kindly clarify what you meant by “multiple trendline options”? We want to ensure we address your needs comprehensively.

Thank you :blush:

Sure, for example if I have a line graph with multiple lines, each representing a different client in the legend, i’d like to see the trend line for each one.

1 Like

Thanks for clarifying @sm_mk :blush:
Yes, you can show the trend lines for each series as follows:

Hi @sm_mk @david-ri @Guido_Stark @hari @DataGeekDude

We have an exciting news for y’all: Trend Lines are now available in Holistics! :rocket:

We’ve made it very simple (yet flexible) to add a trend line in our platform:

More about the feature: Public Docs | Trend Lines

We’d like express our utmost gratitude for your patience and support during the development process of this feature. For any questions or feedback you may have, please don’t hesitate to let us know. Thank you! :smiling_face_with_three_hearts:

1 Like

Hi team,
Great work :fire: will you be adding a moving average at any point in the near future?
That would be super helpful for some of our series.
It would also be very helpful to a slightly extended information in the documentation to show exactly how the behaviour functions with different time periods in play?
Many thanks :slight_smile:

5 Likes

Very nice! Second the call for a moving average trend line, we use that a lot and have to do a bit of a hack to get there. Also, being able to plot an arbitrary line (basically a goal line) would be great too.

4 Likes

Hi @Guido_Stark and @Ian_McLaren

Thank you so much for the suggestions!

Regarding the moving average, we already have an AQL function in place (AQL Moving Average).

Have you played around with it and how did it work out for you?

When you said you wanted to have moving average in the app, were you referring to a point-and-click GUI like that of trend lines?

There’s also this new function to support arbitrary Moving Averages window_avg | Holistics Docs (4.0).

It’s new so we haven’t updated the How-To guide (AQL Moving Average ) to use it yet. But it should be easier to use for that use case than trailing_period which was intended for time-based metrics like Trailing 3 Months Conversion Rate.

Brilliant thank you - that will do what we need it to do functionally.

Having this is a point and click GUI choice as an additional choice of trend line with an input for the period length and type would be a very nice user experience if you decide it’s worth adding in. We would use it a lot across our users rather than needing the super users to build it as a custom measure.

Cheers

1 Like

Yeah, I don’t mind dealing with using Holistics functions, but more thinking for end users who aren’t so inclined, it would be more intuitive to have something they can just add to a graph using the UI. Something like what GSheets has:

2 Likes

Hi @Guido_Stark @Ian_McLaren

I’m excited to share that our team will be supporting a point-and-click GUI for Moving Aggregation (especially Moving Average) in Q3, following the release of Percent of Total. We’ll keep you posted with any sneak peeks! :blush:

In the meantime, we would greatly appreciate it if you could share with us any feedback on our Trend Line feature and the upcoming Reference Line. Your insights are invaluable and help motivate us to continue building a great product. TYSM :heart:

3 Likes

Fantastic thanks team. The reference line will be super useful for us too. We currently hack this via a business calculation and it will be great stop needing to do that.

3 Likes

Hi @Guido_Stark

We’ve just now launched Reference Line! :rocket: It’s also in the form of a point-and-click interface like with Trend Line. Please give it a try and see how it works out for you :slight_smile:

You can learn more about the feature here: Public Docs | Reference Lines

Thanks team - This works well. Very useful!

2 Likes