Heatmap works differently on quicksight console and after dashboard is embedded

Question & Answer
, , ,
1

Hi,
We are using a heatmap visual to display average counts by day and hour, with the days of the week as rows and hours of the day as columns.

The db table has dates only for which the count is present. So to get a static grid of size 7X24, we tried creating a dataset query by joining the count table with a static table.

This approach works as expected for the analysis and dashboard in quicksight console, but once embedded into the application, the rows and columns with all null values are no longer visible.

Below is the visual in the quicksight console.

image
image2982×636 22.7 KB

And this is the visual with the same parameter values once embedded in the application. The Sat and Sun rows are missing and some of the hours as well.

image
image2388×506 22.6 KB

Any insights would be appreciated.

Thank you for your assisstance!

2

Hi @KanikaDidwania,

Can you try to create a table or pivot table with the same data to confirm that the issue is specific to heat map visuals?

3

Hi @KanikaDidwania,
One additional thing to note, QuickSight now supports certain highchart visuals to be added; one of the available visuals you can create is a Calendar Heatmap. Take a look at the DemoCentral view to see additional information on how to get started (located on ‘Samples’ sheet).

image
image1664×752 117 KB

4

Hi @KanikaDidwania

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

5

Hi @KanikaDidwania

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!