Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Take a note of the volume_in and volume_out values and then insert a record in the reports.msr_graphical_data table using the following SQL statement:

E.g.

INSERT INTO reports.msr_graphical_data (period,year,month,from_data,to_data) values (201707,2017,7, 5675.2,5427.3);

** Pay attention to the concatenated year and month values in the SQL statement

*** The from_data field value should be set to the value of volume_in and the to_data field value should be set to the value of volume_out 

Please click the Generate Graph button for the following graphs:

...