I think I saw an article or post a while ago about this issue, but can’t find it so I figured I’d post here and see if anyone can point me in the right direction or advise me on how to work around this. (Also, bug or intended behavior?)
I have a custom report that reports the visits for 2 custom dimensions: country code and region code (different from the Matomo location). Usually the region code is not reported and we only get a country code. So in my example today, we have 605 visits that just reported “Country: US” and 2 visits that reported “Country: US and Region: FM.”
When I request a hierarchical report (via both Matomo UI & API), all of these visits show up correctly, US says 607 total and US - FM says 2:
But when I request a flattened report (via both Matomo UI & API), the “Country: US (only)” row completely disappears, and only the “US - FM” row is counted:
So it looks as if “DE” is the most reported country code, even though it only has 88 visits compared to the 607 for “US.”
Intended behavior or bug? Any way to work around it other than just requesting the hierarchical report instead? Perhaps a config value, API parameter, etc.?