Cid dashboard data is not showing fully

    If you're experiencing issues with your CID (Cost Intelligence Dashboard) not showing the full range of data available in S3, there are a few steps you can take to address this:

    1. Check QuickSight datasets: In Amazon QuickSight, verify that the datasets are configured correctly and are able to import all the available data. You might need to initiate a manual dataset refresh for each dataset in QuickSight to ensure it's pulling in all the historical data.

    2. Review Athena tables and views: Check the AWS Glue console to ensure that the necessary databases, tables, and views have been created correctly in the Glue Catalog. These should match what you see in Athena and should include all the historical data.

    3. Verify S3 bucket permissions: Ensure that QuickSight has the necessary permissions to access the entire S3 bucket where your CUR (Cost and Usage Report) data is stored, including all historical data.

    4. Update dashboard time range: In the QuickSight dashboard, check if there are any time range filters applied that might be limiting the visible data to the last 8 months. Adjust these filters to include the full 3-year period.

    5. Rerun Glue crawlers: If the Glue crawlers haven't picked up all the historical data, you may need to manually run them to ensure all data in S3 is properly cataloged for Athena and QuickSight to use.

    6. Use CID update command: Try running the command "cid-cmd update --force --recursive" in AWS CloudShell. This will update the dashboard to the latest version and might help in recognizing the full dataset.

    7. Check partitioning: Ensure that the data in S3 is properly partitioned and that all partitions are recognized by Athena. You may need to add or repair partitions if some are missing.

    If these steps don't resolve the issue, you may need to open another support ticket specifically addressing the discrepancy between the data available in S3 and what's visible in the dashboard. Provide details about the S3 data structure, the Athena table definitions, and the QuickSight dataset configurations to help the support team investigate further.
  

Sources
TAO dashboard is showing no data | AWS re:Post
CUR report name to backfill | AWS re:Post
Quicksight Dashboard - Data not refreshing on time | AWS re:Post
focus table (AWS Glue) used by Focus Dashboard has no data from source accounts | AWS re:Post