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!