How to plot all columns vs. time?

Question

question

Mischa Spelt asked Jun 25, '20 Jordan Johnson edited Jun 26, '20

How to plot all columns vs. time?

Hi,

I've created a statistics collector that listens to a single event and collects a few different numbers.

I wanted to create a simple plot that shows all these values as different series in the same plot, as in the below (Excel scatter) plot, but I could not figure out how to do it easily in FlexSim.

I ended up writing a calculated table with a UNION to manually pivot the table, but that was not my preferred solution :-)

SELECT Time, "Items" AS Type, Items AS [Count] FROM [Throughput]
UNION
SELECT Time, "Size units" AS Type, Size FROM [Throughput]

Surely there's a nice solution for this? :-)

Software Version:

FlexSim 20.1.3

flexsim 20.1.3 charts content vs time chart

1593095901859.png (34.6 KiB)

1593095958780.png (25.7 KiB)

· 1

tannerp commented · Jun 26, 2020 at 06:00 PM

I think that your calculated table solution is actually the only way to do this as of now. The chart you're using currently only supports one column for Y-values based on my testing. @Jordan Johnson can correct me if I'm off.

0 ·

Answer 1 · 2020-06-26T23:03:51Z

Jordan Johnson answered Jun 26, '20 Jordan Johnson edited Jun 26, '20

The easiest way is to change your stats collector. I would listen to the same event multiple times, once for each stat.

Once you've made that table, you should be able to chart it with no problem. This is also easier (and much, much better for performance) than writing a query.

Here's an example model, that uses a timer event; but the principles are the same:

MutliStatExample.fsm

You could also do it with a single event, and create an array of row values (to create multiple rows per event), and also write some if/else code in your column value to write a different value depending on the row value. But this way is a little more straightforward.

mutlistatexample.fsm (30.6 KiB)

question