My goal is to create a monthly employment data series given that each record has the following fields: year, quarter, and 3 monthly fields of the actual data (month 1 employment, month 2 employment, and month 3 employment). I have to associate each month of data to an actual month (e.g., month 2 of quarter 3 in 2018 as employment for August 2018). Each record represents a firm. A firm will have records associated with each month. So, looking for total employment. There are multiple quarters and multiple years. Would I have to restructure the data or create a calculation? Any suggestions?
Hi Darnell,
If you're saying that you only have quarterly data and you need to 'create' three months of data out of quarterly data, then no, don't see a way of doing that appropriately. If your data is only at the quarter level of aggregation then that's the lowest that you can go.
Best to go back to the data source and have those monthly values (at very least) in there to begin with and let Tableau do the aggregations thereafter - it's what its designed to do.
Best, Don
