# How to set Start/End Date and time and Tag Path of several report component Timeseries charts

**URL:** <https://forum.inductiveautomation.com/t/how-to-set-start-end-date-and-time-and-tag-path-of-several-report-component-timeseries-charts/93732>\
**Category:** Ignition\
**Tags:** perspective, reporting\
**Created:** [July 25, 2024, 8:28am UTC](https://forum.inductiveautomation.com/t/how-to-set-start-end-date-and-time-and-tag-path-of-several-report-component-timeseries-charts/93732 "2024-07-25T08:28:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mushu](https://avatars.discourse-cdn.com/v4/letter/m/b5e925/32.png) [@Mushu](https://forum.inductiveautomation.com/u/Mushu)\
**Post date:** [July 25, 2024, 8:28am UTC](https://forum.inductiveautomation.com/t/how-to-set-start-end-date-and-time-and-tag-path-of-several-report-component-timeseries-charts/93732/1 "2024-07-25T08:28:50Z")

</div>

Hi,  
I am trying to build a report. It has a table with grouping and in the details there is a Timeseries chart.  
The number of charts is variable; it depends on the number of rows of the query result.  
I would like to set the data source tagname, the start and end time of the chart be determined by the data from the row.  
This is how I define the Historian data manually for one chart:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/d/ed70d7cefed818c9fc26f80bc1163bd728433d62.png)

But I don't know how I can set dynamically based on the query result or how to do it for a variable number of charts.

This is a printshot of the report draft:  
I would like to set the Start/End Date and time of the chart with the info retrieved by the report.  
If there are two trolleys, I would like to show two trends with their relevant Start/End Date and time and the trolley temperature in each case.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/9/4935ec2d632956c2808590f538b392a04280adcb.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 25, 2024, 12:15pm UTC](https://forum.inductiveautomation.com/t/how-to-set-start-end-date-and-time-and-tag-path-of-several-report-component-timeseries-charts/93732/2 "2024-07-25T12:15:35Z")

</div>

You need to **nest** your chart query under your primary query. That will make a chart query result for each row of the outer query. Use the column information in the outer query to provide the start/end timestamps for the inner query.

---

<div class="post-metadata">

**Author:** ![Mushu](https://avatars.discourse-cdn.com/v4/letter/m/b5e925/32.png) [@Mushu](https://forum.inductiveautomation.com/u/Mushu)\
**Post date:** [March 6, 2025, 9:52am UTC](https://forum.inductiveautomation.com/t/how-to-set-start-end-date-and-time-and-tag-path-of-several-report-component-timeseries-charts/93732/3 "2025-03-06T09:52:08Z")

</div>

Thank you Phil.  
A Script Data source after the primary query, using the its data to build a TagHistory dataset did the job.  
Apologies for late reply