Trend Line

  • 27 March 2024
  • 2 replies

Userlevel 3
Badge +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.



Best answer by BrunoRodriguez 30 March 2024, 14:58

View original

2 replies

Userlevel 3
Badge +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:

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

I hope that helped!

Userlevel 3
Badge +8

Thank you Bruno!