Repeat a value based on date comparison

tableaucommunity@tableau.com — Tue, 08 Jan 2013 02:05:17 GMT

I am attempting to create a chart that will repeat the cpu used for each day the job was running. The table used contains the fields; jobid, startdate, enddate and cpuused. If the startdate does not equal the enddate, I would like to display the cpuused. Is there a way to do this in Tableau? Thank you for your help!

Example actual table data:

jobid	startdate	enddate	cpuused
1	12/1/2012	12/3/2012	26
2	12/2/2012	12/2/2012	1
3	12/5/2012	12/5/2102	5

Additional records were created in my test file to show how I would like Tableau to display the data. This is not how the data actually exists in the table I'm connecting to.

jobid	startdate	enddate	cpuused
1	12/1/2012	12/3/2012	26
1	12/2/2012	12/3/2012	26
1	12/3/2012	12/3/2012	26
2	12/2/2012	12/2/2012	1
3	12/5/2012	12/5/2102	5

Below would be the data point's displayed in the chart. I have attached an example of the test Tableau report created.

12/1/2012 - 26 CPU Used

12/2/2012 - 27 CPU Used

12/3/2012 - 26 CPU Used

12/5/2012 - 5 CPU Used

Attached is an example of my test Tableau Report:

Content in Tableau Community Forums

Repeat a value based on date comparison