Skip to Content
Former Member
Dec 30, 2014 at 04:54 PM

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.