Use date literals in business calculation

Ask the Community
1

Hi, how can I refer to date literals in a business calculation ?
With this formula :

count(
  case(
    when: visits.visit_date >= '2023-03-10'
    , then: visits.visitor_id
  )
)

I get an error :

Expected `date` but found type `text` for `right_hand`

Note: I understand this looks like something that could be done with a condition on the chart itself but the idea here is to cut the line in multiple segments, each with a different color, by creating one measure for each segment. :sweat_smile:

2

Hi @dacou

Currently, we do not support casting functions in business calculations. However, we will include your case in our backlog and inform you of any updates regarding it.

As a workaround, you can create a custom dimension called visit_date_later_10_march with the following formula:

{{ #THIS.visit_date }} >= ‘2023-03-10’::date

Then, you create a business calculation as follows:

count(
  case(
    when: visit_date_later_10_march
    , then: visits.visitor_id
    , else: null
  )
)

This will count the number of visitors whose visit date is later than or equal to March 10, 2023. If you have any further questions or need additional support, please let me know.

3

Hi @di.hoang

Is there any updates about casting functions in business calculations?

4

Hi @yosua,

At present, we do not support type casting in Business Calculation. However, we plan to include this functionality in the future with our forthcoming AQL Expression feature. This new feature is intended to replace and enhance the current Business Calculation system.

You can check this post [Upcoming] Our brand new Analytics Query Language, AQL! for more details.