Line chart with multiple date-numbers traces

Paul Newcome

@Cory Bush Do you have a set start and end date for the chart or is it rolling dates, or...? I ask because we should be able to automate most of it if not all of it depending on your needs.

Cory Bush

The rolling dates are the last 92 days

Paul Newcome

@Cory Bush Ok. That actually makes this process a little easier by having a set number of days to be displayed.

How do you determine which percentage to pull if there are multiple entries on the same date for the same operator?

Cory Bush

This is a new process for us, I believe we have some entry errors. I was trying to make it simple for the example. It is possible to have up to 3 shifts entering on the same date.

Paul Newcome

3 shifts for the same CNC? If so, would you want the most recent one?

Cory Bush

I do believe the final draft will turn into 3 charts, one for each shift. Lets not worry about the different shifts.

What about making two lines from one column? V-CNC #1 and V-CNC #2

thanks for your help

Paul Newcome

If you are going to continue to have all 3 shifts entering their forms to the same sheet, we will still need to determine exactly which percentage to pull for each of the given dates. We can approach that later, but it can possibly affect the overall formula used to pull the percentages.

The basic idea is this...

Create another sheet with a single Date type column as well as two text/number type columns.

Based on your screenshots, it looks like you want the far left date to be today. In this case, you would simply enter

=TODAY()

in the first row of the date type column.

Then in row 2 you would enter

=[Date Column Name]1 - 1

Then dragfill this down until all 92 of your dates are in the sheet.

Then we would use formulas to pull the appropriate percentages based on the date and CNC# into each of the 2 text/number columns. This particular formula will depend on your exact setup and details though.

Angel Trevino

https://community.smartsheet.com/discussion/comment/243635#Comment_243635

https://community.smartsheet.com/discussion/comment/243635#Comment_243635

https://community.smartsheet.com/discussion/comment/241739#Comment_241739

Angel Trevino

@Paul Newcome

Paul, Have a question in regards to a line chart I'm having issues with. Comparing project budget hours to actuals. Can you help?

I need to create a line graph with two lines showing budget vs actuals for each project on the first column.

Thank you in advance,

James Vandezande

I'm also having trouble with a similar issue. I want to generate time-based metrics of tracking recruiting candidates. From our candidate tracking sheets, I have a central "metrics" sheet where I am counting the relevant data. From there, I have automation that takes the TOTAL row and copies it into a separate sheet at regular intervals. Then, I have a report that looks at the time-based exports sheet to feed to a dashboard chart.

The problem is that I can't get the DATES to appear on the line chart:

Any ideas on why that's not showing?