Variable filter from the same Object (WAD)
I am new to WAD and currently have a requirement where I have 2 different variables, contained within a single object in a query. Both these variables are in use as one of them is a mandatory (single value) field and the other not (single and multiple values). Actually I am trying to show a comparision between these two inputs (in percentage) in a chart.
The query is designed in such a way that In the selection screen when I do not give any input in the non-mandatory field, it results an average of the available data, and when I select an input then it gives out the result of this particular input (either single or an average for multiple selection).
So I wanted to implement a filter pane in the WAD, so that I can have a multiple selection. How can I differentiate the variable input as I need the filter on the non-mandatory variable. Can anyone suggest me on this.
Thanks in advance