I’ve come across an issue with the limit rows feature in dashboard widgets. I’m not sure if it’s due to the database design, or a bug in the software.
When ever I try to limit rows, for example to display top 10 customers, items, etc, the total at the top of the query will sum all measures including percentages. Some %Measures make sense, like allocations (always sum to 1). However, most ratios do not make sense - GM%, turns, etc.
Has anyone else come across this issue, and what was the solution?