Does Yavin support "speed" (average over date) measure? about framework HOT 3 CLOSED

Hi @QubitPi 👋 , Elide & Yavin supports all the functions your database supports (including aggregation). Here is an example from our demo config that uses sum, case, cast, and replace:

Not sure if you are looking to aggregate when calculating "speed", but this is an example I was able to create on our demo data without aggregation:

        {
          name: speed
          friendlyName: Speed
          category: Stats
          type: Decimal
          definition: '''
            (cast (case when {{$duration}} like '% min' then REPLACE({{$duration}}, ' min', '') else '0' end AS INT)) / ( NULLIF( DATEDIFF( YEAR, PARSEDATETIME({{$release_year}}, 'yyyy'), PARSEDATETIME({{$date_added}}, 'yyyy') ),  0) )
          '''
        }

This takes the duration of a movie in minutes and divides it by the difference in years between the year it was available on netflix and the movie release year.

from framework.

Hi @jkusa, thank you very much for the prompt response. The movie example you provided really helped. With your hints, we can see the desired Yavin report with

        {
          name: speed
          friendlyName: Speed
          category: Stats
          type: Decimal
          definition: '''
            {{$total_amount}} / ( NULLIF( DATEDIFF( DAY, PARSEDATETIME({{$task_start_date}}, 'yyyy-mm-dd'), PARSEDATETIME({{$task_finish_date}}, 'yyyy-mm-dd') ),  0) )
          '''
        }

This helps our team a lot! We will dive into Yavin and Elide docs to learn more. Thanks again!

from framework.

Issue resolved. Thanks

from framework.