There’s one more way to solve the 1st question….First, create a LOD = {FIXED [Customer ID] : Year(MIN([Order Date]))}. Next, use the Order_Date as filter and filter out the 2010. After that put the order_date in column and Count(distinct(customer_id)) in rows. Finally, make the order_date filter as ‘add to context’. You will get the customer count of 2011 order date as 1213 and 530 for 2012 orderdate but LOD as 2011. So the answer will be (530/1213)*100=43.69%….

… or not, I tried the below and it still works without LOD at all. Just make a calculated field out of it and drag that to the text, make sure there’s no aggregations in place.

SUM(IF [Region] = ‘East’ then [Sales] end)
– SUM(IF [Region] = ‘South’ then [Sales] end)

To get step-by-step solutions, you can enter your email to subscribe to our content after submitting the quiz. You can also unsubscribe us anytime but I am sure our content will be very helpful.

Hi, My wuestion is that does it matter how you find the answer for a hands on question. DO they check your charts? For eg. If I guess a correct answer without creating a chart, will that be marked as correct or not?

To get step by step solutions, please enter your email after submission to subscribe and you will receive an email with a link to download the solutions.

There’s one more way to solve the 1st question….First, create a LOD = {FIXED [Customer ID] : Year(MIN([Order Date]))}. Next, use the Order_Date as filter and filter out the 2010. After that put the order_date in column and Count(distinct(customer_id)) in rows. Finally, make the order_date filter as ‘add to context’. You will get the customer count of 2011 order date as 1213 and 530 for 2012 orderdate but LOD as 2011. So the answer will be (530/1213)*100=43.69%….

The last question can be answered by using a simple exclude LOD –

{EXCLUDE [Region]: sum(IF ([Region]=’East’)

then ([Sales]) end) – sum(IF ([Region]=’South’)

then ([Sales]) end)

}

… or not, I tried the below and it still works without LOD at all. Just make a calculated field out of it and drag that to the text, make sure there’s no aggregations in place.

SUM(IF [Region] = ‘East’ then [Sales] end)

– SUM(IF [Region] = ‘South’ then [Sales] end)

Also like this:

{ FIXED : SUM(IF [Region] = ‘East’ THEN [Sales] END) – SUM(IF [Region] = ‘South’ THEN [Sales] END) }

Where can i see the worked solutions to the LOD questions?

Hi Manju,

To get step-by-step solutions, you can enter your email to subscribe to our content after submitting the quiz. You can also unsubscribe us anytime but I am sure our content will be very helpful.

Thanks,

Iris

Can u pls send me the step by step solutions?

sent

Hi, My wuestion is that does it matter how you find the answer for a hands on question. DO they check your charts? For eg. If I guess a correct answer without creating a chart, will that be marked as correct or not?

They don’t check your charts, they only check if you put the right answer in the multiple choice.

Please send me the step by step solution for LOD

Hello Karuppasamy,

To get step by step solutions, please enter your email after submission to subscribe and you will receive an email with a link to download solution.

Thanks,

Narcis

Guessed at question 1. Please provide solution.

Hello Martin,

To get step by step solutions, please enter your email after submission to subscribe and you will receive an email with a link to download the solutions.

Thanks,

Narcis