question

Stan Davis avatar image
0 Likes"
Stan Davis asked Jason Lightfoot edited

How to Create a Dashboard Heat Map

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...

1663086883224.png

Thanks - Stan

FlexSim 22.2.1
dashboardsheat map
1663086883224.png (2.7 KiB)
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Jeanette F avatar image
0 Likes"
Jeanette F answered Jason Lightfoot edited

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.

· 8
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Stan Davis avatar image Stan Davis commented ·

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

0 Likes 0 ·
Jason Lightfoot avatar image Jason Lightfoot ♦♦ Stan Davis commented ·

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.


1663193444130.png

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.

1663193590695.png

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

TableCellColor.fsm.pdf

Update: it seems the attributes needed are documented here.

4 Likes 4 ·
1663193444130.png (11.9 KiB)
Stan Davis avatar image Stan Davis Jason Lightfoot ♦♦ commented ·
Excellent!! That works for me. Really appreciate the support Jason. Thanks - Stan
1 Like 1 ·
Show more comments