Bar Chart of groups with an average value from the labels.

Question

question

GOMARCOO asked Jan 31, '24 GOMARCOO answered Jan 31, '24

Bar Chart of groups with an average value from the labels.

Is it possible, to get my data in groups and take the average value of it? I do have around 70 Groups of Transports which are repeating continuously. I want to figure out the average of each Transport. and not every transport in one bar chart. The data from the barchart are from a statistics collector who tracks the labels.

Software Version:

FlexSim 24.0.1

agv statistics collector

1706704510144.png (255.9 KiB)

1706704818094.png (380.6 KiB)

Answer 1 · 2024-01-31T13:04:01Z

Felix Möhlmann answered Jan 31, '24

Calculated Tables are used to aggregate table data using SQL.

In your case the settings would look like this:

This results in the query you see below. If you have knowledge of SQL you can also "enable direct editing" and type the query yourself.

A Calculated Table can be used as a data source for charts just like a Statistics Collector.

1706706077183.png (19.3 KiB)

1706706090309.png (9.0 KiB)

1706706134175.png (13.6 KiB)

Answer 2 · 2024-01-31T14:46:29Z

GOMARCOO answered Jan 31, '24

Thanks for your Answer. It helped me a lot!

question