Skip to Content
avatar image
Former Member

How to catch selected member value "Total" in Waterfall Chart to avoid the unknown error message

Hi experts,

I have two charts...

Chart 1 = Waterfall (inclusive "show Totals" setting); Chart 2 = Column Chart

In the Waterfall Chart I use the script "DS_2.setFilter("Dimension 1", CHART_1.getSelectedMember("Dimension 1"));

If I select the Member 1, 2 or 3 everything works fine...

If I select "Total" instead of a member...

The following "Unknown Error Message" occurs:

Is there a way (e.g. if-statement) to catch the selected member value "Total" in the Waterfall Chart to avoid such a error message?

A workaround is to add a "Panel" Component over the Total Column... to make the Total Column not selectable.

Many thanks in advance!

Best regards,

Michael

Waterfall1.png (11.9 kB)
Waterfall3.png (19.1 kB)
Waterfall2.png (7.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 12, 2015 at 07:38 PM

    Hi all,

    I´ve fixed the problem with the following if-statement

    if (CHART_1.getSelectedMember("Dimension1").text != "Overall Result") {

         DS_1.setFilter("Dimension1", CHART_1.getSelectedMember("Dimension1"));

    }

    else {

        DS_1.clearFilter("Dimension1");

    }

    So the error message is not showing if the user select the "Overall Result".  Instead  all the members of the dimension are displayed in the another component (e.g. chart).

    Regards,

    Michael 

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11, 2015 at 03:44 PM

    Hi Michael,

    Could you not display the total on the waterfall chart, selecting the property option "Show total" to false?


    properties.jpg (51.0 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Michael:

      Which version of Design Studio are you using? I am on DS 1.4 with the 12/19 patch

      I am not getting an exception error but "no data available" - which is probably more acceptable than the dump you are getting - see below:

      My data source is a BEx query

      Also, your other options are the dimension panel and filter panel.

      mr.jpg (23.6 kB)
  • Jan 12, 2015 at 06:33 PM

    Hi Michael,

    are you getting the error message based on the code you added to the onSelect option or do you see the error message also without the code ?

    thanks

    Ingo Hilgefort, Visual BI

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ingo,

      thanks for your reply!

      The error message only appears with a OnSelect statement.

      Regards,

      Michael