topic Re: How to Create a Dashboard Heat Map in FlexSim Forum

How to Create a Dashboard Heat Map

stan_e_davis — Tue, 13 Sep 2022 16:32:52 GMT

[ FlexSim 22.2.1 ]

I would like to implement a Heat Map data visualization (not A*'s heat map) in a Dashboard but see there is no Heat Map in the library. Is there a way of modifying background cell colors of the Table Chart or similar object in an attempt to replicate a heat map? Something like this...

Thanks - Stan

Re: How to Create a Dashboard Heat Map

Jeanette_Fullmer — Tue, 13 Sep 2022 20:59:08 GMT

Hello @Stan Davis,

You can export your data to Excel and easily add a heat map like this. I do not believe that the cells in a table chart or global are able to add color to them.

Re: How to Create a Dashboard Heat Map

stan_e_davis — Tue, 13 Sep 2022 21:18:03 GMT

Yes (the pic is from Excel), but I need to see the data in real 'sim' time and not as a post analysis. I mentioned Table Chart, but I am looking for any ideas on how to emulate a Heat Map with the existing toolset. I am going to request a Dashboard Heat Map be added to FlexSim's features/capabilities. - Stan

Re: How to Create a Dashboard Heat Map

jason_lightfoot_adsk — Wed, 14 Sep 2022 22:14:37 GMT

In the meantime Stan, I'm attaching a model with two CustomGUIs that you can point to global tables using the sampler and change the color using the "HeatPallet" color pallet. The global variable maxHeat sets the top threshold.

To open this just right click the "HeatTable" objects in the Toolbox section marked "Graphical User Interfaces" and select "Show GUI". To switch the table use the sampler to select from the list of tables in the toolbox.

The two examples use a different technique to set the background color.

TableCellColor.fsm.pdf

Update: it seems the attributes needed are documented here.

Re: How to Create a Dashboard Heat Map

stan_e_davis — Thu, 15 Sep 2022 13:21:30 GMT

Excellent!! That works for me. Really appreciate the support Jason. Thanks - Stan

Re: How to Create a Dashboard Heat Map

martin_k5 — Thu, 03 Aug 2023 11:03:46 GMT

Hi,

would it be possible to attach the corresponding model?

Thank you,

Martin

Re: How to Create a Dashboard Heat Map

moehlmann_fe — Thu, 03 Aug 2023 11:36:43 GMT

The model is attached. At the time the forum had a problem where it wouldn't allow .fsm attachments. A workaround was to change the file ending. Just rename the file back to fsm.

Re: How to Create a Dashboard Heat Map

martin_k5 — Mon, 07 Aug 2023 07:35:52 GMT

Thank you, that works well.

Re: How to Create a Dashboard Heat Map

martin_k5 — Mon, 07 Aug 2023 08:27:36 GMT

Hi,

I would have a question regarding your post. I really like this possibility, but I would like to ask if there is a documentation regarding the style attributes as shown below?

Thank you,

Martin

Re: How to Create a Dashboard Heat Map

Jeanette_Fullmer — Mon, 07 Aug 2023 19:52:36 GMT

Hello @Martin K5, Since this question already has an answer please start a new post for your question. You can reference this post in your new post.