Hello and afternoon to everyone!
My project involves contract information. The goal is to show the count of contracts for an organization. That's pretty simple = COUNTD([Contract Award Number]), which displays a number such as 157. I am then bring this sheet to my dashboard and display the number as a metric.
Ok so this is the part that I am stumped at: To count you have to use a measure such as COUNTD.
What I want is for my users to be able to click on the metric of 157 and "travel" to another page to see the row level details of the contract such as the start and end date, amounts, contracting officer, etc.
Anyone have some good ideas on how to achieve this modality?
Thank you,
Scott
Going to a different page (dashboard) is the basic function of a filter action. You specify a source sheet (where your user clicks on 157, for example) and one or more dimensions that are on the sheet (such as organization), and a target sheet that can be on any dashboard. The action goes to the target sheet, loads the value associated with the mark from which your user clicked (such as the organization that had 157 contracts) into the source sheet, and displays that sheet as if the user had selected the organization as a filter on the sheet. (Thus it's called a filter action.) The target sheet will show whatever you've designed to be shown about that organization.
You mentioned that the user would see "the contract". the value 157 isn't associated with a contract. It's a countd of the contracts for an organization. You moght want to explain what you are expecting to happen when the user clicks on 157. Which one of the 157 contracts do you want the user to see?
