Year over Year / Prior Month Comparison Calc

Hi -

Just got Druid set up on the Quickstart and had a quick question. It it possible to create year over year or month over month comparisons on aggregates?

I have detail set of records that I’d like to roll-up to the monthly level, then compare metrics to the prior month and prior year time periods.

Is this possible using Druid? Has anyone done this?

Thanks in advance!


you should be able to get this using druid timeseries query with granularity year or month.

docs -

Ok - thanks. I’ll check into that approach.