Hello,
I have built a dashboard with several cards on it. I want to apply a filter to it, call it Filter A. When I add Filter A as a filter to the dashboard and choose "select all" (so that nothing should be removed from the dataset), the values in my charts for # of Widget A and Widget B decrease. If I remove this filter, and then go into each of the cards and add the same filter and choose "select all," the number of Widgets is correct. Does anyone know why this difference might be occurring?
I have a hypothesis: I noticed that there are 130 options in Filter A at the dashboard level, but 140 at my card level. When you are doing page/dashboard level filters, are the only options that appear options that are present in every single dataset on the page? See the example below:
Dataset 1 that flows into card 1: Filter A has values of A, B, C, and D
Dataset 2 that flows into card 2: Filter A has values of A, B, and D
Would the only options that appear that could be selected at the page/dashboard level filter be A, B, and D?
Thanks so much!
Sean