Google Sheet Graphs

I have a ready made table on google sheets.

Its a live table of callers with columns for date, keywords, call handler, outcome and spend, day of the week. This table I sometimes add filters to try and more clearly interpret the data. I would like the graph to adjust when filters are on.

Create a dashboard/sheet of graphs

Tabel 1:
take daily raw data and collate it for that month, eg. number of callers in the month. I need a colum so I can add in the money spent for that month and calc cost per enq, cost per booking, ROAS.

Graph 1
12 pie graphs for each month Jan-Dec showing outcome in percentage as a doghnut graph

Graph 2
A single graph showing which day of the week is most popular for callers of all time

Graph 3
Stacked bar chart showing each of the 12 month on x-axis and performance on y-axis
bar should show number of calls stacks are % booked, %not answered, %missed, total calls,

Graph 4
Line graph of ROAS (return on Ad Spend)


The charts and monthly totals will need to update if I add filters to my raw data. eg. sometimes I am looking at just one call handler and their annual performance. etc...