Forum Discussion
Using a Date filter and KPI
Hi, I have a date, "Target Date", which has multiple date entries. I have it in a filter by "Relative Date" selections, for things like, weekly, bi weekly, etc. I also have an "Expectations" colu...
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