I am trying to create a graph with two lines, with two filters from the same dimension.
I have a dimension that has 20+ values. I'd like one line to show data based on just one of the selected values and the other line to show a line excluding that same value.
I've tried the following: -Creating a duplicate/copy dimension and filtering the original one with the first, and the copy with the 2nd. When I do this, the graphic disappears. -Creating a calculated field that tries to split the measures up. This isn't letting me track the count.
I want this on the same axis; the best I've been able to do is create two sheets, one with the first filter and one with the 2nd, and stack them in a dashboard.
My end-user wants the lines in the same visual, otherwise, I'd be happy with the dashboard approach. Right now, though, I'd also like to know how to do this.