Close Button in a drill down

[Former Member]

Hi All,

I am developing a dashboard that has drill down. Below is the scenaio.

Clicking on Chart 1 should open Chart 2 with a close button and hide Chart1. Clikcing on Chart 2 should open Chart3 with close

button and hide chart 2.closing chart 3 must bring me back to Chart 2. Close on Chart 2 brings me back to Chart 1. I am finding it

difficult to acheieve since close button is not a default option. The reason I want to hide/show on same screen is because I

want to have the same background that has company logo and image components.

Its a very big workaround for such a easy requirement.

Has anyone done this before. Please share ideas.

Much Thanks!

-Sam

BOBJ XIR2

[Former Member]

Hi Anil,

You Rock Man!

Thanks for the example. This is exactly what I was looking for.

Thanks,

Sam

[former_member186358]

Not a Problem!!..Sam

-Anil

[Former Member]

Your solution has brought me very close to the answer. I have sent you an attachement with modification to your xls

It is a great Idea though.

Thanks,

Sam

[former_member186358]

Sam,

Contact me through my profile, i will send you a sample dashboard.

-Anil

[former_member186358]

Sam,

I will try to explain it over here...and if you find it tough to develop, you can contact me.

Example:

Components: 2 pie charts, 1 toggle button

Chart 1 Data: A 10, B 20, C 30

Chart 1: Map labels and Data to the chart.

in Drill down select it by value and have a destination cell ex: A2

Chart 2: Map labels and Data to the chart.

Toggle: Source should be two blank cells

Destination cell is the destination cell of chart 1

Group Chart 2 and toggle components, choose dynamic display ex: When A2 value is 10

Hope this helps

-Anil

[Former Member]

Hi Anil,

Thanks for the response. I still could not figure out how to do it.

Chart1 is column bar chart. Chart2 and chart3 is also a column bar chart.

Initially my chart 2 and toggle button must be hidden and only chart 1 visible. when I click on a column bar then Chart 1 is hidden

and Chart2 and Toggle button Visible. Click on Column bar of Chart 2 hides Chart 2 and toggle button and visible Chart 3 and

Toggle Button. Click on toggle button for chat 3 hides chart 3 and brings back to Chart 2 and toggle. Click on toggle there hides

Chart 2 and toggle and brings back to chart1.

I don;t know what should be dynamic visibility key for chart1. If I set Chart1 and Toggle Button to Same Cell then by default

Chart1 is always going to overide a value in that cell. I would'nt know when to Hide chart1 in that case.

Much Thanks!

-Sam

[former_member186358]

Sam,

Contact me through my profile, i will share a sample dashboard.

-Anil

[Former Member]

Hi Anil,

I sent you my contact thru your profile. Please share any example you have.

Thanks

Uncle Sam

[former_member186358]

Uncle Sam

Sample dashboard is sent to your email...

-Anil