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?