Turning Daily Data in Monthly

For the DCA Wrangler, you’ll need to have your data organization into monthly values, which is tricky if you have daily production data that you’re working with. The conversion, however, is simple in Spotfire. Follow these steps to convert daily to monthly:

  1. Select File > Add Data Tables…
  2. Select Source and choose your existing Daily production data from the current analysis

Before you press OK, we need to add some transformations:

  1. First, we need to Calculate new column, we need something to aggregate by and in this case it’s ProductionMonth. Use the expression: Date(Year([Date]),Month([Date]),1)
  2. Now add the Pivot:
    1. for your Row identifiers choose your newly created ProductionMonth.
    2. for your Value columns and aggregation methods select Sum(BOPD)
    3. set your Column naming pattern to %V
    4. if you have metadata to pass through such as well name or API add it to your Transfer columns and aggregation methods
  3. Review the data and press OK.

You’re all set! Repeat the process to include GAS or NGLs.


Leave a Comment

Your email address will not be published. Required fields are marked *