Report and Dashboard
In my sheet, I have a column calculating the NETDAYS between two events. This column does not show up if I try to create a Summary Report. It only allows me to create a Row Report. In a dashboard, how can I use a half-pie graph to show the number NETDAYS greater than 37 and NETDAYS less than or equal to 37. I do have conditional formatting in my sheet to show this, but I would like a half-pie graph on a dashboard showing these numbers. Thank you in advance.
Answers
-
What I would probably do in this scenario is create a roll up sheet where you could use a COUNTIFS formula to count the number of events that have netdays over 37 and the netdays equal or less than 37.
Once you have that, you could then create a row report with that roll up and slap it into a Dashboard as a pie chart.
-
@kioshi43 What is a roll up sheet?
-
A separate sheet where you can throw you can reference your original sheet in formulas. It helps out a bit in my work flow because I'll add in something like =Countif([reference source sheet], "Completed") to do a count of how many items in my source sheet have been done.
-
@kioshi43 Thank you. :)
