Since the below shown bar graph view has appended files from different sources, the no value bar gets shown. I cannot a do a common filter or create a common query for this because of the different sources. The metric selector has six different metrics and lets say few of the metrics have different sources and hence if I filter out no value for one metric, I will be filtering all the available data for another metric because as I said the the data is all appended. So, please suggest me how to hide or remove "No Value" values from the view. Thanks
It's not clear what you configuration is without posting an IOK file. But it looks like you can solve this by defining a named query that excludes those "No values" then choosing "Filtered data, intersected with [that query]" in the view "Subset" menu.
Let me know if you need any further help with this.
I received your file, thank you. It opens up without any such "Performance by site" view with "No value" bar visible. Please send me a file which opens with the problem clearly visible.
However I think my solution still works. As I understand it, you have (for example) two views:
View 1 - measure M1, split by S1. Values in S1 are null for records 1,2,3, hence a "No value" bar for those 3 records.
View 2 - measure M2, split by S2. Values in S2 are null for records 3,4, hence a "No value" bar for those 2 records.
You say you can't use a named query presumably because (in this example) we can't exclude records 1,2,3 in one view and records 3,4 in another view.
You should define a named query per view. The first one would be called "Exclude no values in S1", and would have a filter rule "S1 <> null". The second would be the equivalent for S2.
In view 1, choose "Subset > Filtered data, intersected with > Exclude no values in S1", etc.