Dashboard chart for daily submissions (via form) over time

Phil Wightman
Phil Wightman ✭✭✭✭✭✭

I have a seven week event.

I have a form set up for submissions about the event.

How do I set up the metric sheet and which formulas to count submissions each day/ week to appear on the chart to show on the dashboard.