Forum Discussion
How to Display Stock
Hello EduardoLIma,
If your data is structured in the following way:
Date Stamp Tank Juice Qty Parameter 1 Parameter 2 Parameter 3 Parameter 4 29/08/2023 1 Juice 1 374 3,0 2,0 1,0 2,0 29/08/2023 2 Juice 3 641 3,0 3,0 1,0 2,0 29/08/2023 3 Juice 2 296 2,0 1,0 2,0 3,0 I would suggest the following proposals:
Stacked Bar Chart - it will give a possibility to see at glance many tanks, however I suggest to add "Zoom slider" as you probably won't be able to visualize all values.
Matrix - you won't be able to see all tanks, but total row can help to have an idea of total stock, numbers are readable and conditional formatting is showing whether tank is full or not.
Table with sparkline - in case you need to show change of tank's filled capacity over time for all 120 tanks.For additional information on parameters I suggest to use a built-in tooltip for a bar chart and manually created one for matrix/table (video on tooltip).
I hope it will inspire you for creating a great report! 🙂
In production, how is this currently visualized on a status board or process control system,
and what would provide the most information in the first 1-3 seconds.
Suggest making this similar visually to what is in use now. You can get very creative with
this without breaking the bank on effort or maintenance. Basically, you are working around
tables of events in progress that would drive what is at the visual layer.
What other systems produce visuals and information that folks are familiar with?