Scatter-Plot | y-axis with time

[USCHUKN1ME]

Hello, I want to be in the Y axis the time from 00:00 to 24:00
and write in the x-axis as date (days). The source data comes from
emails (time and day of receipt). As you can see from the screenshot,
the Y-axis is not correct.

A Tipp how can i fix this?

Greetings

[ipazin]

Hello @USCHUKN1ME,

have your y axis as Time and x axis as Date and they’ll be sorted according to your needs.

Br,
Ivan

[USCHUKN1ME]

Hello @ipazin ,

thank you.

Is that the only way ? The time as Y-axis would be better for larger date
ranges.

Compare KNIME scatter with Excel:

What i want:

Some chance to get this?

Greetings

PS: Is the scatter-Plot the right way?

[ipazin]

Hello @USCHUKN1ME,

I didn’t mean to replace axes. I meant to have column with dates as Date column type and column with time as Time Column type in KNIME. (Not as strings.)

@USCHUKN1ME

PS: Is the scatter-Plot the right way?

Don’t know. What do you want to show on/read from your visualization?

Br,
Ivan

[USCHUKN1ME]

Hello @ipazin ,

ok - works

(but now no colors)

I would like to display the temporal distribution of Orders that arrive via
email over a longer period of time and thus determine the workload.

Greetings

[ipazin]

Hi @USCHUKN1ME,

well I would say above picture gives you some indication how to determine workload. Additionally you can create time frames (06:00-10:00, 10:00-14:00,14:00-18:00 for example) and then show count in it. Also if days don’t matter you can average values and if they do you can average values over Mondays, Tuesdays… You can use Bar Chart for it.

Br,
Ivan

[USCHUKN1ME]

I will try !

Thank you!

Greetings