We monitor cattle movements and need to create visual charts to show if how many cattle were moved on a certain date; how many moved on that date were reported late; the percentage of late reported moves; the market or abattoir they moved through.
I have csv data with the following columns:
- cph
- Mart or Abattoir
- Move Date
- Total for move date
- Qty of MOVES over 3 days late
- Qty DEATHS over 7 days late
- UID
- Move Type
- Business
and I have the main board where I import the csv’s to. I then setup automations to create items on two other boards - “Marts” and “Abattoirs”.
Within “Marts” and “Abattoirs” there are automations to move the items to the relative group depending on what the mart or abattoir Business name is.
I’ve added two formula columns in to each board - one for “% of late moves” and the other for “% of late deaths”.
Can anybody advise what other metrics I could show from the data we have, and how I would go about displaying that on a dashboard please?
New to monday.com!!
Thanks
Shona