question

Carmen F avatar image
0 Likes"
Carmen F asked Carmen F commented

Export dashboard to html shows no global table data

When I export dashboards to html the result doesn't show global tables. Any idea on how to fix it?

exportdashboard-table.jpg

Thank you.

FlexSim 24.0.2
dashboard html
· 1
5 |100000

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

Jason Lightfoot avatar image Jason Lightfoot ♦♦ commented ·

Hi @Carmen F,

It's hard to know how to help without looking at your model. To receive a more accurate solution, please post your model or a sample model that demonstrates your question.

If your model contains sensitive information, you could first toggle your post as private using the "make private" option under your question's "gear" menu. Private questions are visible only to site moderators. You can also contact your local FlexSim distributor for phone or email help.

0 Likes 0 ·

1 Answer

Logan Gold avatar image
0 Likes"
Logan Gold answered Carmen F commented

Hi @Carmen F, I was able to replicate the issue, and it does look like this may be a bug.

When saving as HTML, I know a lot of the Model Input widgets in the Dashboards may not come through exactly as they look in FlexSim, but I would think we could get something to show up for the Table widget. I will let the developers know.

I also have a workaround that can get table data to show up when saving a Dashboard as HTML, by using a Table Chart (under the Base Chart Types). Table Charts will only show data from a Statistics Collector or a Calculated Table, so in the attached model (Dashboard_SaveAsHTML_TableData_24.0.fsm), I have set up CalculatedTable1 to pull all data from GlobalTable1. The Table Chart in the Dashboard is linked to CalculatedTable1, and when the Dashboard is saved as HTML, the table data shows up in the HTML page.

One downside to this workaround is you need to "Include" all the columns in the Table Chart properties, which means selecting every column one at a time. It's not too bad with small tables, but it could be a fair amount of effort and time with very large tables. It's probably possible to automate this process, but I would have to look into it more if that is needed.

Another downside is the Row headers don't come through by default. I think we could get them to show up in their own column by tweaking the Query in the calculated table, but I would need to look into this as well if it is needed.

Otherwise, you should see the simple Query I used when you open CalculatedTable1. To get it to work, I did "Enable direct editing" in the Calculations tab, which is a button that normally shows up underneath the Query field. You won't see it in this model since I have already pushed it, but you can see it if you create a new calculated table. I also changed the Update Mode to Always just in case the data in GlobalTable1 were to ever dynamically change.


· 1
5 |100000

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

Carmen F avatar image Carmen F commented ·

Thank you very much for your time and your detailed answer. This is a very good option to display the information I need.

In any case, I think it would be a positive improvement to be able to export tables to html directly.

Regards.

Carmen.

0 Likes 0 ·