Dashboard chart for daily submissions (via form) over time
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.
Answers
-
The easiest thing to do may be to actually create a Report from this sheet instead of formulas. Then you can Group by the Date column and use the Summary to Count so you can see how many submissions came in each day. Here's a webinar that goes through how to use Grouping and Summary in a Report.
Once you have a Report set up with Grouping and Summary, you can use this as a source for a Chart Widget. Would that work for you?
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hi @Genevieve P. This is helpful but I'm using the created column and as it has a time as well as a date its counting each one individually. What's the solution here. I've heard of a helper column that is maybe the answer. If so how would it use it and is there a formula to turn the created date and time into just a date?
Thanks
-
Yes, a helper column would be a great solution! Add a new Date Column to your sheet, then use the following formula as a Column Formula:
=DATEONLY([Created Date]@row)
See: DATEONLY Function. Replace [Created Date] with your created system column name.
Let me know if that helps!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks for the advise. I am using the formula =DATEONLY([Date created]@row) and I just get #INVALID?
What am I missing?
Phil
-
Are you entering the formula into a Date type of column?
I suppose you could enter it into a Text/Number column, but you'll need to add +"" to the end of your formula to turn the date into text.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives