Extract timestamp from dashboard filter to use in calculation behind

Q&A
, , ,
1

Hello Team,
Initially, I tried generating an heatmap using the “Points on map” visualization module, but the heatmap disappears when the zoom level is below a city/department scale, leaving only raw points displayed on the map. Therefore, my alternative is to generate the heatmap in HTML.

I am looking for a solution to extract the timestamp from the user-selected filter to use this time interval for calculating the heatmap with an external code that generates the new HTML file. However, I don’t see any possibility to extract the user-selected timestamp.

Is there a feature to achieve this?

2

Hello @nicolasf

Is the user picking dates from a field or a parameter? If you’re using a parameter and your dashboard is embedded you could try using getParameter():

3

Hello @WLS-D
The user is picking dates from a field and not a parameter. But, I heard that Quicksight can support custom visual extensions that can integrate with external mapping libraries but I didn’t find any exemple of implementation.
Here is the steps for Custom Quick Sight Extension:

  1. Create a custom visual extension using the Quick Sight Developer Portal
  2. Integrate Mapbox or Leaflet for better heatmap functionality
  3. Access filter parameters through the extension API

This approach allows you to:

  • Maintain the heatmap at all zoom levels
  • Access filter values (including date/time filters)
  • Keep everything within Quick Sight

Do you have a workaround about this kind of implementation ? I am triying to put js it to accept dynamic data and user filtering.

I want to precise that I don’t want to embed my quicksight dashbord outside quicksight.

Regards

4

Hey @nicolasf

I think you will want to use a Custom Content visual:

Here is a post that describes a use case: