How To Filter Data On Dashboard While using Time Plot?

Question

question

Ankur A3 asked Jun 27 2022 at 7:17 AM Ankur A3 commented Jun 27 2022 at 6:03 PM

How To Filter Data On Dashboard While using Time Plot?

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!

Software Version:

FlexSim 21.0.10

data split filter timeplot

Answer 1 · 2022-06-27T11:45:32Z

Felix Möhlmann answered Jun 27 2022 at 11:45 AM Ankur A3 commented Jun 27 2022 at 6:03 PM

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.

1656330321803.png (28.7 KiB)

· 5

Ankur A3 commented · Jun 27 2022 at 12:30 PM

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!

0 ·

Felix Möhlmann Ankur A3 commented · Jun 27 2022 at 12:35 PM

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.

0 ·

Ankur A3 Felix Möhlmann commented · Jun 27 2022 at 1:28 PM

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!

0 ·

Show more comments

question