Forum Discussion
Using a Date filter and KPI
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
So, i have a date table and a column with Expectations(=20,30,40,50, etc.) So a line could look like this
Name, Location, Task, Date, Expectation
John, Minnesota, Nurse, Jan 2020, 60
Basically, I wanted to pick a date range (1 week, 2 weeks, 3 weeks, etc), then say the 60 above is =1 week. If i choose 2 weeks, the number would multiply to 120 (or 60x2). If i choose 3 weeks, the number would report for Expectation as 180. Each week I choose from week 1 would multiply that way
Hi Kornholio ,
Sorry I didn't get the point.
How do you define the date range? Weeks between selected max [Target date] and min [Target date]?
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Alright, bit of a change, so if i have a Period Date filter dropdown and i need for Period 1 to show # of Units as whatever they have, say 30, and the Expectation is set for 60, then when i choose Period 1 and Period 2, the # of units will double and the Expecation would too. Is there a calc for this? I will send a sheet of data i use if you need it
Hi Kornholio ,
I didn't find "units" column in your sample data but i did find "Expecation" column.
So basically you want the value/sum of "Expecation" multiplied by the count of selected "Period"? And should the target date within the selected "Period"?
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.