Hi, I'm trying to timechart by month, but starting at the 15th of the month. I've looked for "offsets", but I can't seem to find anything helpful. Can someone point me in the correct direction? Thanks Mark ... View more

Hi, I'm trying to group all payments "amount" by month. The challenge is they're in cents, and I would prefer dollars. I have one condition which is search "params.type"="charge.succeeded" . From there I'm trying to collect the params.data.object.amount which is the amount charged in cents. I've tried a number of different ways to divide the amount, but it seems I can either divide the amount by 100, to represent dollars, or I can timechart it, but I can't seem to do both. Below is a mess of where I've ended. host=production | spath "params.type" | search "params.type"="charge.succeeded"| spath "params.data.object.amount" | stats sum("params.data.object.amount") as total | timechart span=1mon Could anyone help point me in the right direction? ... View more