Skip to main content

Hi Folks,

 

So I have two sheets, One sheet has daily agent scores and another data set with monthly scores.

 

I have a parameter [Start Date] and [End Date]. For daily scores, I have created a 'Date Range' field which selects the range based on parameter range selected.

 

But in the monthly score dataset, I have two column Month and Year. I am stuck at creating a calc field which will select the date range but in Month/Year from start Date and Month/Year from End Date parameter.

 

As in I dont have the exact date to create a calc field to select the range. But I want to create a calc field which will select all the months within the range selected for the daily sheet and populate monthly scores within that range.

 

Below is screenshot from Monthly data set with columns present:

Calculated Field to select Date Range from ParameterI want the sheet to populate all the month data for the date range selected from the daily sheet.

 

Thank You

8 answers
  1. Jun 19, 2023, 11:56 PM

    So, if the user chooses April 15 to May 15, which data are you supposed to take from monthly scores?

    If it's both months, you just truncate Start Date and End Date?

    MAKEDATE([Year], [Month], 1) >= DATETRUNC('month', [Start Date])

    AND

    MAKEDATE([Year], [Month], 1) <= DATETRUNC('month', [End Date])

     

    ---

    Antoine Dinimant

    Freelance consultant, trainer & teacher

0/9000