Hi The dashboard I’m working on contains many datasets and contains a date filter that’s selected by the user. There are a few calculated fields that should be displayed on the dashboard, such as MTD, which should be filtered by the whole month. What is the best way to separate the filters for th…

Hi @Noys , Not too clear with the ask, but will try to add details as per my understanding and break this down to 2 asks. You want to calculate and display MTD metrics, which most probably wont need filtering if we use period related window functions for calculation. If there are more visuals or …

Hi @prantika_sinha , thank you so much! It’s not the exact scenario, it’s the same as you described in the second clause. Actually I’m seeking for filter by month, but in the same time, the other visuals should filter only by the picked date. As I understood recently, the solution should be to add…

Filtered by the whole month

Q&A

Xclipse May 15, 2024, 12:42am 4

In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post. (Details on using Arena can be found here - Quick Sight Arena

Topic		Replies	Views
Monthly date parameter Q&A analysis , filters , date , quick-sight , calculations	4	960	October 21, 2022
How can we aggregate all values before a certain month? Q&A filters , quick-sight , calculations	5	415	August 2, 2023
Custom Filter for date Q&A filters , quick-sight , calculations , Business-Intelligence-Engineer	1	119	March 15, 2024
Trying to Add a Date Dropdown filter that will apply to two different dataset Q&A analysis , parameters , error , quick-sight , dataset , calculations , Business-Intelligence-Engineer	4	220	March 12, 2025
Filter by last 45 days (create_date) based on the month filter Q&A analysis , filters , parameters , date , quick-sight , dataset , calculations , visual , Business-Intelligence-Engineer	5	108	August 23, 2024

Filtered by the whole month

Related topics