Level 3 Spring 1 User story 1,6

kunal_311_0-1618336952085.png

kunal_311_1-1618337118454.png

I am struggling to understand what I need to do for this activity. 

 

I created a module with G2 Country and Segment dimension but I am not able to populate this module. 

Am I missing something? Attached screenshot 

 

Is this what the activity is asking for?

Tagged:

Best Answer

  • @kunal_311 

    I believe you have built the correct model with the correct dimensions.

    Did your formula generate any errors?

    If not then there a number of possible reasons why no data is flowing through.

    1. TAR02 time dimension is YEAR and TAR04 is MONTH. If my memory is correct TAR04 should be YEAR.

    2. TAR02 contains no COUNTRY mapping used to inform the SUM function.

    3. TAR02 contains no SEGMENT mapping used to inform the SUM function.

     

    My guess is that you need to change the MONTH time to YEAR as time defaults to MONTH when first created and does not generate an error. It just returns no value. 

     

Answers

  • Hi Kunal - you may want to think about how time may impact this calculation. Good luck!
  • Thank you @jrimmer93 @ChrisAHeathcote  for your guidance.

    Got it correct by changing the year and mapping reference for the SUM function.

  • By 1. TAR02 time dimension is YEAR and TAR04 is MONTH. If my memory is correct TAR04 should be YEAR.

    I get the solution.