Skip to Content
avatar image
Former Member

Total vs Detail Trend line Graph in Design Studio

Hi DS gurus,

I'm using Design Studio 1.2 version and have a requirement to show/compare a trendline graph of total values w.r.t detail values of different category. Here are the attached my Trendline graph and Data sets.

This is how the requirmenet goes

1) I have a drop down of various categories like Vendor, Equipement, Material (refer dataset attachment)

2) The trendline graph needs to compare total values (of all categories) w.r.t a selected category (value from drop down). refer the graph attachment.

3) I have only one measure in my data set. I want to display that as two different data points in the trendline graph(one for Total and one for the selected category).

When I select a value from the downdown, the total also changes accordingly. I like to keep the total values unchanged when I select a category. Is there any way we can do that in DS ?

It's easy in WebI, where we can create a variable measure for a the selected category and we can use the total and the variable in the graph as two measures.

Please let me know if you have further question.

Regards
Saubhagya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 30, 2014 at 05:09 PM

    Hello Saubhagya,

    that should be possible with the setDataSelection option in the script or using the DataSelection option in the properties - depending on what you would like to do.

    here is a script - I don't have Design Studio running right now, so no 100% guarantee.

    Lets say you have a crosstab and a chart and you would select the two rows in the crosstab.

    on the onSelect event for the crosstab you could add something like this:

    --------------------------

    ChartSelection = ChartSelection + CROSSTAB.getSelectedMember(<Your item here>).internalKey + "|";

    var FinalSelection = ChartSelection.split("|");

    CHART_1.setDataSelection({

    "<Your item here>": FinalSelection

      });

    ----------------


    regards

    Ingo Hilgefort


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      In regards with Design studio, you should make it in a single datasource. I am not sure how to do it in Universe level though.

      One more option would be to overlap two charts, but it will be very difficult to do.

      Regards,

      Fazith Ali Z.