Hello Everyone ,
I need your help to achieve one task. Please refer below details for problems.
I want to apply filter on particular column and the same time I need not allow filter to other column.
I have attached .twbx file and also image which help to identify problems.
I have one filter which is Activity status and need to fixed this filter for month and Hours column and allow to filter data for event column based on activity status selection.
If Event value is not available then we need put 0 or NULL values against month.Month and Hour value should be fixed at any instances.
This would be the desired output when we selected expected Shutdown all other row should be there in the solution but event value is zero.
Any help would be appreciable.
Thanks
Saumil Shah
Hi Saumil,
I don't believe it is possible to achieve what you are looking for using filters in one data source. However, there is a workaround with parameters. Parameters are not multi-selectable, so that may be a trade-off you will be willing to accept.
Step 1: Create parameter [Select Activity Status]
Right click on the parameter and select 'Show Parameter Control'
Step 2: Create calculated field [# Events]
IF [Select Activity Status] = "All" THEN [Events]
ELSEIF [Select Activity Status] = [Activity Status] THEN [Events]
ELSE 0 END
Use this field in your view instead of the original [Events]
See attached workbook. Hope this helps.
Ossai