Good Afternoon, community.
I'll try to be as clear as I can (english isn't my native language).
I have these two tables prod_diaria_obras and metas_eqp_obras.
In the first table (prod_diaria_obras) I have 4 columns : Date, Team, Daily Productivity and Acumulated Goal.
In the second table (metas_eqp_obras) I have 4 columns as well: Team, Year, Month, Monthly Goal.
The monthly goal of a team can changes a lot and in a single year the same team could have 3 or 4 goals values.
What I'm trying to accomplish:
I'm building this report and I want to display, in addition to charts, card containing 3 values: GOAL, ACUMULATED GOAL and PRODUCTIVITY. In this report I also have 3 slicers: YEAR, MONTH and (a slider) DATE
What I'm struggling with:
I want the sum of GOAL to be adjusted dynamically according to the filtered years/months.
So, let's say that the months 2 and 3 of the year 2022 are filtereds, I want to display the sum of GOAL for that period and the ACUMULATED GOAL and PRODUCTIVITY could be adjusted by the slider.
It seems easy but I'm really struggling with it. Can someone, please, help me with this issue?
Thanks in advance.
Best regards, Marcio Mendonça.
