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.