Results in report do not match when the type changes - ie. single score shows a different count value to list

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-15-2022 05:57 PM
Hi all, I am having an issue with a report that shows different results depending on the report type. The report does have filters, but for the purpose of trouble shooting, I recreated a 'test' report with no filters and had the same results where the record total was different. I have also replicated this with other tables and had no issue, it seems to just be the sc_cat_item table.
Report table: sc_cat_item
Filters: none
Records when report type is 'list': 1837
Records when report type is 'single score' = 1566
Any assistance would be much appreciated, thank you
- Labels:
-
Reporting

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-15-2022 07:59 PM
Hi Emma,
if you click on the score, it will take you to the list of records. Can you click on 1566 in the single scorecard and see if it's taking you to the correct list and if there are any filters in the list.
If it's not taking you to the correct list, then the table selection could be the issue and if the list has any filters, we need to remove them to confirm.
Another thing is Aggregation value shouldn't be "Count Distinct" to ensure the correct results as Count distinct only shows unique records from the table.
Regards,
Muhammad
Muhammad

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-16-2022 09:46 PM
Hi Muhammad, thanks for your reply.
Aggregation is Count, not Count Distinct.
If I click the single score number within the report, the list it opens is the correct data, has no filters and the number of entries matches the single score. If I navigate to maintain items and remove all filters, this also matches the list/single score from the report. But, these still differ to the # of items when running the report as list type.
I tried exporting the 2 lists to compare entries and see what the difference was, and interestingly, these numbers change again:
1. Clicking on single score within report to open list, or navigating to maintain items and removing all filters – shows 1570. Exporting either to excel shows it is exporting 1841, but spreadsheet then shows 1557 line items (not including heading).
2. Running report as list type – shows 1841. Exporting to excel shows it is exporting 1841, but spreadsheet then shows 1557 line items.
So, seems to be an issue with the data more than how the report is working perhaps, as Slawek suggested, I will raise a call with HI portal.
Thanks again for your help.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-16-2022 03:24 AM
It looks like SN error.
You can report to HI or just ignore.
Try using Switch to Classic UI on report. Classic UI is showing correct numbers.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-16-2022 09:49 PM
Hi Slawek,
Thanks for your response.
Switching to classic UI did not change the result.
Unfortunately I can't ignore the issue as it's affecting my reporting, this is how I came to discover the problem as my dashboard showed a report had 6 results, but clicking the score to open the list view then showed 0 results.
You're probably right about it being an SN error, as it seems to be more than just the report since the figures differ even when exporting to excel (as per response to Muhammad), so I will raise a HI portal call as suggested.
Thanks for your assistance.