1 of 1 people found this helpful
Lot of detail in your viz
but I made a couple of changes
first to the individual business age where the today() is a function that pulls in the date
bring the Avg to the sheet aggregating with AVG
the viz returns
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thank you so much! Exactly what we needed. I appreciate your note on the amount of detail. I removed different colors to the bar chart and will look for additional ways to create more focus around key issues.
Also going to add a slider to use as a filter for average age of business.
This dashboard is the 1st proof of concept for an initiative my team is leading where we will be providing BI dashboards to LA's 15 Council Districts to help local elected officials make better informed decisions and have more information at their fingertips.
Thanks a lot for your help and sharing your skills!
Thanks - glad to help out