Skip to content
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

Use LookML duration instead of hardcoded date_diff and datetime_deff #4

Open
cjyoos opened this issue Apr 15, 2021 · 0 comments
Open

Comments

@cjyoos
Copy link

cjyoos commented Apr 15, 2021

Hello Looker friends!
Don't know if this repo is still maintained. I got a bit discouraged from using the marketplace when I realized that there is no way to deploy marketplace to dev. I.e. as soon as you load marketplace, it is exposed to everyone - which seems goofy. So I am using this block so I can control it.

It would be rad to update the dimensions in zendesk_block.view.lkml that hardcode sql days_to__ to use looker dimension groups.
Specifically:
dimension_group: to_solve {
type: duration
intervals: [day, hour, minute]
sql_start: ${created_raw} ;;
sql_end: ${ticket_history_facts.solved_date} ;;
}

dimension_group: to_first_response {
type: duration
intervals: [day, hour, minute]
sql_start: ${created_raw} ;;
sql_end: ${ticket_history_facts.first_response_date} ;;
}

Abstraction Baby!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant