Oracle Communities

Oracle Analytics and AI

Child Item

How to resize the graphs dynamically on a dashboard

DollyG

Hi All,

I have 9 graphs on my dashboard with a fixed canvas width and height (500p*350p).

By default all these graphs are displayed on the dashboard. However, I have 3 checkboxes:

on selecting any 1 checkbox, corresponding 3 graphs are displayed and rest should be disabled from the dashboard.

I am able to achieve this requirement, but what I need is: When 3 graphs are displayed, they should be resized dynamically so that they fit proper on the dashboard and no blank space is encountered.

Similarly, when I select 2 checkboxes, 6 graphs are displayed, and they should resize accordingly. Can anyone please tell me, how can I achieve this requirement?

Thanks,

Dolly

Find more posts tagged with

Accepted answers

All comments

ArijitC

You can have 9 graphs displayed in 3 rows. Have 3 similar(related to check box) graphs in each rows in a section. Display a particular section based on checkbox value.

i.e.

When check box 1 selected only one section is visible.

For check box 2 , 2 section will be visible.

This way the look and feel will be consistent.

Thanks

Arijit

DollyG

Hi Arijit,

Thanks for ur reply!

I am doing in the same direction , for 1 check box selected, 3 graphs are displayed in 1 section and so on.

But, say when 1 check box is selected, those 3 graphs in 1 section are of the same width and height. My point here is only 33.33% of the available space is utilized in this manner.

Is there any way by which these 3 graphs become bigger dynamically to adjust the dashboard page?

Thanks,

Dolly

Robert Angel

You would have to create two versions of the reports. One with the larger scale to fill the dashboard, the others at the smaller scale to display when the others are selected.

Not good for maintenance but would give the effect you are seeking.

Alternatively you might want to look into javascript to achieve your ends.

DollyG

Thanks for ur reply Robert!

Can u please tell me, how this requirement can be achieved using javascript?

Robert Angel

Look on this page for resizing, the example cited is old but the principal does not change; -

Oracle Business Intelligence Developer Blog

Robert Angel

Btw, on a simpler basis have you tried starting with the objects bigger but allowing 'can shrink'? - I am a big believer in keeping it as simple as it possibly can be, and for me your requirement is over engineered.

The point of BI is the INFORMATION, the 'cosmetics' of the dashboard appearance very much secondary.

Martin van Donselaar

You will not need any javascript for Roberts suggestion and I would follow it because it's easy and out of the box.

If you must and have a lot of time on your hands you can probably do it with D3.js

https://d3js.org/

https://www.rittmanmead.com/blog/2013/06/embedding-a-d3-visualisation-in-obiee/

Martin van Donselaar

NIce one, thanks! :-)