Ability to analyze measures between 2 dates in the dashboard

Comments

1 comment

  • Avatar
    Adam Bender

    Why don't you just create a boolean field called "within_policy_date" or something and apply that field to each transaction?

    Then you wouldn't even have to filter by a date range, you could see what payments, etc. came in within the policy effective date range and which didn't.

    It could just sit next to the transaction amount column (or wherever) in your fact table.

    0
    Comment actions Permalink

Please sign in to leave a comment.