IBM Apptio

IBM Apptio

A place for Apptio product users to learn, connect, share and grow together.

 View Only

  • 1.  Date Partition - Can we get an explanation?

    Posted Fri April 08, 2022 10:38 AM
    Hello,

    Can we please get an explanation as to how date partition actually works?  Any time I load a new data set I copy an existing partition, but it never seems to work.  I have dates formatted as MMM/dd/yyyy, MM/dd/yy, MM/yyyy, and MMM/yyyy, and some of these are formatted as actual dates and others are formatted as labels.  I literally just try different combinations until something works.  Does anyone have an explanation on what Date Partition is actually looking for?

    ------------------------------
    Matt
    ------------------------------

    #CostingStandard(CT-Foundation)


  • 2.  RE: Date Partition - Can we get an explanation?

    Posted Wed April 20, 2022 11:24 AM
    Edited by Guillermo Cuadrado Tue November 05, 2024 06:33 PM

    I need to look into this, @Matthew Vanacore. I have used Data Partition in tables that have data in columns, e.g.:

     
    JAN 21  JAN 22
    val1          val4
    val2          val5
    val3​          val6
     
    So far, the logic works well, and the engine understands what I'm trying to do,  i.e. isolating the data for the current month.

    (Later)
    I tried with some of the values you suggested and the engine recognized the first column in the table as containing relevant date information:


    It also recognized the third column:


    ... but not the 2nd (the American date format):

    I believe this is because we have our Locale set as Ireland; it might work for you.


    This is what I uploaded to the test table:

    MMMddYYYY MMddYYY MMMyyy OpEx
    15-Jan-22 1/15/2022 Jan-22 72655
    14-Feb-22 2/14/2022 Feb-22 67256
    17-Mar-22 3/17/2022 Mar-22 32972
    16-Apr-22 4/16/2022 Apr-22 20560
    17-May-22 5/17/2022 May-22 10428
    16-Jun-22 6/16/2022 Jun-22 96484
    17-Jul-22 7/17/2022 Jul-22 45504
    16-Aug-22 8/16/2022 Aug-22 8915
    16-Sep-22 9/16/2022 Sep-22 87569
    16-Oct-22 10/16/2022 Oct-22 46472
    16-Nov-22 11/16/2022 Nov-22 9677
    16-Dec-22 12/16/2022 Dec-22 1175


    ------------------------------
    Regards, Guillermo
    ------------------------------

    Original Message


  • 3.  RE: Date Partition - Can we get an explanation?

    Posted Fri January 06, 2023 04:55 PM
    @Guillermo Cuadrado, I know it's counter-intuitive, but I believe the "American date format" that we support may require the leading zero for month and day, so try uploading dates that look like:

    01/15/2022
    03/09/2022​

    Thanks,
    Supin
    Original Message


  • 4.  RE: Date Partition - Can we get an explanation?

    Posted Mon January 09, 2023 02:03 AM
    Good to know, @Supin Ko. Thanks for pointing it out and all the best for 2023!​

    ------------------------------
    Regards, Guillermo
    ------------------------------

    Original Message


  • 5.  RE: Date Partition - Can we get an explanation?
    Best Answer

    Posted Wed April 20, 2022 11:39 AM
    Try this?  https://help.apptio.com/en-us/studio/data_studio/partition-data-by-date.htm?Highlight=date%20partition
    Original Message