Creating Trendline from Imported CSV Data

[arief]

Hi,

 

I would like to seek your advice on how to create a trendline from an imported CSV datasets against date. In the following snapshot (Figure 1), I have imported data of a gas composition on weekly basis to seeq. The raw data is depicted in Figure 2. My intention is creating a trendline (similar with excel can do) which show pattern of evolution of composition along the time, as shown in the Figure 3 in seeq.

Could you please give advice how to create that trendline?

 

Regards,

 

Figure 1. 

 

Figure 2.

 

Figure 3.

 

[John Cox]

Hello, 

I would recommend using the timeSince() function in Seeq Formula, to create an Accumulated Time signal which you can then use in the Prediction tool to create a trendline for your CSV imported "N2" signal:

 

The Prediction tool is set up very simply with the Accumulated Time signal as the input signal (see screenshot below). You can put the Trendline signal and your CSV imported "N2" signal on the same lane and axis to get the final result.