-
1. Re: Multiple dimensions to a single filter option
Jennifer VonHagel Sep 18, 2017 1:33 PM (in response to Anjal S)Hi Anjal, I think we need to see how your data is structured.
But if it is as simple as something like this, then you can create a dimension swapper. The table just shows the structure of the data. And I have created a parameter and formula linked to it showing in the screenshot.
Now we can remove all the Report A, B, C, D dimensions, and just put the calculated Report Dimension here. When we select a report from the parameter, our table will give us that report's numbers:
If this doesn't help, send a sample of data .
Best,
Jennifer
-
2. Re: Multiple dimensions to a single filter option
Anjal S Sep 18, 2017 1:36 PM (in response to Jennifer VonHagel)Jennifer,
Thanks for your response. In my case I want to see Report A, B,C,D in the filter option. So, here when I select report A in filter I should be able to see data for A, and vice-versa
-
3. Re: Multiple dimensions to a single filter option
Jennifer VonHagel Sep 18, 2017 2:09 PM (in response to Anjal S)The second screenshot doesn't show what you want? Is it that you don't want the parameter?
Thanks,
Jennifer
-
4. Re: Multiple dimensions to a single filter option
Anjal S Sep 18, 2017 2:21 PM (in response to Jennifer VonHagel)Jennifer it's working but in the choose report field I cannot find A,B,C,D. I'm not getting any filter option. Could you attach the workbook please. Thanks
-
5. Re: Multiple dimensions to a single filter option
Jennifer VonHagel Sep 18, 2017 2:27 PM (in response to Anjal S)Oh of course. .twbx Attached.
For Choose Report, manually create a Parameter:
And type the List of values in:
-
Anjal.twbx 16.7 KB
-
-
6. Re: Multiple dimensions to a single filter option
Anjal S Sep 18, 2017 2:36 PM (in response to Jennifer VonHagel)Jennifer, Thank you. It's working .
-
7. Re: Multiple dimensions to a single filter option
Jennifer VonHagel Sep 18, 2017 2:46 PM (in response to Anjal S)Sure thing, happy to help.
-
8. Re: Multiple dimensions to a single filter option
Anjal S Sep 18, 2017 3:24 PM (in response to Jennifer VonHagel)Jennifer,
For the same set of these four category ranges, 0-30 and etc I have an other Dimension E. But I do not want that to be included in the filters above. I have negative values and positive values for this dimension. What would the best form of representation would be good with positive and negative values. Thanks
-
9. Re: Multiple dimensions to a single filter option
Jennifer VonHagel Sep 18, 2017 3:43 PM (in response to Anjal S)Hmm, I think some sort of bar chart would be good, there are a few options in the workbook I attached (I used Report D as an example and created some negative numbers). If you have questions on any of them let me know.
Best,
Jennifer
-
Anjal.twbx 36.2 KB
-
-
10. Re: Multiple dimensions to a single filter option
Anjal S Sep 18, 2017 3:48 PM (in response to Jennifer VonHagel)Could you upload a picture of it. Im using 10.1 version so I'm not able to open the workbook
-
11. Re: Multiple dimensions to a single filter option
Jennifer VonHagel Sep 18, 2017 4:20 PM (in response to Anjal S)Sure. I have three types, all pretty simple. I'll screenshot the whole view so you can which fields go where.
Vertical Bar, no special color, compares a second dimension (months in this case) within each Report value.
Horizontal Bars, Colored by volume, compares each Report value within a second dimension.
Stacked Horizontal Bar (not sure this is the best option for comparing 0-30, 31-60, etc. across multiple dimensions, but it's kind of nice to see the span of values all in one bar, and gives a quick sense of total negative vs positive values among the whole)
If you click on the legend, you can highlight a value to more easily see its trend:
If you need further detail, let me know.
Best,
Jennifer