Creating dashboards from forms
We're wanting to create a form for reporting 'Near Misses' to share with our site managers.
One of the questions on the form would ask what category the near miss would fall into such as 'slips,trips and falls', electrical, housekeeping etc.
Once submitted we would want these to automatically create a dashboard to show trends, such as the percentage of near misses that were slips, trips and falls, or housekeeping etc.
Is this possible and if so, could anybody offer some advice on how to do it please.
Thanks in advance