Report Builder: Can I add report element "Submission Date"?

As title, i cannot fine "Submission Date" from Report elements. I would like to add a chart to show how many submissions received in each individual days, or in each individual month.

Hi,\

Unfortunately, this is field is currently not available in the reports fields. We will forward this as a feature request to our developers.

In the meantime, however, you can generate such report in Excel. To do this, please follow the guide below:

• Download your submissions as an Excel file:
• Now, we will have to convert the Submission Date fields (Date+Time) to simply display Date. To do this - we have to select our Submission Date Column -> Right Click -> Format Cells -> Custom, and enter the following : "yyyy-mm-dd hh:mm:ss", this might vary depending on your language settings. In my case it looks like this;
  
• Now we have to refresh all our fields, so that new formatting rules will apply. Instead of doing it one by one, there is a little workaround available: Select the A Column → Go To DATA Tab → Text to Columns Select "Delimited" → Next - Uncheck all delimiters - Next → Finish.
  
  
• Now let us copy all the values to another column, then select this column and Right Click → Format Cells → Number→OK. This will convert our dates to regular numbers, where everything before the decimal separator is a DATE and everything after it is TIME:
  
  
• Now we can use the following formula to extract the date =INT( FIELD ID ), and format cells to display the Date Value (Select column → Right Click → Format Cells → Date)
  
  
• Now we can use that column to generate our report. Add a name to your column in the first row (in my case it's date), and insert a pivot chart. In the PivotTable Fields drag the DATE to VALUES:
  
• And right click on your chart, Change Chart Type and select the preferred chart type (in my case it's PIE).
• Currently, all of your submissions come from a single date, 16.08.2021. The chart will look differently when more dates are added. I have added some dates manually for demonstration.
  
  

We hope this will help you visualize your data. Should you have any more questions, please let us know.

Kind Regards,

Igor,

Sorry for late reply. Thanks very much for the detailed illustrations. It is useful, especially the workaround using text to column to get the cell refreshed. I bump into that issue often!

That's quite a lot of steps. And actually I want to share the report using the JotForm platform, sharing to others with the link. But it's good to have a workaround offline. Hope the development team will have the feature built into report builder soon. Thanks.