Histogram of dates or time stamps

[jnicolich]

Is there an efficient way to generate a histogram of dates (time stamps) in Knime? The histogram node doesn’t accept dates as input. As a work around, I can think of two inefficient approaches:

1. Use Date&Time to String node followed by a group by count and bar plot. The problem with this is that I am limited to monthly or yearly bin ranges.
2. Use Python View node (works great, but it’s not KNIME).

[gonhaddock]

Hello @jnicolich

I think that you’ve summarized the options quite well; besides you didn’t mention R along with Python.

What I don’t agree about your first option is the limitation on monthly / yearly… once it’s defined as string, it can be any other (weeks…)

BR

[mlauber71]

@jnicolich here is a line chart with dates on the x axis. Maybe you can provide sample data and maybe a sample for a graphic you want.

How to rotate the scale of a Line Plot?

@rogerius1st and there I was hoping to convince you of the benefits of employing Python graphics in order to get interesting charts: [from_knime_linechart_dates] With the help of KNIME Data Apps one can create a GUI where you can select the data change settings in order to make this usable in similar situations: [image] The settings will be converted into Python code. Once a framework is there you can change the settings - or even better ask ChatGPT to do it for you. Also let it explain th…

[jnicolich]

@mlauber71 this example workflow is very impressive and something I will consider for the future. My question was primarily about finding a simple solution such as the as the KNIME Histogram View which is available for numeric data. For now, a Python View using a Pandas/Matplotlib histogram plot will work for me.