I feel like I'm missing something - using only core applications, is there a way to create multiple charts in a dashboard for ongoing data (meaning every time a row is added I want the graph to be fluid to update accordingly from one report?)
My understanding is if I'm selecting from the source sheet, its stagnant data and won't update with new additions since I can only select the cells. I don't want to create a separate report for each metric within the sheet. Is there a work around?
For reference - my sheet is a sales request sheet. So, it contains, requestor, budget, status (win, loss, on hold), etc.. I'd like to graph on my dashboard the number of requests per user, the number of open requests, the percentage of wins and losses and number of assignments to each sourcing team member.
All of this data is on my source sheet so how can I simplify and graphs multiple fields within the dashboard?
Any help is appreciated! Again, we only have the core applications so no premium add-ons to work with.