I have a chat bar with year in X and Month in group like: [image] When I click on the month bar, I have a navigation action passing the Month and Year to another worksheet where I have a data table. I need to filter this data table using the parameters, but in this table I have the actual quantit…

Hey @Mardcp ! Can you try the solution posted in this blog? I think it will get you the closest to your desired outcome. [image] Creating period comparisons with QuickSight's periodOver and periodTo functions Articles This article uses the SaaS-Sales Dataset that you can …

Hello @Mardcp , welcome to the Quicksight community! To make sure I understand, when you say the quantity of the month do you mean, for example, January =1, February = 2, March = 3, etc…? And if so, what does your calculation look like? My recommendation as of now is to make that calculation an if…

Hi @Mardcp its an common challenge. Due to filter on month 1 and year 2023 you can’t show data for 1.2022 or 12.2022. You need to bring the data on the same date (1.2023) or extend the filter. There are a few “workarounds” and hints in the community. BR

Hey @WLS-D . Thank you for your answer!! No. When I refer to quantity, I mean quantity of sales, for example. I need to work with the number of sales from the current month, the previous month and the previous year. Could I explain better?

Hi @ErikG . It’s a very common challenge, like you said. I’ve worked with other tools like Tableau or PowerBI and it was very easy to do this. But in Quicksight I couldn’t solve this problem. Can you give me an example of alternative solutions please?

[image] Compare period with same period last year in pivot table Question & Answer Hello, I currently have a pivot table that shows rental information for my product broken down by region. This data is filtered by a Start and End date parameter as seen in this screenshot…

Hi @ErikG . Perfect, I did it! Thanks! But, I need to show in my table only the selected month. Per example: I selected 2023, March, so: I need 2023,Feb do calculate the previous month I Need 2022,March to calculate the previous year However, in my data table I would like to show only 2023,March…

You could create a 0/1 field for month you want to display and filter the new field.

@ErikG , I’m sorry to ask again, but when I created the new field and checked the month the calculation fields didn’t work again because I only filtered for a month. I don’t understand how to filter only on the table and not on the data I’m using in the calculated fields

Hey @Mardcp ! Depending on the calculations you can add PRE_FILTER to your calculations.

Hey @WLS-D , how are you? I’m using the periodOverPeriodPercentDifference function. I think that I can’t use the PRE_FILTER in this function, right?

Navigation action using date parameters

Q&A

ErikG November 20, 2023, 9:22pm 6

Topic		Replies	Views
Quick Sight action Q&A quick-sight	1	388	February 23, 2023
Filtering between different tabs in a Dashboard Q&A filters , quick-sight , Business-Intelligence-Engineer	2	60	August 5, 2024
Exisitng rows as derrived column Q&A date , quick-sight , calculations , Business-Intelligence-Engineer	3	142	February 6, 2024
Current Year vs Previous Year Calculation Q&A analysis , quick-sight , calculations , Business-Intelligence-Engineer	3	504	May 24, 2024
No data shown for last month when filtering for N months Q&A filters , quick-sight , pivot-table , Business-Intelligence-Engineer	4	517	January 10, 2024

Navigation action using date parameters

Related topics