I’ve been using the Excel spreadsheets generated under the ‘export’ tab of the dashboard to make graphs of aggregate weekly traffic. On Sunday nights, I invoke the following selection to generate these tables:
Dashboard > Export > single installations (advanced) > Export
On Sunday night, I generated tables for two segments in our community network. When I went to run my scripts, I noticed that the table format had changed.
The column heading previously designated as ‘Date’ was now called ‘DateAndTime_Local_’ and the number of columns was 49 instead of 59. It appears that the ‘10 modes’ columns were absent, and the other column headings were terminated with added underscores that hadn’t been there before.
I noticed the same behaviour on two independent segments that are managed under different accounts, so it seems to be a general change in the behaviour.
Any feedback on what’s going on would be greatly appreciated!
Hi Rick
As you have seen, the actual report that is available via the user’s dashboard has been changed. It now incorporates more detail on the 10 modes that are available (if you have a data subscription or are part of a network).
Some fields did have to be renamed as we are increasing the granularity of the data available (separating the segment data from the instance - or device-related - data, which is important when there are more than 1 device on a segment).
You mention 59 columns but I believe the original report was 29 columns, so let me know if I’m looking at the same report you were using.
We are also upgrading the reporting tools available to network administrators, so we will be sending more news about this to network admins, and also publishing details in our FAQ - which I’ll link here when completed.
Hope this clarifies it? Sorry it happened just as you were preparing your report. Can you see if the latest version (updated today), has all the fields you need?
Ok thanks. Sorry as the 59 column table included some columns added in processing (but the column count was reduced by ten, which suggested a change in the ‘10 modes’ format).
So long as the new format remains stable and available for previous years, it’s all good! I understand that updates are necessary and there is never a perfect time.
I’ll update my code with the new tables and let you know how it works.
1 Like
If you can provide a mapping between old and new column names that would be helpful!