Line chart with multiple date-numbers traces



  • Paul Newcome
    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.

  • The rolling dates are the last 92 days

  • Paul Newcome
    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?

  • 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
    Paul Newcome ✭✭✭✭✭✭

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

  • 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
    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


    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
    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,

  • 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?