Forum Discussion
Solved
Creating a pair of dynamic graphs for a dashboard presentation
I need to create a pair of donut graphs that detect what week the current day/date falls under. Simply put, we are tracking how many lots/work orders pass final inspection and how many get rejected....
Hi Lorenski
you can achieve this with a few simple formulas:
- identify previous week of todays date: =WEEKNUM()
- pick the values for previous week: =VLOOKUP()
- calcualte YTD values: =SUMIF()
In the attached file, you can find my example.
Hi Lorenski
you can achieve this with a few simple formulas:
- identify previous week of todays date: =WEEKNUM()
- pick the values for previous week: =VLOOKUP()
- calcualte YTD values: =SUMIF()
In the attached file, you can find my example.
Thank you DTE! Worked the first time!