Hi Eric ,
Good morning and thank you for writing in.
Unfortunately, the duration type metrics is in seconds by default, meaning you will need to do the conversion on your end to milliseconds.
If you have durations in milliseconds, you would need to convert them to seconds in your SQL query before using them as the `value` in your metric.
In parallel to the above, I'm unsure if you are aware already but we have a public facing Feature Suggestion board available
here so that you can log suggestions ad also that other customers can upvote this suggestion.
If you have any more ideas or feedback in the future, please do not hesitate to reach out again. We are always eager to hear from you and continuously improve.
Thank you once again for your contribution.