Will it be possible to not filter straight table data on certain dimension
I've requirement where a straight table data should not be filtered based on certain dimensions in the table, but filtered when certain other dimension from the straight table or dimensions from different charts on dashboard are selected.
Headers from Straight Table chart are as seen in screen shot below.
User has requested that all records in a straight table should be displayed even if any "Field Name" or "API Name" value is selected, it should filter only if a selection is made in "Section" Column or any selection done in the charts available on the dashboard (Charts can be seen in ).
One another challenge that I'm facing is that several charts are made visible when a particular API Name is selected in conjunction with Data Type Column. So now if selection is restricted for "API Name" column then I'm not sure how I can make those chart visible for the user.
The chart in Image 2 is made visible in the same area as the bar chart seen in Image1 above.
IF we are able to successfully achieve the filter behavior for straight table and chart visibility for an "API Name" of Picklist Data Type then the user will want the straight table to filter if some of the Picklist values of an API are selected.
Please not there are no list boxes on dashboard for value selection.
Let me know if you need any more clarification or information. Any help/guidance will be greatly appreciable.
Re: Will it be possible to not filter straight table data on certain dimension
You can achieve the filter behavior you are looking for with set analysis. Instead of using a $ as your modifier in the set you can use a 1. This will ignore all filters, now for the fields you with for the table to filter you on you'll include the following in the set. FieldName = $::FieldName. If you'd like to use the $ as the modifier you can also exclude the filters by doing FieldName = in the set.
Edit. After re-reading to show/hide the columns you could use a conditional on the dimension/expressions to show calculate if the condition is met.