Thank you. Changing the local profile for the report got it to work.
For anyone who might be interested I changed the time filter in the report profile settings. You can change the “Auto-Wrap” option. I changed it to “Aligned days”, this cuts out the half days at the beginning and end of the survey, save that to a file. modify the custom report and set it to use the new profile that was just saved.
Now whenever that report is used, the new local profile is used and it works nicely. Such a small thing that I missed.
Thanks for you help.
Thanks for the quick reply
The look of the report isn’t important as it is used as a means to get information into a database. I’m a code monkey so function comes before appearance.
Below is the output in Metro Count of the custom report I’ve been working on. It shows the tags I’ve used and their results. Most of the them (near the beginning) are speed statistics and class bins, which work nicely. The last few (51 – 60) are my attempts to get ADT, AWDT, and AAWET (virtual days, week days and weekends). It seems that because the survey started on a Tuesday and ended on a Wednesday I can’t get ADT or AWDT from the tags in the report or even the values for virtual days Tuesday and Wednesday (V1and V2), which I thought I could use to calculate ADT myself.
7 PR_START.TT = 14:21 Tuesday, 16 December 2014
8 PR_END.TT = 18:50 Wednesday, 7 January 2015
9 DA_DIR.TT = East (bound)
10 FA_nCLSBIN.TT.1 = 108549
11 FA_pCLSBIN.TT.1 = 91.3
12 FA_nCLSBIN.TT.2 = 3025
13 FA_pCLSBIN.TT.2 = 2.5
14 FA_nCLSBIN.TT.3 = 6113
15 FA_pCLSBIN.TT.3 = 5.1
16 FA_nCLSBIN.TT.4 = 451
17 FA_pCLSBIN.TT.4 = 0.4
18 FA_nCLSBIN.TT.5 = 145
19 FA_pCLSBIN.TT.5 = 0.1
20 FA_nCLSBIN.TT.6 = 287
21 FA_pCLSBIN.TT.6 = 0.2
22 FA_nCLSBIN.TT.7 = 136
23 FA_pCLSBIN.TT.7 = 0.1
24 FA_nCLSBIN.TT.8 = 16
25 FA_pCLSBIN.TT.8 = 0.0
26 FA_nCLSBIN.TT.9 = 94
27 FA_pCLSBIN.TT.9 = 0.1
28 FA_nCLSBIN.TT.10 = 20
29 FA_pCLSBIN.TT.10 = 0.0
30 FA_nCLSBIN.TT.11 = 0
31 FA_pCLSBIN.TT.11 = 0.0
32 FA_nCLSBIN.TT.12 = 0
33 FA_pCLSBIN.TT.12 = 0.0
34 FA_nTOT.TT = 118836
35 FA_nLIMIT0.AX = 60
36 FA_nLIMIT0.TT = 117654
37 FA_vMEANEX.TT = 76.3
38 FA_vMAX.TT = 158.5
39 FA_vMIN.TT = 19.0
40 FA_vMEAN.TT = 76.0
41 FA_vPP.TT = 81.4
42 FA_vPP.AX = 85
43 FA_vPP2.TT = 85.3
44 FA_vPP2.AX = 95
45 FA_vMEAN.TT = 76.0
46 FA_vPACE.TT = 65.9
47 FA_vPACE.AX = 20
48 FA_nPACE.TT = 109202
49 FA_VARIANCE.TT = 37.9
50 FA_STDEV.TT = 6.2
51 FA_nTOT.V0 = 5581
52 FA_nTOT.V1 = ##Days?##
53 FA_nTOT.V2 = ##Days?##
54 FA_nTOT.V3 = 4553
55 FA_nTOT.V4 = 5681
56 FA_nTOT.V5 = 4938
57 FA_nTOT.V6 = 4390
58 FA_nTOT.WD = ##Days?##
59 FA_nTOT.VD = ##Days?##
60 FA_nTOT.VE = 4664
If I could get all of that in one report (don’t need 51 – 57) that would give us exactly what we need.
P.S. I think the custom reports and list are a great idea and have found them very useful so far.
