1 Reply Latest reply on Oct 25, 2018 7:14 AM by Akram Ebrahim

    Find date associated with a calculated field

    Katie Deehr

      I'm trying to create a calculated field that will give me the date when a set max has been met each month. For example, I can only have 10 new customers a month and I want to know by what date each month I meet that cap of 10. Any advice?

        • 1. Re: Find date associated with a calculated field
          Akram Ebrahim

          Hi Katie,

           

          You can set the max value in number parameter. Parameter helps you to modify thresholds

          Create Parameter -> Integer

           

          Calculated Boolean Filter

          --------------------------------

          Value  >= Parameter

           

          Create Calculated filed

          --------------------------------

          Min (if [Boolean Filter] = TRUE then [Date] end)

           

          This will give you the first date which crossed the threshold. if you want month on month you have to add Datetrunc('month',[date]) in the view.