I lease space on a monthly contract, and I have a space list with a status indicating whether it’s sold or available currently. I’d like a way to be able to see how many booths are occupied / available over time. For example, I don’t have a way of seeing how many booths were empty/full this time last year, or last month. I’d like to be able to check specifics, as well as plot a line graph over time showing the occupancy %. I also have more than 25 other space lists for separate locations that I’d like to be able to do the same thing for, and graph all of them over each other.
I know this is a bit vague and I haven’t found the exact right question to ask yet, I’m just looking for general recommendations. Thanks in advance for any and all assistance with this!