RELATED IDEAS
This idea has been merged into another idea. To comment or vote on this idea, please visit A-I-8390 Reduce duplicate Rows in Reports: Aggregate/merge related data in a cell (in a pivot report or hierarchy report).
Ability to hide duplicates in Idea List when joined to Idea Request/Votes (show unique)
Merged
There is a duplicity in idea list report (accessed by ideas/list) for which I have found explanation and consider it a bug (most probably bug on SQL level (or similar higher layer data querying is happening).
This is in general a problem when you have 1 main entity (maybe happening only when you have 1 main entity + 1 related entity, not sure) and you use filter from an entity not defined in data model for the report.
Example
Data model: ideas, related product
Filters: Product Name, Idea status, Created by Aha! User:Any (from feature request)
Columns: (not showing feature requests related columns)
I understand that from one standpoint this is “as designed”. But I have user complains about this and I believe their perspective should have preference – there are multiple product designs that can be done, could you please do something?
This is in general a problem when you have 1 main entity (maybe happening only when you have 1 main entity + 1 related entity, not sure) and you use filter from an entity not defined in data model for the report.
Example
Data model: ideas, related product
Filters: Product Name, Idea status, Created by Aha! User:Any (from feature request)
Columns: (not showing feature requests related columns)
I understand that from one standpoint this is “as designed”. But I have user complains about this and I believe their perspective should have preference – there are multiple product designs that can be done, could you please do something?
My point being. Aha now shows to thousands of its customers potentially duplicate and wrong reports. Some C level people might not have the patience to listen for explanations. Not a red alert.. But yellow alert for sure. :-)
Hi, thanks to Susie for helping me submit the idea. But this is not about "hiding" duplicates. It is about prevention of this situation. E. G. reports would not allow filtering by entity fields that are not in data model + it would announce after each redrawing of the data grid in list report that there are duplicates not identifiable because fields from unique entity were not shown, just the one that got duplicated because of inner joining. And obviously, this could be taken a bit holistically and verified on other types of reports too.