jstanden / cerb

Cerb is a fully customizable, web-based platform for enterprise communication and process automation. Create high volume shared inboxes. Integrate with any API-based service and automate nearly any repetitive digital workflow using the specialized KATA language and browser-based coding tools. Production: https://github.com/cerb/cerb-release/
https://cerb.ai/
Other
80 stars 38 forks source link

[Data Queries/Metrics] `metrics.timeseries` can't return `@dayofweek` or `@monthofyear` categories #1714

Open jstanden opened 1 year ago

jstanden commented 1 year ago

The metrics.timeseries data queries always return an absolute date-based x-axis.

A client would like to have an x-axis like Jan-Dec with comparison series for '2021 vs 2022'.

To do this, metrics.timeseries either needs to support qualitative categories on the x-axis, or we need to introduce a metrics.subtotals data query that supports it.