Tables: Option in Reports is Showing as Other Entries

Hi Team,

Hope you're well!

I can't for the life of me work out why on the table it shows 12 entries in 'other': https://www.jotform.com/tables/250574432290353/250701978674063

We've selected a date range that should only have four entries, but it seems that entries are showing that are outside of the date range in the second chart on this report. Would appreciate if you could let us know if this is a bug or user error!

Thanks

Nick

Hi Nick,

Thanks for reaching out to Jotform Support. I'm an AI assistant here to assist you.

Regarding your issue with the table showing 12 entries in 'other' despite selecting a date range that should only show four entries, this is likely related to how filters are applied in Jotform Tables and Reports.

Here’s how filtering works in Jotform Tables and Visual Reports:

• When filtering by submission date, you need to use the Filter button next to the search bar and select the date range under the All Time dropdown, then apply the filter.
• For other date fields (custom date fields), you must use Advanced Filters to set conditions like greater than or equal to the start date and less than or equal to the end date, then apply the filter.
• In Visual Reports, filters may behave differently, and sometimes charts may include entries outside the selected date range if the filter is not correctly applied to the specific data field used in the chart.

It is possible that the second chart on your report is not fully respecting the date range filter or is using a different date field than the one you filtered by. This can cause entries outside the selected date range to appear.

To resolve this, please check the following:

• Ensure the date filter is applied correctly on the exact date field that the chart uses.
• Verify that the filter is applied and saved properly in the report settings.
• Try refreshing the report after applying the filter to see if the chart updates accordingly.

If after these checks the issue persists, it may be a limitation or issue with how the report handles filters on charts, but most often it is due to filter configuration or the date field used.

Give it a try and let us know how it goes.

Think it still persists :)

Hi Nick,

It seems the issue still persists. Let me help you with that:

You can create a new tab in your Jotform Tables and filter data to view specific details separately. Here’s how to create a new tab:

1. Click on New Tab at the top of your Jotform Submissions Table next to your tabs.
2. Select Table in the menu that opens and click Next.
3. Select Connect to form and click Next again.
4. Select the same form and click Next.
5. Check the box next to Select All at the top of the page and click the Create button.

This will create a new tab in your Tables where you can apply filters.

To filter data in Jotform Tables:

1. Click on the Filter button next to the search bar.
2. Click on All Submissions in the menu that opens.
3. Select the desired filter such as date range or other criteria.
4. Click Apply Filter.

For more detailed guidance, you can check our How to Filter Entries in Jotform Tables guide.

Give it a try and let us know how it goes.

We won't be creating a new tab.

Is help coming on this?

Hi tigermartialarts,

Thanks for reaching out to us for help. Let me take a look at this for you. To do that, we’ll need your permission to access your account. Don’t worry, you can turn it off again once we’re done. Let me show you how to do it:

1. In the top-right corner of your Workspace page, click on your Avatar/Profile Image icon.

2. Then, in the Dropdown menu that opens, click on Settings.

3. Next, in the panel on the left, click on the Security tab.

4. If you haven’t opened your Security page in a while, it’ll ask you to verify. To do that, click on Send Verification Code.

5. Then, enter the Verification Code you receive in your email.

6. Finally, at the bottom of the page, toggle on Jotform Support Access.

After we hear back from you, we’ll have a better idea of what’s going on and how to help.

Thanks Lorenz, enabled :)

Hi Nick,

I note that there are 12 entries is showing when you're filtering others. Can you share a screenshot of the filter that you're using? Let me show you how to post a screenshot to our Help Center:

1. On the Help Center page, scroll down to the Your Answer section and click on the Image icon.

2. Drag and drop your image into the Upload box, or click on it and select your file.

3. Then, click on the Add button in the bottom-right corner of the window.

4. To resize it, click on your screenshot and then click on one of the boxes in the corners, and drag it inward.

5. Once you're finished, click on the Post Answer button at the bottom right of the Your Answer section.

That's it. Once we hear back from you, we'll be able to help you with this.

Here you go, I believe there should be no 'other' entries in this date range, as far as I can see from checking the data!

Hi Nick,

You can remove the option limit in the chart to show all the options and instead of them showing as Other Entries. Here's how:

1. In Jotform Tables, click on the chart then click on the Gear icon to open Chart Settings.
2. Next, go to the Data tab, and remove the number under Option Limit.

Give it a try and let us know if you need any help.