Feature request: histogram function

[SoleroTG]

Hi,

I use Analytics on a regular basis, mainly with Nextcloud Tables as data source.
Recently, I ran into the problem of doing a histogram analysis of enums, although the general idea is not bound to this data type.

I have a timestamp in one column and an enum in another. I failed trying to get a histogram out of this, let alone a grouped histogram with the timeline shown as days/weeks/months/years on the x-scale and the enum being represented as a goup-entity.

If I am not totally blind and this feature is already in place, I would be very happy to see a histogram feature like this added.

Cheers,
Solero

[Rello]

Hello,

sorry for the delay. do you have a screenshot or export of the table data to have a better reference?

[SoleroTG]

Hi,

Sure. Here is a screenshot.

In the histogram I would expect three columns: Option 1, Option 2 and Option 3 each attached with the number of occurrences of the specific option.

At best the histogram can handle multi selection enums and can be filtered to a specific date range.

Is this description understandable? I am happy to help.

Cheers and a happy new year,
Solero

[Rello]

Hi,
I am not really sure on this yet. do you have a mockup of a chart that you would expect?

[SoleroTG]

Hi,

Sure. A sketch based on the table above would look like this for the total numbers:

The height of each column represents the number of occurrences for each option.

The advanced version grouped by time range would look like this:

Here the content is the same but grouped by e.g. month.