Join Slack
Powered by
Hi, I'm trying to create a metric which calculates...
# gooddata-platform
d
Diana Tiganeva
09/13/2022, 8:45 AM
Hi, I'm trying to create a metric which calculates the average time it takes someone to close a support ticket. I do have the creation and closure dates but not sure on what the exact query should be. Can anyone help? Thanks
j
Joseph Heun
09/13/2022, 8:55 AM
Hello Diana, you will need to ensure that your LDM is configured with the time dimensions in order to calculate for the average time. There are some good articles here helping you to understand how to do so:
https://community.gooddata.com/metrics-and-maql-kb-articles-43/data-modeling-time-221
https://community.gooddata.com/solution-architecture-62/working-with-time-in-workspace-201
Can you please confirm if you have your LDM set up like this in order to make the calculations?
Open in Slack
Previous
Next