I am using a slider to select a predefined set of customers and was able to do this via set analysis aggregation method. However I would also like to select this list of this customers for analysis.
I've attempted to use Only() in Listbox, however it doesn't seem to work. Is there any other way I can change the current selection based on my slider?
Note: My slider value is not linked to any variable but rather it's a criteria of
If value is 1 then search past 1 month for XXX criteria (Count the number of customers)
else if 2 then search past 2 months for XXX criteria (Count the number of customers)
Would it be Ok if I just rephrase my question and show an example data structure?
Data Structure
Person|Subject|Marks|Year
A,Math,0,2015
A,Math,0,2014
A,Science,50,2015
A,Science,80,2014
A,Com Science,75,2015
A,Com Science,50,2014
B,Math,50,2015
B,Math,0,2014
B,Science,0,2015
B,Science,50,2014
Assuming I want to allow users to have the flexibility of choosing
1. Selecting the list of persons where subject "XXX" is less than 50 for "X" years
2. Selecting the list of persons where subject "XXX" is less than 50
In both 1 & 2, I would need the charts to change according to user's input of subject and years.Thus, is there any way I can submit a SQL query like method into the current selection box?
