dynamic visibilty conundrum - help!

other Xcelsius - Crystal Dashboard Design
1

Would like suggestions on making the following scenario work properly. I am close, but not there.

Dashboard has primary menu used to drive data for the primary and secondary view.

Primary view consist of series of tables which categorize measures. When table item is clicked, primary view is completely hidden and supporting analytics are displayed. Menu is still available, so detail analytics can be viewed for different data pool. Detail view also includes a toggle which will close the view and return user to primary view. The toggle is only used to hide the detail charts, never to display.

The detail charts should only display when a line item is clicked. Since position is being used, when the user is returned to the primary view and makes a new menu selection, the detail is being shown using the previous position.

If I could ‘reset’ the position input cell that would solve my problem. Have tried grids, but the alternating on/off settings and the retention of the previous position have me very frustrated!

Thanks in advance!

linnie (BOB member since 2006-02-21)

2

hi there,
Did you get any solutions? I’m in a similar situation.
I am using toggle buttons in my model. I would like to set dynamic visibility for each toggle button’s set of components.
For this i need to reset the user selection after he selects from a list of toggle buttons (set up to mimic a lable based menu).

If he selects toggle button 1 -> he should see graph1
if he selects toggle button2 -> he should see graph 2
etc

I am capturing the status ‘ON’ ‘OFF’ values of the toggle buttons into different cells and adding them up for into an ‘addition’ cell. I would like to control dynamic visibility based on this ‘addition’ cell. If i can reset this addition cell everytime the insert into of the toggle button happens, i can get my model to work.
I can share my model if you need more clarity.
Thanks.

msharma (BOB member since 2006-11-08)

3

In these situations, I would have each toggle button feeding into their own cell. And then build dynamic visibility logic, for each graph type required, on the results of these cells using nested IF statements.

SonnyWinston :uk: (BOB member since 2005-04-07)

4

Agree that would probably work well for msharma.

That is not working well in my situation. I am using a table position to display and really a single function button…to ‘hide’. Still searching for the right combination.

linnie (BOB member since 2006-02-21)

5

Hi,
Thanks for the suggestion. I am trying to do exactly that but finding the combination to set this dynamic visibility is where i am stumped.

I will explain myself a little more clearly here… mayb im missing something really small,

I have 3 toggle buttons in the model (discount, revenue and measure3). Each trigger adifferent web service.
Each writes into its own cell, each loads a diferent value into the cell(F6, F7,and F8 ) based on whether it is in OFF or ON state. The values on these three cells are added up in ‘additioncell’ (G8 which i would like to use for the nested IFs and dynamic visibility)

Assuming i have taken the following values for the on and off for each button,
Off On
D 111 333
R 555 666
M 999 1111

I will have the following combinations possible (where 0 - OFF, 1 - ON)

D R M Total
0 0 0 1665 (111+555+999)
0 0 1 1777 (333+555+999) etc
0 1 0 1776
0 1 1 1888
1 0 0 1887
1 0 1 1999
1 1 0 1998
1 1 1 2110

Note: Whenever the user clicks on button 1 (doesnt matter if he is turning it on or off), we should enable visibility for graph1.

MY BIG PROBLEM : :crazy_face:

Take the case of the combination, 1-0-1
The final value in the additioncell = 1999

But there could be multiple workflows that could cause this value.

a) User clicks on Discount (button1), then clicks on Measure3 (Button3). This means he wants to see graph3 as that is his most recent selection.

b) user clicks on Measure3 (button3) and then clicks on Discount (Button1). Same combination 1-0-1 and same value 1999, but this time, he wants to see graph1 as discount is his most recent selection.

I am unable to figure out how to write nested Ifs for this set up.
How do i set the dynamic visibility for graphs1, 2 and 3? Can i reset the value in the addition cell as soon i validate my IF starement in the excel. Is there a way to do this?

I am attaching my model and the base xcel here. Any help is MUCH appreciated :smiley:

Thanks!
forumtopics.zip (29.0 KB)

msharma (BOB member since 2006-11-08)

6

I had a similar problem. I sat and thought about it for several hours each day for several days. I came to the conclusion that it is not physically possible. Seriously

But if you find a way, let me know. I thought inside the box, outside the box, outside the planet on this one.

jclj (BOB member since 2009-08-11)