Creating a histogram with specific values

[Adeel_123]

Hi Everyone,

I have a query regarding preparing a Histogram.
I have a table that is measuring time difference between previous rows and inputting it into a:- HH:MM:SS format.
The table is:
test.xlsx (9.7 KB)

Now I want to plot these values and make a histogram with dynamic upper and lower control limits in the graph. The graph should look something like this:

I could not find a method to make this graph using the normal Histogram nodes.
Is there a way that this kind of histogram can be plotted? Thanks.

[mlauber71]

@Adeel_123 you could try and use the python integration and ask ChatGPT to provide the code. You can then make the limits flexible with Flow Variables.

And when you wrap that in a component you have your individual dashboard.

Line Plot Readability Fix

Just to see how this might go I have adapted the approach to include a split day where before and after the system would try and calculate the trends: [image] In your case the split date would be 2020-04-01 and there would be two distinct trend lines with different coefficients. I hope I got them right: [from_knime_linechart_dates_its] The component would also provide the split data aggregated to month (or days if you have such data) as KNIME tables so you better could check if the calcul…

Create an Interactive Dashboard with KNIME Components and Python

[Adeel_123]

Hi,

Thanks for the reply. I can surely try your suggestion.
Just wanted to know is there an alternative way to have this kind of histogram through the existing nodes in KNIME ?