Aggregating by date not available

Nick_AMS

Hi,

I'm looking to aggregate results from a XANO table by a date field ('month') in this case, but it's not appearing as an option when configuring the output on the query.

Table I'm looking to query-
[image.png]SQL equivalent of what I'd be looking to run would be "Select month, avg(value_eur_per_litre) from fuel_prices group by 1"

Options appearing in the 'Configure return' window.
[image.png]Guessing this means that aggregating by date isn't supported, but any reason why this would be the case?

Any advice on workarounds? Guess I could try querying, changing date field to text and then re-aggregating, but maybe I'm missing a better optoin.

Thanks!

Nick