How to dynamically change the x axis in a line chart based on min and max values based on another table.

Okay, we have two different tables that reflect well completion data broken down by stage. Both of these data tables are per second recordings of what is occurring during each stage of the completion but the duration of each stage is not perfectly synced. What we would like to do is set up two charts one above the other such that when we select the stage of interest (entered by the user through a property control) that the axis of the the bottom chart matches the date time range of the upper chart. The goal is to be able to visualize the data on a time equivelant basis without having to manually adjust the scale to the lower chart each time a new stage is selected.

For example the date time fields reflect per second data in both tables. table one may begin stage 1 at 1/1/2017 5:00:35 pm and end at 1/1/2017 7:35:30 pm. Where as table 2 May begin stage one at 1/1/2017 5:30:00 pm and end at 1/1/2017 7:30:42. The goal is to dynamically adjust the scale of the x axis of the line chart depicting the table 2 data to match the range of the data in table 1.

 

Is this possible....

any help would be greatly appreciated.

 

Login