Having an Issue with the "BY" feature in gooddata Our data looks like below usersid_ids user_id local_user_id 1 john john 2 john2 john 3 Mary Mary 4 Mary2 Mary and Joins to our fact tables through usersid_ids. The main thing to point out there can be multiple local_user_ids to one user_id, userid_ids which is why we are grouping by local_user_id. userid_ids is unique This is our MAQL When we create. table we get 14. But when we do a count with this its 28 (sometimes). For instance in the viz here. I swithc from table to bar and the number changes. I get one number and someone else gets another https://reporting.laivly.cloud/dashboards/#/workspace/tenant-kors-v3/dashboard/527829e3-ab94-4709-965a-c508b77dcc95 We can't make sense of it

SELECT count({label/dim_sidd_user_ids.local_user_id})
WHERE(
SELECT ({metric/sidd_lost_order})
BY {label/dim_sidd_user_ids.local_user_id}
) > 0
AND
(SELECT ({metric/sidd_lost_order})
BY  {label/dim_sidd_user_ids.local_user_id}
)  <= 0.50

Hi Doug, I have accessed your environment but I must say I was not able to reproduce this strange behaviour at this time. When I use “Explore from here” on the Insight from the reported Dashboard, I’m getting the correct number of 14 for both table and column Chart version (as the visualisation inherits the Dashboard filters in this case). See the screenshots:

Its definitely not the user, it was seen across all users including me. I tried cache as well. It would only show 28 yesterday. Today, it's correct

That is indeed strange. I would suggest to record HAR file and download explain file when you encounter the issue again.