Hi Team, I would need some support for an issue one of our customers raised, where there are a significant amount of records not appearing in the GoodData visualizations as they'd expect. We have run checks on the metrics being used and all appears correct, however using the same queries directly in redshift brings up more records than in GoodData. Could I please get some support on this issue via DM (as details and screenshot include customer data)?

Hi Raffaella, Before we proceed further here - the first thing I would try is to create some simple tabular Insight and put there the attributes/facts which they claim that are missing as a single rows or columns without any further metrics or aggregations. That way, you will see the raw column and it’s values and you can compare it with the columns from the source data. If you do that, do you truly see some data missing compared to the redshift data source? This way, we can confirm/exclude that option. Can you please give it a try and let me know about the result?

Thanks Julius, I just did it and can confirm the table row without any metrics is still missing records.

Hi Thanks Raffa,

Thank you, please DM me the screenshots which you’ve mentioned and please provide some example column value which is missing so we can double-check from our end as well. Also, may I ask if this worked normally before and the issue just appeared? Or is this some new situation with a new datasource?

Hi Julius Thank you we will send you the details