Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a single chart, if possible, that will include the % of the population that has a number of characteristics. This could easily be achieved using set analysis in each expression, however, I would like each bar to be selectable so the user can filter the population based on the criteria for that bar. In order to do so, I was using a variable calculated dimension (EX:if(aggr(sum({<CurrentFlag={1}>} Dollars),Patient_ID)=0,'Zero Spend')) and then a standard expression (EX: sum(Patient_Counter)/sum(Total Patient_Counter)).
I have 20 of these different calculations, that I plan to show and hide using buttons, but I would like these to be on the same chart so I have a consistent axis and scale from dimension to dimension. I can't think of a way to accomplish this; I tried a container which makes them appear to be one graph, however, the axes don't align and scales would have to be hard coded. Any suggestions?
I'd like it to look like this:
could you please post some sample data or a qvw?
Attached sample file to original post
Please see the attached
That seems like a more complex way of just using no dimension and just using a different expression for each metric. Because the bars are not selectable. I want the user to be able to highlight the particular metric and select the patients that meet the criteria. My original charts accomplish that, but in your example they are not selectable.
Please look at the attached.
Thanks
You can do it from script with Field event trigger
Please find the attached
My actual data model is much more complex than this and will have calculations that span multiple tables, so I don't think this option is doable.
Attrib1 may be a calculation from tables 1 and 2
Attrib2 may be from a 3rd table
Attrib4 may be a calculation from tables 2 and 4
So I don't think that works, right?
I want to be able to view all dimensions at the same.
You have mentioned that you want to show and hide the Dim using Buttons right?