Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My user has a graph were they can input how the data is selected ignoring current selections.
I need to perform a set analysis where for on of the fields they can select two values if they want to.
I have an input box that returns their selection. selection choice for input1: a,b or c
They will sometimes want to filter their results by a and b. so I have put in the option of selecting 'a','b','c' and 'a+b'.
i am not sure how to approach this my current implementation only allows them to select one selection per field. It is only input 1 where I would like to give the option to input two selections.
avg({1< IField1 = {'$(vInput1)'} ,IField2 ={'$(vInput2)'},IField3 ={'$(Input3)'}>}DISTINCT $(vSalesData))
Any suggestions are very much appreciated
Thanks
If your variable contains 'a','b','c' then you shouldn't enclose your variable expansion in single quotes:
IField1 = {$(vInput1)}
'a+b' is unusable, so you should change that option to 'a','b'.
If what you're asking is how you create a list of options for your input box then on the Constraints tab choose Predefined Values in Drop-down, check the option Listed values and enter 'a','b','c';'a','b' (a semicolon separated list of values).
Thanks for your reply
What I'm looking for is to have a set that includes a. and a set that includes a and b depending on which one the user selects.
if(vInput = 'a + b', avg({1< IField1 = {'a','b'} ,IField2 ={'$(vInput2)'},IField3 ={'$(Input3)'}>}DISTINCT $(vSalesData)),
avg({1< IField1 = {'$(vInput1)'} ,IField2 ={'$(vInput2)'},IField3 ={'$(Input3)'}>}DISTINCT $(vSalesData))
I've been playing around with an expression like the one above but I cant seem to get it to work.