I would create a different sheet for each value of the parameter and then either use a dashboard action to change the one being viewed.
This heatmap is used in about 5 different dashboards. I’m afraid if I created a separate sheet for each, that would be creating 15+ sheets to all of these dashboards. There isn’t a simple calc to just select yearly or quarterly measure that is in the view, and keep the same ranking?
Since I can get the same result by just hitting the “+” or “-“ buttons, I’d imagine I can create a parameter without a separate sheet?
Manager, Business Process Outsourcing
150 N. Field Dr., Suite 200, Lake Forest, IL 60045
Phone: 847-969-7907 | Cell: 608-334-4569
image001.jpg 1.0 KB