Extract timestamp from dashboard filter to use in calculation behind

Question & Answer
, ,
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?

1 Like
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():

1 Like
3

Hello @duncan
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 QuickSight Extension:

  1. Create a custom visual extension using the QuickSight 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 QuickSight

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: