The history component makes it possible to plot a value in a chart that changes in real time, while conserving its historical data. Okay, that may be a bit of a cryptic description of what this component does, but you should think about those stock charts that track the fluctuation of a stock price. At the start of the day, the line in such a chart is short, while at the end of the day the complete trend of the stock prize for that day is shown. This recipe will show you how to set up this kind of functionality in your dashboard.
Drag a line chart component, a history component, and a horizontal slider component into the canvas.
Select the horizontal slider component and bind the Data field to spreadsheet cell B1.
Now select the history component and bind its Data field also to spreadsheet cell B1.
Bind the Data Destination field to the spreadsheet range B3 to J3.
Go to the line chart component. Bind...