Trendlines in line charts

Feature Suggestions
20

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
21

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
22

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!

3 Likes
23

Fantastic work team - this is very good news!

4 Likes
24

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

25

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:

26

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
27

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

Screenshot 2024-04-17 at 09.37.08
Screenshot 2024-04-17 at 09.37.081314×820 77.6 KB

28

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
29

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:

6 Likes
30

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
31

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?

32

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.

33

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
34

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:

image
image1014×625 37.3 KB

2 Likes
35

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
36

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.

4 Likes
37

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

38

Thanks team - This works well. Very useful!

3 Likes
39

Hi @Ian_McLaren and @Guido_Stark

You now can create a moving average trend line with our Moving Calculations! :partying_face: This feature is very versatile and can help you with many different use cases.

For more details, please check out our doc here: Moving Calculations | Holistics Docs 4.0