If you turn your Team Number filter into a table calculation you can keep the Moat from being filtered out. Like this:
LOOKUP(ATTR( [Team Number] ),0)
Put that on the filter shelf instead of the Team Number filter. You're going to have labelling issues.
Do you mean for me to create a new calculated field with that formula, and
adding it to the filters?
I did that just now, and it didn't change the behavior. I changed it from
continuous to discrete, but I don't believe that would affect anything..
I will send a screenshot when I get the chance.
On Tue, Feb 23, 2016 at 8:38 AM, Shawn Wallwork <
Ah, I see. Now I am getting the same result. Is there any way to get
past the labeling issue? I will have about 50 teams on the graph, so it
will be a little difficult to interpret the graph with all the space in
between data points.
On Feb 23, 2016 11:06 AM, "Shawn Wallwork" <email@example.com>
Post a workbook with the 50 teams on the graph, so I can better understand what you mean by
... so it will be a little difficult to interpret the graph with all the space in between data points.
Here you go, I have attached a workbook with some data I generated randomly ( I will not have real data until the competition takes place)
You can see, if you filter to only one team, it looks something like this :
and you need to scroll a lot to see the other data points.
Is there any way to get around this issue?
tosend2.zip 336.6 KB