We would like to be able to report monthly figures for metrics that are captured from RUM on Grail. However, given the volume of available traces we hit DQL Query limits from just a few days of history - so a 12 monthly view is going to be impossible.
We are currently looking at custom metrics built from our own application but as I read the documentation on customer metrics I can see that there is a limitation for the timestamp (no later than 1 Hour and no earlier than 10 Minutes). As we would be waiting for the start of the new month, which would then trigger the specific app function to gather the previous months data and summarize it and then report it against the first day of the month - isn't going to work.
Is anybody doing something similar to this, if so how are you storing the data (doc or metric) and how are you passing the information (api or pipeline)?
Thanks
