topic Re: Report not showing full totals in Dashboards & Reporting

Report not showing full totals

LStClair — Tue, 12 Jan 2021 11:47:15 GMT

We have a field where a company can say they are more than one type of farm. When I run a report on this data it doesn't show whole data. For example I know one farm type should show 228 farms but the report shows 23. I can't figure out why this is. Could it be because they have more than one type selected?

Re: Report not showing full totals

MatthewShepherd — Tue, 12 Jan 2021 11:52:15 GMT

Hi @LStClair

How are you reporting on these field values? Is it a list, custom report, or dashboard report? My first thought is perhaps something is filtering the data? If you can share more details on how you are creating this report or a screenshot, I might be able to help troubleshoot.

Re: Report not showing full totals

LStClair — Tue, 12 Jan 2021 14:01:01 GMT

Hi @MatthewShepherd

I'm just creating a custom report that show companies and what farm type they are. Even when I go into lists and create it from there I still don't get the same number as my original Excel list.

Re: Report not showing full totals

MatthewShepherd — Tue, 12 Jan 2021 14:07:55 GMT

Hi @LStClair

OK, can you share a screenshot of your list criteria?

Re: Report not showing full totals

LStClair — Tue, 12 Jan 2021 14:14:31 GMT

Hi @MatthewShepherd

This is my screen shot of properties

This is my visualisation

When I create a company list based on just Suckler herd I get 323 companies. In the report I get 23.

Re: Report not showing full totals

MatthewShepherd — Tue, 12 Jan 2021 14:18:37 GMT

Thanks @LStClair

In the top left of the report, when you click Filters, which filters are set? If you extend the date range or remove other filters does your contact number increase? If not, can you share a screenshot of your filters?

Re: Report not showing full totals

LStClair — Tue, 12 Jan 2021 14:18:48 GMT

@MatthewShepherd I've just realised I had a date filter in the setting. 🙈

Re: Report not showing full totals

MatthewShepherd — Tue, 12 Jan 2021 14:20:43 GMT

@LStClair no problem! Thought it might be something along those lines. Hopefully, your numbers match up now. If they do could you mark the above as the solution? Thanks.

Re: Report not showing full totals

LStClair — Tue, 12 Jan 2021 14:27:18 GMT

@MatthewShepherd thank you for your time in responding today. It was very good of you.