Skip to main content
Solved

Trend Line

  • March 27, 2024
  • 2 replies
  • 225 views

Forum|alt.badge.img+7

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

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!

2 replies

BrunoRodriguez
Employee
Forum|alt.badge.img+6
  • Employee
  • 25 replies
  • Answer
  • March 30, 2024

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!


Forum|alt.badge.img+7
  • Author
  • Master Author
  • 19 replies
  • April 1, 2024

Thank you Bruno!