Community Boss

Count with time dimension

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,

1 REPLY 1
Highlighted
Community Boss

Re: Count with time dimension

@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