Excel Reports: Replicate a number field, that is not a table field, in an Excel Reports
One of our customers created a workload form that tracked the year of entry as a numeric field, e.g. 2012, 2011 etc. They also had a table in the event form that tracked exercise workload during the session. When each entry was exported to the Excel Reports, the year of entry (e.g. 2012) only appeared with the data in the first row of data for that event. When they tried to produce a pivot table using 2012 as a filter, only the first row's data was pulled into the pivot table. You can now set up a numeric field to replicate in the athlete history and Excel Reports when there is a Table in the Event Form.
Does one of your numeric fields need to replicate in an Excel Pivot Table? To set up a numeric field so that it is replicated in the Excel Reports see the steps below.
For any numeric field in the Builder you can set it to "Repeat Field in Excel" =Yes
The "Repeat field in excel reports" only appears when there is a Table in the Event Form
When there is no Table in the Event Form, the" Repeat Field in excel report" button will NOT appear
When the Button is enabled for the fields that you require Save the Event Form
The Event Form being entered on the system with 4 rows entered in the Table.
On the application in the athlete history, the example here shows the number field (Year number example) has repeat and filled down to all of the rows. Another number was added to this form that was set not to repeat. This highlights the difference between the fields
When you create an Excel Report, the data that is set to Repeat, will appear in all of the Rows in the Excel Output
When the different number formats are used in Pivot Tables, you can see that for the repeated field all of the table records appear. For the non repeated, only 2 table records appear.
Now when the year is used as a reference in a pivot table, all of the rows for the record will be pulled through
You need to think very carefully about where you implement this "Repeat Field"
If you set a number field to repeat (in the Athlete History or Excel reports) and you are doing a sum with those numbers in a pivot or even in the athlete history, then the "sum" will sum all of the repeated fields. The image here shows the year being set to sum in the athlete history. This is just an example to highlight how the repeated fields are summed and how they affect system calculations.
0 Comments
Add your comment