Forum Discussion

Kornholio's avatar
Kornholio
Helper III
6 years ago

Filter for Periods

I have a CSV file that comes in, it has a 2 week period of working minutes of people working in different statuses. Each time i bring in a new 2 week period i need the Expectation to stay the same for that period, but if chosing more that 1 period it would increase by 1. So if choice is period 1, then 60, if choice is period 1 and 2 then 120, etc. Is there a calculation that will do this?

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Kornholio 

    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
      Spoiler
      Hi,

      So, I have fields...

      Provider Name
      Expectation
      Units
      Date
      Status

      So, each CSV file comes in to me for a period, say 03-01-20 to 3-14-20 is period 1, 03-15-20 to 03-31-20 is period 2. Each period is used as a filter option on the dashboard, so you can choose 1 or multiple periods. The Expectation during each period is 60 for each Provider Name. This is an expectation of Units to Expectation of 60 each period calculated. 

      So, if the user chooses 1 period the Expectation is 60, but right now if the user chooses 2 periods, the Expectation stays at 60 but the units increase. I need the Expectation to show 60 for each Provider Name during each period, but if user chooses 2 or more periods, the Expectation needs to go up. So 2 periods =120 for Expectation