Chart: 2D Map (Start table list)

Summary

Show selected data in a color map. The horizontal axis can show time duration or lengths. Start table must be a list with the following column types: Identifier, Date + time (from), Date+ time (to), Values.

Example: ...

Situation

This data of demand are to be visualized. For comparing weeks a helper week is calculated, which is available for a common time.

Settings

Add an operator with following settings

Parameter	Value
Identifier 1	D Week
Identifier 2	-
From (horizontal axis)	E From Helper
To (horizontal axis)	F To Helper
Value (for color)	C Result

Farbcodierung einstellen

Can only be done in the settings under the graph: Edit - Colors
A new window opens where you can change the colors for specific groups
You can also change if the values are absolute or percentile

Result

What is visible/can be checked ?

Über die direkte Darstellung kann mit diesem Diagramm gut untersucht werden:

Structural change (e.g. in a time period, from a given Date ...)
gaps in coverage
Shifted collection of data
Special Dates (e.g. Conversion, inventory, days between Christmas and New Year)
Structural developments - rhythms. Especially seasonal rhythms but also changes in the daytime.

With the use of difference calculation (e.g. compare this value to the mean value - so are changes easier to spot)

Project-File

...

Want to learn more?

Settings

Show selected data in a color map. The horizontal axis can show time duration or lengths. Start table must be a list with the following column types: Identifier, Date + time (from), Date+ time (to), Values.

Columns of input table

Parameter

Examples

Example 1: ...

...

Calculation method	Settings	Result
...

Troubleshooting

Problem	Frequent Cause	Solutions
...		...