Dear All,
I am producing a time series graph report and I have two questions:
1. For the independant data axis, is it possible to display a date in a dd/mm/yyyy format or display the calender day rather than a iterative day? I currently display the interative day number with the month and year shown below.
2. For the dependant data, is it possible to plot a moving average of a set of readings over a time period? For example, I have readings every 15 minutes but I may want to take an average every six hours and plot that.
Thank you in advance
Best regards,
Neill
Hi Neill
1. It is possible, but hard work. You need to write the code in a text entity using repeating text options. You'll also need to use a repeating line entity. An example is in the Datgel Monitoring Tool (trial is here www.datgel.com/TrialSoftware.aspx).
2. I think you'll need to write a gINT Rule (VBA) to populate a 2nd field in the same project table as raw data. Then reference the calculated moving average field in the Dependent 2 graph property.
Cheers
Phil
Phil WadeDatgelBentley Channel Partner and Developer PartnerE: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780
Get the most out of gINT with Datgel Tools.
Thanks for that information Phil.
With regard to point 1, as the month and year labels plot ok, perhaps it would be simpler to just show a tick on the graph to indicate the day intervals. The intention for this report is to show data for a three month period. I can therefore enter the number of days in a 3 month period as the number of divisions on the independant axis. The only problem with this is the number of days varies in a three month period so I would have to change the number used for the divisions - unless I can pass the result of a calculation to the divisions settings. Do you know of any way of doing this?
Cheers,
ch
You'll need a text entity with repeat settings. In the text expression have something like this.
<<DateAdd(d,<<#>>,Start Date,Date Format)>>