Measuring a Fact (Numerical) with Date Ranges
回答済みHi friends,
We're looking to measure a custom decimal field on a dashboard, but also be utilized with a date filter. Is this possible? We understand there is some trickiness involved with decimal fields, but essentially we have created this metric:
SELECT SUM(Amount to Add / Remove to Gift Card) BY Ticket Id
Some backstory on this - we are looking to help our team measure the dollar amount from our Gift card requests. We want to provide our team the ability to show the numbers by week or month. We've created variations from the metrics above to test, but are having no success. Any suggestions would be greatly appreciated!
Thanks!
-
Hi Ryan,
Did you have a look at this article here: https://support.zendesk.com/hc/en-us/articles/230871888-Insights-recipe-Reporting-on-a-numeric-field-that-has-a-constant-value
It explains very nicely how to work with numeric fields.
#helpsome regards,
Louise Dissing
Team Lead @ helphouse.io
ログインしてコメントを残してください。
1 コメント