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 Best Answer

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 ·
Martin K5 avatar image Martin K5 Jason Lightfoot ♦♦ commented ·
Hi,


would it be possible to attach the corresponding model?

Thank you,

Martin

0 Likes 0 ·
Felix Möhlmann avatar image Felix Möhlmann Martin K5 commented ·

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.

1691062499363.png

1691062550577.png

1 Like 1 ·
1691062499363.png (1.3 KiB)
1691062550577.png (1.3 KiB)
Show more comments
Martin K5 avatar image Martin K5 Jason Lightfoot ♦♦ commented ·

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?

1691396816320.png

Thank you,

Martin

0 Likes 0 ·
1691396816320.png (15.9 KiB)
Jeanette F avatar image Jeanette F ♦♦ Martin K5 commented ·
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.
1 Like 1 ·