Solved

Trend Line

Userlevel 3

+8

Hi Pigment Community,

Is there a way to insert a Trend Line on a chart similar to Excel? For instance, here I have a chart, which is trending slightly upward.

icon

Best answer by BrunoRodriguez 30 March 2024, 14:58

Userlevel 3

+5

Hello @Dastan ,

As far as I am aware, there is not an out-of-the-box functionality in Pigment to present a trend. However, you can do the following:

Use the linear regression formula within the FORECAST_LINEAR formula and add the new metric to the table (graph).
Create you own trend formula in another metric in add it into the table (graph)

I hope that helped!

Userlevel 3

+8

Thank you Bruno!

Sign up