Experiencing an issue with our Amazon Quick Sight dashboard where March data is not appearing in our visualizations, despite being present in our Amazon Redshift source. Here are the key details:
Data Source: Amazon Redshift SQL (RSS)
Date Field: The data in RSS is based on an ‘_asofdate’ column
Current Behavior:
- Data for most months is populating correctly in Quick Sight
- March data specifically is not showing up in visualizations
- The March data is confirmed to exist in the Redshift source
Verification Steps Taken:
- Ran SQL queries in Redshift to confirm March data exists
- Checked calculated fields in Quick Sight for any March-specific exclusions
What could cause Quick Sight to omit March data specifically when it exists in the source?
Hi @harshez
Welcome to Quicksight Community and thank you for posting your question.
I would also recommend you to check these -
-
Are there any filters visual level and dashboard level that is omitting March month (something like show only last N months etc) - try removing the filters and check
-
If you are using SPICE in quicksight, then can you check your SPICE refresh - Try refreshing again.
let me know the outcome
thank you,
Shravya
Hi @harshez - Welcome to AWS Quick Sight community. Like @shravya mentioned, check whether you are using SPICE or not. If not are you using any custom sql, if yes check the sql and run it redshift and see whether you have any march data coming or not. Quick Sight will not filter any data unless until there is a filter or SPICE enable ( which stores the data when it refresh).
If the issue is not resolved, we can connect offline through message and can check this symptom.
Regards - Sanjeeb
Hi @shravya. It was a nested filter that I overlooked. It worked now. Thank You.
1 Like
Hi @Sanjeeb2022, thank you for the the help. It worked.
1 Like
Thanks @harshez . Please mark the require post as solution so that it can be closed.