Feature Report Layout

251
1
05-26-2023 11:44 AM
bsklaohfl
New Contributor III

Hi! 

I am working on preparing a feature report for a Survey123 Connect form which is functioning. I can see the light at the end of the tunnel and am curious if there is a way to...

1) duplicate headers from tables to preceding pages? I have Repeat Header Rows on Word selected.

and 2) configure the format of stats:"sum,xyz" to display the hundred separators? Right now, stats:sum is summing my total up in the 12345 format instead of 12,345.

I have attached an example of the feature  report. Thanks in advance!

Brooke

0 Kudos
1 Reply
Vinzafy
Occasional Contributor

Hey there!

Unfortunately I'm not sure how to answer your first question, but I do have an answer for your second.

Try adding either the method useGrouping or format in your sum statement.


E.g.,

${Leachate_Report_Final | stats:“sum,Meter_Total” | useGrouping:true}

or

${Leachate_Report_Final | stats:“sum,Meter_Total” | format:"#,##0"}

Note this should group numbers with a grouping size of three which would work for numbers in the ten (12345 --> 12,345) and hundred thousands (123456 --> 123,456), but I don't believe it will for numbers in the thousands (1234 --> 123,4). Try the useGrouping method first and see if it works for you!

 For reference:

Vinzafy_0-1685138103056.png

Note that the reference page custom to your survey can be found on the Survey123 item page for your survey > Data > Report > Manage Templates > Quick Reference

Vinzafy_1-1685138259726.png

Hope that helps!

0 Kudos