Forum Discussion

Kornholio's avatar
Kornholio
Helper III
6 years ago

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" column, this is a number like "60" for specific Persons last name. 

 

So, right now a Person has an Expectation of 60 for weekly. If i choose in the Target Date filter Last Week, then the number of units works and the Expectation works, but when i choose Last Month, the number of units counts for all last month Target Date entries. 

 

What I need to do, is if i only have one Expectation for weekly, e.g. 60, then if I choose bi weekly, it should show Expectation of 120, then if i choose This Month, it should show 240, and so on.

 

Is there a way to apply the additions of Expectations for each time chosen on the filtered Target Date counts?

 

e.g I choose this week for chart, showing all Last Names and thier total units and Expectations, then i choose this month in the filter, i want the Expectations to multiply from beginning weekly Expectation (week 1=60, week 2=120, week 3= 180, etc)

Need Help

11 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

    • Kornholio's avatar
      Kornholio
      Helper III
      6 years ago

      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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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.