5 Replies Latest reply on Jun 6, 2012 1:28 PM by gwichman

# Stacked Bar Graph With Limited Data?

I'm wondering if there is a way to do a stacked bar graph when my data source looks like this..

 Project Name Start Date End Date Total Bytes (GB) Project A 6/1/2012 10/15/2012 310000 Project B 6/23/2012 9/30/2012 25000 Project C 7/18/2012 12/1/2012 42000 Project D 8/1/2012 10/1/2012 55000

The basic info is there to calculate how many bytes per day/week/month of the total one would need to load to complete the project on time. e.g. Project A has 136 days between the start and end date. Divide 310,000 GB by 136 and you get 2279 GB per day would be the rate needed to load that project and keep it on track by it's end date. If I can plot that bar graph then even better would be to stack them so that i can see the aggregate rates across all projects similar to the below. I'm shooting for monthly really but in theory the data is there to calculate it per day, week, whatever. I'm just not sure if there is a way to do this in Tableau vs my manually manipulating the data source to give me individual data points.

Note this graph isn't from the above data but give you an idea of what i'm after:

• ###### 1. Re: Stacked Bar Graph With Limited Data?

Hi Gerald,

Not sure if this is what you're going for, but I've attached a workbook using the data provided. Hope it helps!

-Tracy

• ###### 2. Re: Stacked Bar Graph With Limited Data?

Not quite.. e.g. looking at the workbook, project A only shows up in the bar graph for June. It should show volumes for June, July, August, September, and October. As though my data source had multiple entries for Project A.. One for each of those months since it's start and end date go from June to October.

• ###### 3. Re: Stacked Bar Graph With Limited Data?

Ah, I understand now. Project A would need to be in every point of the data to appear in every month.

-Tracy

• ###### 4. Re: Stacked Bar Graph With Limited Data?

How about something like the attached?

I used custom SQL on the attached file to create a record for every date-project combination with a filtered Cartesian, so an Extract would be highly recommended.

I added an alternate view that may also be useful, gray line being the total.

• ###### 5. Re: Stacked Bar Graph With Limited Data?

Hmm thats clever and will work for my purposes. It'd be better if there was a way to do it without creating the second table with all the dates but I like it!