0 Replies Latest reply on Oct 15, 2018 12:27 PM by jeremy.haynes

    Comparing Hurricane Events

    jeremy.haynes

      I have a database table with data similar to what is in Sheet1 of the attached excel file. The data is broken out between Hurricanes Irma from last year and Michael from this year and I want to chart out how many events were active at any given hour on Day 0 of the storm, Day 1, etc. I would like a data table and line chart similar to what is in Sheet4 of the attached excel file, showing how many events were active at each given hour. The problem I've run into is I can't make Start Day/Start Hour continuous and have them nested, if they are continuous, it makes 2 charts. To make one chart, I can make them discreet, but that breaks the line. I made a separate list of all days and hours as a csv, but it still won't do continuous. How do I do this?