cancel
Showing results for 
Search instead for 
Did you mean: 

Opening Graphs in Different quadrants

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi Alex,

How will A1 know when a button in a specific group was pushed? Or in other words who will push the data to A1?

Regards,

Matt

Former Member
0 Kudos

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

Former Member
0 Kudos

The push button can take care of pushing the data into A1.  Of course you'd need to cleverly arrange the spreadsheet so that the push button can push data into both $A$1 and into the cells for the quadrant's graph at the same time.

Former Member
0 Kudos

I'm not sure what O2 or A2:A6 are in your equations...

0 Kudos

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

Former Member
0 Kudos

We have already considered that option, however he needed to render the dashboard on a mobile device where the list builder won't be supported. Other suggestions included combo boxes.

Regards,

Matt