05-24-2021 07:35 AM
Well, the original discussion was about using the Citadel DB (meaning the DSC module) and I'm not sure what tools exist there, but here's the basic idea.
Let's say these are the X and Y values of your data:
1,101
2,102
3,103
4,104
5,105
8,108
9,109
10,110
You would use whatever logic is relevant to remove the gap and remap the X values to their new positions, so that you don't have the gaps.
For example (X, Y, original X):
1,101,1
2,102,2
3,103,3
4,104,4
5,105,5
6,108,8
7,109,9
8,110,10
You would then use the XY values in the graph and the original X values to build the scale.
05-25-2021 02:36 AM - edited 05-25-2021 02:37 AM
I took it as far as I could.
This seems to work. Its not clear how I got the property nodes that define x scale minimum, maximum and interval to address the second x-axis which is timestamp scale. Maybe because the dates are "Plot 0" (named 'Date Dummy' here) and that is the plot that the property nodes address by default. Code attached.
The next step would to make the gridlines fit up better to the data. The dates I chose by default look good, but there is some offset in the grids for the bottom and top axes depending on the chosen dates. That will need some cleaning up.