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! 🙂
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! 🙂