Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to resize the graphs dynamically on a dashboard

Received Response
42
Views
8
Comments
Rank 5 - Community Champion

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 6 - Analytics Lead

    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

  • Rank 5 - Community Champion

    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

  • Rank 8 - Analytics Strategist

    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.

  • Rank 5 - Community Champion

    Thanks for ur reply Robert!

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

  • Rank 8 - Analytics Strategist

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

    Oracle Business Intelligence Developer Blog

  • Rank 8 - Analytics Strategist

    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.

  • Rank 6 - Analytics Lead

    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/

  • Rank 6 - Analytics Lead

    NIce one, thanks! :-)

Welcome!

It looks like you're new here. Sign in or register to get started.