Yes. Post some sample data.
Sure. Here's a workbook with two tabs. The first tab takes a parameter (Body = X), with default X = Earth, and displays stats about earth.
The second tab is a copy of the first tab. If you can make the second tab use the parameter "Earth" to filter the display to show all objects of the same type as Earth ("planets"), that's all I'm asking.
A pic too:
EricSample.twbx.zip 17.7 KB
Eric see attached. The formula is:
IF [Object Type]="Planet" THEN [Object Type] END
ELSE [Object Type]
BTW, having a field named "Body" and a parameter named "body" is not the best naming convention as it can be confusing to others.
EricSample-SW.twbx.zip 39.1 KB
I realized that my example is actually too simple. The real problem I have is this:
I have a big database of appointments. I'm tracking which sales agent scheduled each appointment, and that sales agent has a location associated with him/her.
I have a report which accepts the sales agent's ID as a parameter and displays statistics about their scheduling activity and performance. I want my dash to also show a leaderboard including data on every sales agent at the same location.
By your example, I would have to create a hard-coded filter with a formula for each sales agent (hundreds). Is there a way to do this in such a way that it is not hard-coded like that?
In other words, what I'm trying to accomplish would be equivalent to:
1. look up the corresponding object type of the parameter "body"
2. apply a filter for the resulting object type
The problem is I don't know how to look up the corresponding object type of a parameter since the parameter is just a text input.
So if the parameter is a planet name, that planet name presumably matches up with one of my records, and that record presumably has an object type. But I'm not sure how to do that.