on 03-06-2013 10:48 AM
Hi Friends,
I am Trying to do a self project
Wherein i am selecting states from push buttons ie 1 state 1 push button in that way i have 6 push buttons i.e. 6 states
and i have divided the canvas into 4 quadrants.
each containing column chart .
so when i click on button 1 the respective graph shud oen in quadrant 1
then 2 on 2nd quadrant
3 on third quadrant
button 4 on 4th quadrant. This is simple to do .
But what i am trying to accomplish is what ever order i click the buttons in that order the graphs should open
ie If i select button 3 first the concerned graph will open in the 1st quadrant
then if i select button 1 it should open in the second quadrant and so on
ie depending upon the click of buttons they should open in the quadrants available.
I tried out using the formula sam as below one
if(and(a1=0,1,if(b1=0,0)))
but its not working i am trying to tweak it
thanks and regards
Gaurav Tilara
Hi,
I need a clarification. What will happen if you click 5 push buttons?
First Selection -> Quad 1
Second -> Quad 2
Third ->Quad 3
Four ->Quad 4
Fifth ->Quad 1 ??
Not too sure what the practical functionality is. I would suggest using a List Builder insread which will allow the user to make up to 4 selections (in whichever order he preferes) and display Selection 1 in Quad 1, Selection 2 in Quad 2 and so on.
The list builder will grab the data and put it in an area defined by you. Lets say each State has 1 row of data. The list builder will put 4 rows in an area defined by you. The graph in Quad 1 will use first row as source, the one in Quad 2 the second row and so on.
This solution does what you want to achieve and it's less complicated than using Push Buttons.
I hope this will solve your problem.
Regards,
Matt
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Matt,
Thanks for the reply i did some demo in list builder but later realized that it is not mobility compatible .
As i am totally working on dashboards for mobile so have to find out work arounds so m doing R&d with these components .
If u have any other alternative can u please suggest me i will try it out .
and how do i keep in touch with u via emails
where do i mail u my ID
and yes i am also a lil confused what will i do if i click button 5
i am thinking of clearing every thing by a clear button for new selections once all quads are filled.
Thanks & Regards
Gaurav Tilara
Hi,
I guess that the practical functionality for the idea you have would be to be able to compare graphs.
Therefore I would personally plot all the data on a Line Chart for example and each State will have a different line of a different color.
Alternatively, I think that the easiest way which would also look good visually would be to have a Combo Box in each Quadrant. This way you don't need any Reset button as the user will be able to change his selection.
Sometimes the easiest solutions are better than complicating your dashboard.
I'm trying to be an Active Contributor on the Communuity Network so I am happy to answer any of your questions (or at least provide helpful answers) if you post them in the discussion area.
Regards,
Matt
Hi Gaurav,
As Matt said, the best solution is probably to have a separate ComboBox in each Quadrant.
If you're determined to use your push buttons, here is one potential (but a bit more complicated) solution which will perform exactly as you wanted in your original post.
1. Use 24 Push Buttons (4 groups of 6).
2. Each group of 6 will add the data to their quadrant. So if you push a button in the first group, it will add a graph to Quadrant 1. second group = Quadrant 2, etc until fourth group = Quadrant 4.
3. Add a cell, for example $A$1, which has the last pushed button. So $A$1 is blank at the beginning, then when you press a button in the first group, you get $A$1=1. If you press a button in the second group, you get $A$1=2, etc.
4. Set the dynamic visibility of your groups so that the 2nd group is only visible when $A$1=1, the 3rd group is only visible when $A$1=2, the 4th group is only visible when $A$1=3 and the 1st group is only visible when $A$1=blank or $A$1=4.
5. Put the 4 groups of buttons on top of one another so that the user doesn't notice that you have 24 buttons; he will only see 6 buttons at a time.
This sounds complicated, but after taking the little bit of time to set it up, having 24 push buttons won't affect the performance of the dashboard in any noticeable way and the whole process will be invisible to the user.
Hi Matt & Alex,
Thanks for the answers, and tips,
One thing that i learned from this discussion is SIMPLE is effecient i tried ur answer alex but got stuck in showing group 1 back which is having 5 buttons and group 2 also 5 buttons i can hide and populate the graph when i hit any of the buttons in group 1 but when i click on group 2 buttons they just populate the second graph and donot pass the control back to group 1.
here is the formula
O2==IF('Push Buttons'!A2="",1,IF('Push Buttons'!A3="",1,IF('Push Buttons'!A4="",1,IF('Push Buttons'!A5="",1,IF('Push Buttons'!A6="",1)))))
Thanks & Regards
Gaurav Tilara
Hi Colleagues
why not instead of push buttons you use a list builder component
on the left side the list of charts and on the right side the list to be showed (in the right order to be showed)
so the target result on a cell range can be used for dynamic visibility of each chart in the respective cuadrant.
All the reports must be in each cuadrant.
from resulting list, the 1st position correspond to 1st cuadrant,2nd position to 2nd cuadrant and so on.
Hope this helps
Best Regards
Erick
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.