%>6.6m in hourly data

  • Last Post 30 January 2018
Graham Rock posted this 29 January 2018

In daily reports is there any way to get data for %>6.6m as well as the total flow? If not, is there any other way to get this data?

Paul Watkins posted this 30 January 2018

Hi Graham,

Not currently no but it'd certainly be a useful addition. I'll look into it.

In the daily reports Standard Tab the data is available to make this kind of report in Excel currently if you're familiar with the functions. Appreciate it adds time to producing the data but it'd give you what you need.

Add a column and title Hour, add the function Hour(<column for Time Period Ending>) which will assign the 15 minute value to an hour. Then in the middle add a couple more columns, in one you can SUM the values of 661-1160 and 1160+ columns which will give you the HGV mix, and just SUM all four columns for Total flow. Then put that all into a pivot chart with Report Date as a Row, Hour as Column and SumHGV/SumTotal in the Values areas.

I quickly made a mock up of the report which I can share if you get in touch with us at: PerformanceAnalysisUnit@highwaysengland.co.uk