06-01-2018 04:31 AM
Hello everybody !
One of my clients demand me to create a report on SAS Visual Analytics and what they want is to filter a personalized graph with double axis and double measure for bars and lines with two filters, that is to say, a graph with this appearance :
One filter should affect only the green bar and the red line and the other should affect the blue bar and the yellow line independently so that if you only use one filter the other part of the filter should be constant.
I had investigated a lot and I tryed to modify the table to achieve it but I haven't found a solution. If someone can help me I would be very grateful.
Thank you very much !
06-01-2018 09:35 AM
I cound not view the picture but I think I understand
Also I don't know which version you are using, I assume 7.4 or 8.2
You can create calculated meassures that depends on parameter values.
For the filters you use these parameters instead of ordinary interactions.
Lets say you have a filter called department and want to filter that specific graph.
Use a drop down and assign department as category. Also assign a parameter, lets say dep_param.
Pu the drop down on the report area, not the report prompt ares nor the section prompt area.
Create your calculated measure using the parameter:
IF department = dep_param then [value]
Then use this measure in your graph.
Go on with the other measures in the same way
06-04-2018 04:28 AM
First of all, thank you so much for your answer and sorry about the picture.
I have tried to filter with this parameters that you mencioned but still not working. Suppose we have a starter filter 'country' for the first filter 'HumanID' and on the other hand we have 'Department'. I need the graphic to be filtered by 'HumanID' and 'Department' thus if we have no filter in 'Department', the part of the graphic refering to that should be constant and using the params that you explained me, it is not.
Maybe I am doing something wrong but I am start thinking that what I want it is not possible . Hope you can help me
Thank you in advance.
06-04-2018 06:06 AM
I will try to explain it better, I need one bar-line to be fix if I only use the filter 'HumanID' that I mentioned and, on the other hand, if I use the filter 'Department' the other combo bar-line should be now fix.
06-04-2018 07:21 AM
I think it should be possible.
What if you check if the parameter has a value or not?
If it has a value then return only rows with that value in your calculated measure and if it has no value return all rows.
06-06-2018 10:59 AM
Hi again Fredrik !
I was trying to solve my problem but I always bump into the graphic object. I'm seeing that if I apply a filter, it applies to the object not to the table, either the filter or the param. So I can't filter the table and that stop the desired solution. I'll try to convince the client to create to independent graphics for the comparison.
Thank you so much for your interest and your help!