Time period or the days in the query

[bitsnacker]

Problem

Is there a way to get the time period or the number of days for which the query is made in the cube model? FILTER_PARAMS seem to be a predicate and not providing the dates. Any help?

I am trying to prorate a monthly value to the query period.

Thanks!

[bitsnacker]

Figured it. Can be done using below.

      - name: period_days
        sql: >
          {FILTER_PARAMS.bill.created_at.filter(
            lambda start, end: f"dateDiff('day', parseDateTimeBestEffort({start}), parseDateTimeBestEffort({end}))"
          )}
        type: number