Level 3 Spring 1 User story 1,6

kunal_311
Contributor

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?

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisHeathcote
Community Boss

Re: Level 3 Spring 1 User story 1,6

@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. 

 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

3 REPLIES 3
jrimmer93
New Contributor

Re: Level 3 Spring 1 User story 1,6

Hi Kunal - you may want to think about how time may impact this calculation. Good luck!
ChrisHeathcote
Community Boss

Re: Level 3 Spring 1 User story 1,6

@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. 

 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

kunal_311
Contributor

Re: Level 3 Spring 1 User story 1,6

Thank you @jrimmer93 @ChrisHeathcote  for your guidance.

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