Count with time dimension

Jsdeloria21
Jsdeloria21
in Modeling

Hi, I would like to ask something with regards to count with time dimension. The details are in the attachment. My apologies, i had to recreate the file since I was informed that I cannot post actual screenshot of data from client. Please see attachment for details.

 

Regards,

Tagged:

Best Answer

  • Misbah
    Misbah
    Answer ✓

    @Jsdeloria21 

     

    You have to convert your Time into Anaplan Formatted Time and then aggregate the Count. Here are the steps that you can follow:

     

    Step 1: Your numbered list (List Geno) where you have the data

     

    clipboard_image_0.png

    Step 2 : Create a module called Sys Mod with List Geno as a dimension and Create three line items ( this is as per best practices, you can do the same exercise in your list directly but that goes against best practices)

     Year - Refer it from List

    Month - Refer it from List

    Month(Anaplan) - PERIOD(DATE(Year, Month, 28))

    clipboard_image_1.png

    Step 3 : Create another Module called Target Module and Create one line item called Units

    Units - List Geno.RU Text Count[SUM: Sys Mod.'Month (Anaplan)']

     

    clipboard_image_2.png

    Hope that helps

    Misbah

Categories