Hi , I have a requirement where, for example, there are 10 employee records with onboarding and offboarding dates. I need to implement a date range control. For instance, from January 1st, 2024 to April 30th, 2024. Then, in the bar charts, I need to display the count of onboarded and offboarded emp…

Hello Srinath, I am afraid, you need to fix date fields as a single date field in the backend or via custom sql. may be a union of both date fields to capture all data points and if there are duplicates, they could be handle in visuals. Hope this helps. Cheers, Deep

Hi Deep, We don’t have much exposure to SQL now due to access issues so just want to check if I can solve it with in the Quicksight analysis. I have seen similar question Month control selection but I don’t find answer . Thanks, Sai

Hello Srinath, I guess its not possible to that on analysis using multiple date fields that too for a single visuals. For Single visuals where you want to show the count on bar or line chart for both onboard & offboard, you may need to have single date field to be used in x-axis. Hence, you would…

Hi @Deep , I will check on custom SQL about single visual for month on X-Axis. Is there a way I can have date range period that works for 2 visuals one for onboarded visual and another one for off boarded visual? For example when I select data range Jan to April then Onboard visual should show ho…

Date range for Visuals

Q&A

Deep May 7, 2024, 7:16am 6

Hello Srinath,

Thank you for the response. i am not sure at the moment but you may refer -Calendar filtering based on 2 date fields - #6 by sagmukhe

Hope this helps.
Cheers,
Deep

Topic		Replies	Views
How to create one date filter to apply for two different dates in two different data sets Q&A filters , date , quick-sight , visuals , dataset , Business-Intelligence-Engineer	4	1322	April 22, 2026
Month control selection Q&A analysis , parameters , quick-sight , visuals , dashboard , calculations , pivot-table , visual , Business-Intelligence-Engineer	23	421	April 29, 2024
I need to create a Custom Date Range control in Quicksight dashboard Q&A analysis , date , quick-sight , filters-controls-and-parameters , calculations , Business-Intelligence-Engineer	4	2009	January 13, 2024
Approach to Comparing Two Date Ranges of Data in a KPI Visualization Q&A analysis , quick-sight	2	1452	December 13, 2021
Restricting the selection on date range filter Q&A quick-sight , filters-controls-and-parameters , Business-Intelligence-Engineer	4	67	September 11, 2025

Date range for Visuals

Related topics