I have 3 fields viz. field1, field2 and field3. I am using field1 as dimesion and count(field2) as measure for a bar graph. The field3 is being used as a filter, but I dont want selections in field3 to affect the bar graph.
is there any way to tackle this?
Field 3 is in an associated table, and thus this is returning only the values associated with that table and not showing all the values. It would be valid if they were in the same table. Sorry for not mentioning this detail, i thought it wouldn't be important. basically if the field 2 is in table A and field 3 is in table B, both the tables are associated but table B has only 20 rows, field 2 is gonna show use only the rows associated with those 20 rows. In the above formula, it seems that for all selections in field3 we are leaving field2 as it is, but it seems i have to find a way so that nothing about field3 affects field2 while still keeping the tables associated. is there any way to do that?