topic Re: How To Filter Data On Dashboard While using Time Plot? in FlexSim Forum

How To Filter Data On Dashboard While using Time Plot?

rajankur6494 — Mon, 27 Jun 2022 07:17:05 GMT

[ FlexSim 21.0.10 ]

Hi Team,

I am creating time plot on dashboard where x-axis contains time(date time format) and y-axis contains content value for 30 days. I am using y-axis split based on day. So there are 30 different horizontal sections in chart. At the end, values are not readable due to space constraint.

How can I apply filter on particular day to check the values in chart?

Thank you!

Re: How To Filter Data On Dashboard While using Time Plot?

moehlmann_fe — Mon, 27 Jun 2022 11:45:32 GMT

The 'Time Window' option allows you to scale the x-axis of a time plot, so the chart shows only a part of the data. You can set the window size in the properties or drag the edges of the scroll bar to change the size of the visible timeframe.

Re: How To Filter Data On Dashboard While using Time Plot?

rajankur6494 — Mon, 27 Jun 2022 12:30:19 GMT

Hi @Felix Möhlmann,

Thank you for your answer!

But I am looking for Y-axis. Also, the option given for x-axis will only show recent data. It will not give option to filter the data if required. How can I show data for any particular day on Y-axis out of 30 days.

Thank you!

Re: How To Filter Data On Dashboard While using Time Plot?

moehlmann_fe — Mon, 27 Jun 2022 12:35:49 GMT

The implied solution was to not use y-split and scroll to the day you want to see on the x-axis.

You could also just increase the vertical size of the chart until all diagrams fit in it.

A dashboard chart will always plot all data it is given. If you only want to plot the data for one day, you have to filter the data beforehand. Calculated tables are a good tool for this. Use the statistics collector as the source table and add a subset that filters by the day.

Re: How To Filter Data On Dashboard While using Time Plot?

rajankur6494 — Mon, 27 Jun 2022 13:28:16 GMT

Hi @Felix Möhlmann,

I agree with your point.

For y-axis, data is added in same window making y-axis data non-readable.

Is there any way to keep y-axis section height fix and scrolling the data for more days?

Thank you!

Re: How To Filter Data On Dashboard While using Time Plot?

moehlmann_fe — Mon, 27 Jun 2022 13:55:12 GMT

Like I said, you can increase the vertical size of the chart until the individual diagrams are readable again. A quick way to do this is to move the chart to the bottom of the window (so most of it is off the screen), then extend the size up to the top. Repeat as often as necessary.

Again, you could also use a Calculated Table to show only data for one subset in a different chart.

CalculatedTableSubset.fsm

Re: How To Filter Data On Dashboard While using Time Plot?

rajankur6494 — Mon, 27 Jun 2022 18:03:05 GMT

Thank you so much! @Felix Möhlmann