topic Re: Text field average in App Development https://community.qlik.com/t5/App-Development/Text-field-average/m-p/120364#M8388 <HTML><HEAD></HEAD><BODY><P>Hi Olivier,&nbsp; your question helped me see how I could improve my question, so I made the change and posted above.&nbsp; I am trying to turn this...</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="padding: 0 5.4pt 0 5.4pt;" width="344"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Transportation Mode</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Identifier</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Day</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Regularity</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">7</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">11</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">22</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">22</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">4</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">9</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">9</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">19</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">21</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">13</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">18</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">20</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">20</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">6</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">8</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">12</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">14</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">15</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">16</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">17</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>into this...</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="padding: 0 5.4pt 0 5.4pt;" width="372"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="140"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Transportation Mode</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="61"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="35"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">AVG</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="140"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="61"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="35"><OL style="list-style-type: decimal;"><LI><SPAN style="color: black;">2.0</SPAN></LI></OL></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="140"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="61"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">4</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="35"><OL style="list-style-type: decimal;"><LI><SPAN style="color: black;">2.3</SPAN></LI></OL></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="140"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="61"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">6</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="35"><OL style="list-style-type: decimal;"><LI><SPAN style="color: black;">2.7</SPAN></LI></OL></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="140"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="61"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">7</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="35"><OL style="list-style-type: decimal;"><LI><SPAN style="color: black;">2.3</SPAN></LI></OL></TD></TR></TBODY></TABLE></BODY></HTML> Sun, 08 Jul 2018 18:30:07 GMT liamlucas 2018-07-08T18:30:07Z Text field average https://community.qlik.com/t5/App-Development/Text-field-average/m-p/120362#M8386 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="padding: 0 5.4pt 0 5.4pt;" width="344"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Transportation Mode</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Identifier</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Day</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Regularity</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">7</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">11</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">22</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">22</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">4</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">9</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">9</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">19</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">21</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">13</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">18</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">20</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">20</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">6</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">8</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">12</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">14</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">15</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">16</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">17</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>In my sheet I have a table with Transportation Mode as the dimension.&nbsp; I want to include a measure that calculates the average number of times each Transportation Mode (Train, Plane, Car, Boat) occurs if each classifier is only counted once.&nbsp; </P><P></P><P>Here is my formula but it is not working, can you assist?</P><P></P><P>Avg(Aggr((Transportation Mode),Distinct[<SPAN style="color: black;">Classifier</SPAN>])</P><P></P><P>This is the result I am trying to get</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="padding: 0 5.4pt 0 5.4pt;" width="372"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="140"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Transportation Mode</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="61"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="35"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">AVG</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="140"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="61"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="35"><OL style="list-style-type: decimal;"><LI><SPAN style="color: black;">2.0</SPAN></LI></OL></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="140"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="61"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">4</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="35"><OL style="list-style-type: decimal;"><LI><SPAN style="color: black;">2.3</SPAN></LI></OL></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="140"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="61"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">6</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="35"><OL style="list-style-type: decimal;"><LI><SPAN style="color: black;">2.7</SPAN></LI></OL></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="140"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="61"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">7</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="35"><OL style="list-style-type: decimal;"><LI><SPAN style="color: black;">2.3</SPAN></LI></OL></TD></TR></TBODY></TABLE></BODY></HTML> Sun, 08 Jul 2018 04:34:48 GMT https://community.qlik.com/t5/App-Development/Text-field-average/m-p/120362#M8386 liamlucas 2018-07-08T04:34:48Z Re: Text field average https://community.qlik.com/t5/App-Development/Text-field-average/m-p/120363#M8387 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>just use this :</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/207282_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>Train : 2,3,7,11,22</P><P>= 45/5 = 9</P><P></P><P>is it what you want ?</P><P></P><P></P><P>regards</P></BODY></HTML> Sun, 08 Jul 2018 06:15:00 GMT https://community.qlik.com/t5/App-Development/Text-field-average/m-p/120363#M8387 ogautier62 2018-07-08T06:15:00Z Re: Text field average https://community.qlik.com/t5/App-Development/Text-field-average/m-p/120364#M8388 <HTML><HEAD></HEAD><BODY><P>Hi Olivier,&nbsp; your question helped me see how I could improve my question, so I made the change and posted above.&nbsp; I am trying to turn this...</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="padding: 0 5.4pt 0 5.4pt;" width="344"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Transportation Mode</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Identifier</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Day</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Regularity</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">7</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">11</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">22</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">22</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">4</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">9</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">9</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">19</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">21</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">13</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">18</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">20</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">20</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">6</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">8</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">12</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">14</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">15</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">16</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="139"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="67"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">17</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>into this...</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="padding: 0 5.4pt 0 5.4pt;" width="372"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="140"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Transportation Mode</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="61"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1/6/2018</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3/17/2018</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="35"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">AVG</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="140"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Train</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="61"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="35"><OL style="list-style-type: decimal;"><LI><SPAN style="color: black;">2.0</SPAN></LI></OL></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="140"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Boat</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="61"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">4</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="35"><OL style="list-style-type: decimal;"><LI><SPAN style="color: black;">2.3</SPAN></LI></OL></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="140"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Car</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="61"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">6</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="35"><OL style="list-style-type: decimal;"><LI><SPAN style="color: black;">2.7</SPAN></LI></OL></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="140"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Plane</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="61"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">7</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="35"><OL style="list-style-type: decimal;"><LI><SPAN style="color: black;">2.3</SPAN></LI></OL></TD></TR></TBODY></TABLE></BODY></HTML> Sun, 08 Jul 2018 18:30:07 GMT https://community.qlik.com/t5/App-Development/Text-field-average/m-p/120364#M8388 liamlucas 2018-07-08T18:30:07Z Re: Text field average https://community.qlik.com/t5/App-Development/Text-field-average/m-p/120365#M8389 <HTML><HEAD></HEAD><BODY><P>So</P><P></P><P>make a pvot table with dimensions Transportation and Day</P><P></P><P>in expression :</P><P>if(SecondaryDimensionality()=1,&nbsp; count( Identifier),sum(aggr(count(Identifier), [Transportation Mode],Day ))/ count(total distinct&nbsp; Day))</P><P></P><P>with subtotal for Day</P><P>secondarydim is used because subtotal is not the same as expression</P><P></P><P>just add regularity too</P><P></P><P>regards</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/207307_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 09 Jul 2018 04:48:05 GMT https://community.qlik.com/t5/App-Development/Text-field-average/m-p/120365#M8389 ogautier62 2018-07-09T04:48:05Z