Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  • Create a filter using an expression
  • Set a default filter on a stream view

...

  1. In the chart press
  2. Press 
  3. Configure the filter with the following details:
    • Name: Last 40 days
    • Conditions:
      1. The condition dialogue starts with Where ALL the following are true - leave this as it is
      2. Select CalculationDate
      3. Press on equals - from the drop down list that appears, select greater than
      4. Enter this formula, which will take the current date, and then go back 40 days

        Code Block
        dateAdd(now(), _DAY_OF_MONTH, -40)


      5. Press the ABC button - this will now say fx

      6. Save your changes the stream view configuration form

  4. When you have completed all these details press .
  5. Your grid should now show only results from the last 40 days.

...

  1. Open the dashboard Debt levels by payment means
  2. Open the stream view configuration form for the view Debt levels by payment means
  3. Go to the Filters section
  4. Press
  5. Drag the filter Last 40 days into the list of filters for this view
  6. Press 
  7. Go into App mode
  8. In the dashboard, apply the filter Last 40 days
Info

In PhixFlow, any filter defined on a view on a stream can be used on any other view defined on that stream.