3 Replies Latest reply on Apr 27, 2016 7:24 PM by Manideep Bhattacharyya

# Repeating a SUM across different parameter options in the same graph

Hi There,

Let's say my data is as follows:

Product / Price / Delivery Time (days)

A / \$10 / 4

B / \$20 / 6

C / \$15 / 2

etc..

And I would like to show the total sum of cost of all the products and place a color split based on the \$ amount above or below a certain delivery time value. I currently am able to create a simple stacked-bar chart / pie graph that shows a split of this. I additionally set parameter control such that I can variably change the delivery time and I can dynamically adjust to see the split change based on the parameter. This works fine for me.

My question is there a way in which I can show the same graph side-by-side based on pre-defined interval levels? Say 5 days, 10 days, 15 days etc?

I've tried repeating the SUM pill as separate rows with multiple dimension split filters and placing them - but I would like to have the stacked bar charts side by side, rather than one above another. This seems a bit brute force of a method as well. Is there any more elegant way to do this?

Any ideas / suggestions are welcome.

Attached a sample workbook.

Thanks,

Herman

• ###### 1. Re: Repeating a SUM across different parameter options in the same graph

Hello Herman - I think you are looking for something like this.

Here I have created a bin on your delivery, so 1,2,3 denotes delivery time and accordingly product are grouped along with pricing. Please let me know for any help.

Thanks,

Manideep

• ###### 2. Re: Repeating a SUM across different parameter options in the same graph

Hi Manideep,

Thanks for the tip on using bins - I didn't know of that feature prior. I realize that you solution does solve my initial question as I re-read my question and it wasn't as clear as I thought.

I'm actually interested in the repeating the total sum function multiple time and showing a color split of the three different ones. I realized I can do it but creating a sheet for each and then placing it into the dashboard side by side. though that doesn't seem as elegant as I wished.

Herman

• ###### 3. Re: Repeating a SUM across different parameter options in the same graph

Hello Herman - It can be achieved without using Sum(Price) for many times as well.

Thanks,

Manideep