Dashboard - Graph of Report Data Over Time?
I'm struggling to create something that seems simple at face value.
The sheet "Animals" is a ledger with the following columns:
Date, Animal Type, Breed, Count
2/4, Dog, Pomeranian, 2
2/5. Dog, Pomeranian, 3
Each day a new line is added via a form for each unique animal type and breed, and we count all animals every single day.
If I want to graph the rise and fall of the count of "Pomeranians" over time I'm creating a helper sheet with one column per line I want to show up on the sheet.
We then populate the first column of the helper sheet with every date and have it pull data from the "Animals" sheet via an SumIF formula.
Is there a better way to do this? I feel like this requires a ton of maintenance and leaves a ton of room for error. In excel I could simply create a pivot table or chart in seconds. How can I mimic that on Smartsheet?