Problem Using TAB SET in Dashboard Designer

[Former Member]

Hi Experts,

Attached are two images of my requirement. There is a Main Tab Set Consisting of 7 Tabs and each single tab contains a sub-tab set which also consits of 7 tabs. There are 2 calendars, 2 combo boxes, 4 toggle buttons and 3 Column Charts (Using Dynamic Visibility). Two images attached calrify the exact requirement.

Now, whenever, i try to run that in preview mode, sometimes it shows the components sometimes NOT. I tried different things(including Re-creating whole dashboar) BUT NOTHING WOKRS.

Any Idea what might be the reason? or am i missing something? or is there any limitation of tabset e.g, NOT to support 7 tabs etc?

Kindly help me out in this.

Regards

Ayaz

[former_member184839]

Hi Ayaz,

Label Based Menu ll be the best option for replacing the tab set component. Suppose you have the main labels from label1 : label7
(A2:A8) and the destination of it is given in the cell "f1" (suppose).

Now you have your second label based menu(7 in number)  , (for each view( label) in the first label based menu) each of which has 7 labels within it.  Mark a destination for it suppose "c4". Give dynamic visibility to these label based menus by linking the status of it to cell "F1", key ll be the respective labels of the label based menu.

lets see for the 1 secondary label based menu, its labels ll be "N1:N6". n destination ll be "C4".

Now in a cell suppose "d4" write a formula, = =IF(AND(F1=A2,c4=N1),1,IF(AND(F1=A2,c4=N2),2,IF(AND(F1=A2,c4=N3),3,IF(AND(F1=A2,c4=N4),4,IF(AND(F1=A2,c4=N5),5,IF(AND(F1=A2,c4=N6),6,IF(AND(F1=A2,c4=N7),7, FALSE))))))

this was the formula for the first label of the main menu,

(You gotta write similar ones for the rest 6 (main)labels in the other cells (by replacing the "A2" and "N1:N7" as per the requirement.

The thing here is , the nested formula works only for 7 loops. Not more than that. As u have exact 7 this would work fine.)

Now link the dynamic visibility of the components of "first label of the first main label" ( 1 main label and first main sub label)  to be displayed to the cell "D4" and give respective key to the components ,as it is to be displayed. Viz. the components(charts ,toggles, etc)  in the first main label and first sub label the status: D4 and key : 1.

Follow the same procedure for the rest tabs too.

Hope this helps.

Thanks and Regards,

Sara

[Former Member]

Hi Ayaz,

Instead of using those tab sets we can get in different way by combination of dynamic visibility and label based menu.

Suppose the first label based menu have 7 Labels

It contains source data of label names and bind the destination to 7 cells let A1:A7

So when we select Label 1 , the destination cells contain labels that are associated with Label 1.

For the rest the process is same.

Take another Label based menu, bind the labels to cells A1:A7 which contains label names associated with the selection of first label based menu.

For this label based menu, set insertion type as labels and set destination to single cell in excel sheet.Let B1.

Based on the cell B1, apply Dynamic visibility property for the rest of the components (Charts,Combo boxes, calenders etc..). Set the status as B1 cell  and give the key as label names and  Then u get the components only based on your two label based menus selection.

Hope you understand.

Thanks,

MVVK

[charlesreed]

Hi Ayaz,

Is there a reason you are recreating each view 7 times? 

I understand the need to have a tab set for different views, but you have the same components on each tab, and therefore this is an inefficient design.  You should be able to use one set of components and then map to data in Excel.  It is a more efficient way of designing your dashboard.

For example, replace the tabs with push buttons.  Then, when each button is clicked, the components (calendars, combo boxes, charts, etc.) can be refreshed.

Regards,
Charles

[Former Member]

Hi,

tab set component will kill the performance.

I suggest to use the push / label instead of it

THanks,

Raj