0

Filter Selected Date

If user selects one date the data has to retrieved from starting date to till selected date 

Lets say I have 5 years data for an insurance company where I have applied several filters in the presentation but if I apply the date filter for  (may 5 2021 )  I get the data for the selected date only but the actual requirement is I need the records from starting date to may 5 2021 till date 

3 replies

null
    • Principal Customer Solutions Consultant
    • Mark_Oldfield.1
    • 6 mths ago
    • Reported - view

    Hi Immanuel,

    The scenario would require a model parameter (based on the date attribute you wish to filter) and then this parameter could be used to generate a list of dates as a range, with a start date to the date in your parameter. This list could be used in such things as filters, aggregates etc.

    An example below:

    In formulate, I will create a model parameter, (in this example I will use the training model data set)

     I will select the members I want to be present in my parameter (this will act as the 'up to' date)

    I can change the default member but I will leave this as default for this example and save this called 'My DateParameter'

    Next, we will create a list in Formulate, from the side bar chose the 'Range List'

    In the properties pick the element you wish to be the start date. 

    and for the second element, you will select the date parameter we created previously.

    we will save this list as 'MyDateList'

    Now I have this list, I can use this in a discover

    here I have gone to my date attribute, viewed the elements and selected my new list. When the list is added the data parameter is then shown

    Now if I select a date from the parameter it will give me a range of dates from the defined start date to the parameter date

    I hope this has given you an idea of how you may apply this to your scenario

    thanks

    Mark.

    • imbarmarinescubar_pyram
    • 6 mths ago
    • Reported - view

    Hi, you can also try to use the range option within the calendar filter:

     

      • NPANS
      • 6 mths ago
      • Reported - view

       if you are using real dates, and just need it as a filter, this option is FAR simpler and FAR quicker. 

      Simply drag the data chip to Filters, and the calendar is instantly operational

Content aside

  • Status Answered
  • 6 mths agoLast active
  • 3Replies
  • 52Views
  • 4 Following