-
Notifications
You must be signed in to change notification settings - Fork 35
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Does Yavin support "speed" (average over date) measure? #1725
Comments
Hi @QubitPi 👋 , Elide & Yavin supports all the functions your database supports (including aggregation). Here is an example from our demo config that uses Line 161 in 27ac7ad
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:
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. |
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
This helps our team a lot! We will dive into Yavin and Elide docs to learn more. Thanks again! |
Issue resolved. Thanks |
Is your feature request related to a problem? Please describe.
I'm always frustrated when I see this problem blow
Describe the solution you'd like
As the title suggests, our team is having a Yavin app backed by Elide and we need to have some
measure
that report some business logic about how "fast" things go. For example, our database table have 3 columns2023-06-15
)2023-06-23
)21
)Our speed is defined by
What we would like to see on a Yavin report is, for example, when we have 3 rows in the aforementioned table:
then we can see some "trending" data like:
Our model configuration looks like this:
The closest analogy we can give is an
average
measure over some date range. However, we didn't find any documentations ondefinition
foraverage
.Any suggestions would be greatly appreciated. Thanks.
Describe alternatives you've considered
I have no other idea, sorry.
Additional context
N/A
The text was updated successfully, but these errors were encountered: