I use TapForms to track houses we build. One record per house. I have a field “Year” which records which year each house was completed (2021, 2022, etc.). I would like to create a view which is a Bar Chart, with a single bar for each year, showing total houses built. Is there a way to do this?
Hi Andrew,
Yes you can do this.
What you want to do is set the Calculation Summary to Count on your Year field.
Set the Series Fields option on your chart to your Year field.
Then enable the “Show group summaries” option and you should see the Barnhart show the year at the bottom and the count of the number of homes for each of those years.
The attached screenshot shows an example. Except in this case it’s the number of movies released in specific years. Just my test data for this example.
Thanks,
Brendan
Attachments:
You must be
logged in to view attached files.
Oh, you’ll also want to set the Group Records By option on your form to your Year field.
Hi Brendan,
I can’t seem to get anything to display with these settings:
Sort & Group Settings > Group records By: Year Reported
Calculation > Field: Year Reported
Calculation > Type: Count
X Axis Field: Year Reported (tried a few other options here as well, no difference)
Series Fields: Year Reported
Show Values: checked
Show Group Summaries: checked
Note – Year Reported is a number field.
Any suggestions?
Can you please email me your form template? Send it to support@tapforms.com
Thanks,
Brendan
Ok, the issue is that you didn’t have the Field’s Calculation Summary set to Count. Once I set that in your form, the bars showed up.
The Calculation > Field: Year Reported isn’t quite what you need. That’s set on the Form, but you want it to be set on the Field itself.
Give that a try and see if it works for you.
.
