54 thoughts on “Tableau Certified Associate Practice Exam 3 (Retired Exam)”
Beth Kairys
Hi, thanks for another fantastic resource! A few pickups
– q4 is ambiguous. it asks about the item with the biggest growth, which I inferred as % growth, but the answer was based on $ growth. Would be good to clarify this in the question (there are two items close together, and the one you pick depends on whether you want % or $ change)
– q14 is marking wrong – the answer in the guide is consumer + corporate but it is being marked as corporate + home office
– q21 should say through to December 2016, rather than December 2017
Minor though – this is a fantastic resource that I’ll definitely recommend to anyone taking the CA exam!
I don’t know if it is just me but I found this practice exam harder than the previous two – I passed them but failed this one. When I reviewed the solutions there were things I wouldn’t have thought of, even if more time was allowed. How advanced is the test really? Any one on this thread done the real test yet?
First, I want to thank Lukas for providing us with this third exam. I cannot imagine how much effort goes in to put these exams together.
Generally, I found this exam to be much, much harder than the first two exams, with many ambiguous questions (though this may be because I am neither American nor have ever had car insurance!). While in the first two, I was able to score 90+, I scored a mere 74% on this one (a fail!). I guess I will soon find out if the actual exam is similar!
Trying not to repeat what has already been outlined by others, I have a couple of observations organized by question number:
4. Would it make sense to specify that the measure we are to be using is average annual deductible rather than just annual deductible?
6. I am wondering whether Parallel Query reduce the “number of queries” needed to load a worksheet. As you specify, parallel queries “execute more queries at the same time”. Doesn’t that mean the same number of queries, but executed in parallel.
10. This one was confusing as in a previous step we had combined 2019 Data to the Insurance Data sheet. This question specifies “beginning in 2018” which I took to use 2018 and 2019 (which gives a difference answer). I think it might be good to specify that the only sheet to be used is the Insurance Data sheet.
16. Why include % of Total Count in the solution? This does not seem to contribute to the answer.
26. The data source does not seem to be specified.
Thank you for the detailed feedback Rachel. I agree with you on all points.
4 – It should be clear that we are talking about annual deductible rather than total deductible, but I updated the question to make this explicit.
6 – I agree that parallel query doesn’t reduce the number of queries, it runs the same number of queries in parallel. However, since the curriculum changed and removed this topic, I replaced this question with a different one.
10 – I’ve made it clear that the question is just asking about the 2018 insurance year.
16 – it’s not necessary, so I redid the screenshot without it.
26 – Added the data source this to the question text.
Thanks for the exams, it really helps.
However, I have an issue for Q10. I think your answer is based on older version of Tableau. I am unable to join the tables on a calculated field as shown on the answer. I have “relationships” instead, and I don’t know how to join the two tables based on the calculated field.
Can you tell us how to do?
Thanks
At least as of 2020.2, you cannot create a relationship between tables using a calculated field. You need to double-click the table to get to the join menu. Currently (August 2020) the exams are given using version 2020.1, the version before relationships were introduced.
I found Practice Test 3 Difficulty level on a higher side in comparison to first 2 practice test papers, Now the point to note is First Practice Test was made in Year 2016 and second one in year 2017 and the 3rd one in 2019.
Now my question to Lukas ,Is the real Certification level is also increasing or the first 2 practice test paper are similar to what we will get in real exam.
Kindly please comment on difficulty level of real Tableau Certification.
The question is asks, ” for the years when the prizeis awarded in a category, what percent of the time is it shared?” for example, when the Nobel Peace Prize (category = peace) is awarded, how often is it awarded to more than one person.
The question asks about the, “greatest average increase in annual sales.” So, you need to use SUM(Sales) to calculate the sales for each year. Once you have the annual sales, you calculate the average increase.
Hi Lucas,
Thanks for the test. It really helped me learn more about tableau. Exam 3 was much harder than prior 2 exams. What will be the difficulty level of actual CA exam. Will it be like first two exams or 3rd one.
I already see the same question being asked by multiple candidates above but don’t see answer to it. Could you please answer this one.
It varies time to time. Based on my personal experience, the difficulty of real exam is between 1/2 and 3. Hands-on are doable but knowledge-based questions could be very tricky.
The answer for 14 appears to be wrong. It should include Home Office. Put Sales on columns. Profit on Rows. Segment on Filter. Filter Segment to Home Office. The density dot hover says 6 and 13.
Could you please help me better understand your concern? We did include Home office and the answer should be correct as the corporate segment shows the darkest color which indicates higher density when profit is 6 and sales is 13.
The answer for 35 appears to be wrong. Alexandria has the closest annual premium. Silver Spring has the closest AVERAGE annual premium, which the question does not ask for.
Hello,
Is it me or was the 3rd practice exam super difficult? A lot more difficult than the first 2 practice exams. Kindly let us know which we should expect. And if any one else reads my comment and has already taken the exam, please let us know your experience. Was it as difficult as the 3rd practice exam?
Thank you for putting this course together. I’ve learned so much.
I have taken the CA exam in June 2020. Based on my personal experience, the difficulty of hands on questions in the real text is between practice exam 1/2 and 3 while the knowledge based ones are closer to 3 as you need to use google to find the answer in most cases.
You use joins when you mainly want to add additional info to each row and you use blending when you want to use different dimensions/measures that are not corresponding with each data points at a one-on-one level.
For question 15, you have October 2017 highlighted in the picture, but the answer on the practice exam says October 2016. Your screenshot is correct, but the exam answer of “October 2016” does not appear to be correct. Check please?
I double checked the solution guide and “October 26” is highlighted in both picture and question text. Please see the caption of the highlighted point in the picture.
Hi,
Thank you for posting solution guide , pdf. I have a doubt in explanation of Question 20. Column has Year(Order date) and Row has Sum(Sales).
When hover mouse over trend-line, coefficient of Year of Order Date should say SUM of increase in sales per year right?
But explanation says ” The coefficient of Year of Order Date is the average increase in sales per year.”
I am trying to understand how does the coefficient says average as Row shelf has SUM(SALES) rather than average of sales
It does reflect the average increase. A simple example could be:
Assuming the function between Year(order date) and Sum(sales) is “Sum(sales)= A * Year(order date) + B”. In 2013, sales = 2013A+B and in 2014, sales = 2014A+B. Then the increase between the sales of 2013 and that of 2014 is 2014A + B – 2013A – B = A (the coefficient), which indicates average increase in sales per year.
The 2 tables have a different level of granularity (Premium Target is at a car model level and Insurance Data is at a customer level), so a blend is necessary for finding the correct answer.
Yes, you can use google during the real exam. But keep in mind that you can only use google from the VM, not from your local machine and that you can waste a lot of time searching for answers.
For question 8, the question says “Determine the number of days from the order date to the ship date for each Row ID. ” In this case, why don’t we use Fixed [Row ID]? Can you please explain? Thank you in advance!
You can also use a fixed calculation like – {FIXED [Row ID]: AVG(DATEDIFF(“day”,[Order Date],[Ship Date]))}, and we would get to the correct answer. But in this scenario we are adding unnecessary complexity to the calculations without reducing the number of steps required to find the answer.
Relationships were introduced in the version 2020.2 and currently the exam is taken on the version 2020.1 . So you need to know blending very well since in the real exam you won’t have the possibility to use relationships.
In the next couple of months the exam will probably switch to a newer version that will include relationships, but until then you would have to use blends and joins.
I just passed my CA exam with 89% score today. Thank you Learning Tableau for having these extremely useful mock exams along with frequent email updates on some important topics (eg. LOD practice questions). Based on my exam experience today, my questions are easier than some mock questions and there are no complicated calculation questions. But Learning Tableau gives me confidence during the exam as I know I have practiced as many complicated questions as I can on Learning Tableau. Thanks again!
Exam 3 Q3 – I am unsure why I have different answer. I calculated 2018 average Deduction as 1350.44 and 2019 as 1438.92 based on Deductible and 2019 Deductible respectively. These values being the basis for % increase calculation. My final % increase being 6.14 Solution listed a different 2018 average discount value and but same 2019 average discount as mine and thus calculated a different result to mine. Any ideas why I’m getting different answer?
3. Combine the Insurance Data and the 2019 data. What was the % increase in average annual deductible from 2018 to 2019 for cars made by Toyota?
The average deduction for 2019 for Toyota is wrong in your calculation, this is why you do not have the same answer. It looks like you haven’t filtered on Toyota on your calculation, check that and after this, you should have the correct answer 🙂
Just passed the exam on 1/23/2021, thanks to this course. Please do not freak out on the Exam/Practice 3, the real exam is easier but use it as a reference to cover your knowledge gap.
Help me understand why the use of left join?
I used the Inner join and found the same answer.
Q5:
thanks for this method, it helped me understand more.
there is also another way to get the same answer :
-Bring Share to the view and filter out the Null.
-then group “2,3,4” since it is shared.
-Bring the “Number of Records per prizes” to text.
we use this because according to the number of records for a prize,
it indicates whether shared or not.
-add the table calculation Percent of total, you will get the answer.
Q15:
November 2016 also follows the same pattern,
Negative Profit and positive sales
Why did you pick October?
Q36:
can you please tell me why do you take “2019 Data (count)” do determine the number of policies ?
Most of the questions in Tableau can be solved in different methods (similar to math where you can get to the same result in different ways). Q10 – indeed, if you use inner join you will get the same answer, I guess left join was used out of habit ( it’s used more because it doesn’t exclude rows from your table of interest which is usually the left one ).
Q15 – In November, Sales and Profit increased vs the previous month while in October Sales increased vs previous month and Profit decreased vs previous month.
Q36 – each row in the 2019 Data table represents a policy, so using the auto-generated field 2019 Data (count) is the easiest way to count the number of policies.
Question 16 solution is not correct. The question asks which has an average around $1800 but in your solutions file there is a typo that says $1700 . It is bin 200 which is fine at $1773
I was cruising through these 3 exams but did not pass the actual exam I got a 70% so I was fairly close. I think I may have been flustered on browser we needed to use on the actual exam. I also felt that the knowledge based questions on the real exam were much more difficult. I did well on the hands on questions during the exam but I do not know exactly what I missed. Does anyone have any recommendations on retaking the exam?
One tip is to try to use Tableau as much as you can in the exam, even for knowledge-based questions – try each available option to find the correct one.
Practice as much as you can with different datasets, you can find on sites like https://www.makeovermonday.co.uk/. There you can find also reports created by other users, you can download them and see how they are created.
There seems to be a problem with question 8 in that the question doesn’t make it clear with whom the comparison is made. If you compare it to Same day, it is indeed Same day vs First Class that has the biggest difference, when if you change the base to something else, then the number of days of difference changes with it.
I am afraid I don’t understand what you mean. There are 4 options available to answer and the question asks which one of the options available has the biggest difference – from those options the correct one is Same day vs First Class. Not sure how can we change the base to something else, the difference is between Order Date and Ship Date.
Keep in mind that these kind of questions were we have to choose from the options provided, not necessarily from the entire dataset are quite common in the real exam.
Unable to re create Lukas’ answer. Can someone help. I have the same calculated fields and same fields in the view but i do not get the same view. please help.
At the end of the exam you will find a link to the solution pdf for all questions with explanations. Basically for this question you should Purchases by Customer calculated field using LOD Fixed function ({FIXED [Customer ID] : countd(Order ID)}) , Customer’s firs order year ({FIXED [Customer ID]: min([Order Year)}) and the unique count of customers (countd([Customer ID])).
Hi, thanks for another fantastic resource! A few pickups
– q4 is ambiguous. it asks about the item with the biggest growth, which I inferred as % growth, but the answer was based on $ growth. Would be good to clarify this in the question (there are two items close together, and the one you pick depends on whether you want % or $ change)
– q14 is marking wrong – the answer in the guide is consumer + corporate but it is being marked as corporate + home office
– q21 should say through to December 2016, rather than December 2017
Minor though – this is a fantastic resource that I’ll definitely recommend to anyone taking the CA exam!
Thank your for your comments Beth! I’ve made updates on the three questions you mention.
I don’t know if it is just me but I found this practice exam harder than the previous two – I passed them but failed this one. When I reviewed the solutions there were things I wouldn’t have thought of, even if more time was allowed. How advanced is the test really? Any one on this thread done the real test yet?
Hi Lukas,
Let me first thank you for making this training course along with the most valued practice tests.
Today, i have cleared the Certified Associate Exam. Thanks Once Again!
Regards
Vinod Chilukuri
First, I want to thank Lukas for providing us with this third exam. I cannot imagine how much effort goes in to put these exams together.
Generally, I found this exam to be much, much harder than the first two exams, with many ambiguous questions (though this may be because I am neither American nor have ever had car insurance!). While in the first two, I was able to score 90+, I scored a mere 74% on this one (a fail!). I guess I will soon find out if the actual exam is similar!
Trying not to repeat what has already been outlined by others, I have a couple of observations organized by question number:
4. Would it make sense to specify that the measure we are to be using is average annual deductible rather than just annual deductible?
6. I am wondering whether Parallel Query reduce the “number of queries” needed to load a worksheet. As you specify, parallel queries “execute more queries at the same time”. Doesn’t that mean the same number of queries, but executed in parallel.
10. This one was confusing as in a previous step we had combined 2019 Data to the Insurance Data sheet. This question specifies “beginning in 2018” which I took to use 2018 and 2019 (which gives a difference answer). I think it might be good to specify that the only sheet to be used is the Insurance Data sheet.
16. Why include % of Total Count in the solution? This does not seem to contribute to the answer.
26. The data source does not seem to be specified.
Thanks again!
Thank you for the detailed feedback Rachel. I agree with you on all points.
4 – It should be clear that we are talking about annual deductible rather than total deductible, but I updated the question to make this explicit.
6 – I agree that parallel query doesn’t reduce the number of queries, it runs the same number of queries in parallel. However, since the curriculum changed and removed this topic, I replaced this question with a different one.
10 – I’ve made it clear that the question is just asking about the 2018 insurance year.
16 – it’s not necessary, so I redid the screenshot without it.
26 – Added the data source this to the question text.
Hi Lukas,
Thanks for the exams, it really helps.
However, I have an issue for Q10. I think your answer is based on older version of Tableau. I am unable to join the tables on a calculated field as shown on the answer. I have “relationships” instead, and I don’t know how to join the two tables based on the calculated field.
Can you tell us how to do?
Thanks
At least as of 2020.2, you cannot create a relationship between tables using a calculated field. You need to double-click the table to get to the join menu. Currently (August 2020) the exams are given using version 2020.1, the version before relationships were introduced.
Hi All,
I found Practice Test 3 Difficulty level on a higher side in comparison to first 2 practice test papers, Now the point to note is First Practice Test was made in Year 2016 and second one in year 2017 and the 3rd one in 2019.
Now my question to Lukas ,Is the real Certification level is also increasing or the first 2 practice test paper are similar to what we will get in real exam.
Kindly please comment on difficulty level of real Tableau Certification.
Thanks,
Toshit Andola
For question #5, is the question supposed to specify the Nobel Peace Prize, e.g. the Peace category?
The question is asks, ” for the years when the prizeis awarded in a category, what percent of the time is it shared?” for example, when the Nobel Peace Prize (category = peace) is awarded, how often is it awarded to more than one person.
Is q.20 marked wrong? The question asks the greatest average sales % over years , solution mentions the use of sum(sales)..
The question asks about the, “greatest average increase in annual sales.” So, you need to use SUM(Sales) to calculate the sales for each year. Once you have the annual sales, you calculate the average increase.
Hi Lucas,
Thanks for the test. It really helped me learn more about tableau. Exam 3 was much harder than prior 2 exams. What will be the difficulty level of actual CA exam. Will it be like first two exams or 3rd one.
I already see the same question being asked by multiple candidates above but don’t see answer to it. Could you please answer this one.
Grateful,
Shailesh K
Hi
It varies time to time. Based on my personal experience, the difficulty of real exam is between 1/2 and 3. Hands-on are doable but knowledge-based questions could be very tricky.
Thanks,
Iris
In the PDF, Q10’s description suggests that you need to filter the year to = 2018, since the discounts did not occur in previous years.
If you do that, the aggregated discounts for ning.com should be $357, not $1001 as shown in your screenshot.
(Answer doesn’t change because it’s still the most $ discounts)
The answer for 14 appears to be wrong. It should include Home Office. Put Sales on columns. Profit on Rows. Segment on Filter. Filter Segment to Home Office. The density dot hover says 6 and 13.
Hi
Could you please help me better understand your concern? We did include Home office and the answer should be correct as the corporate segment shows the darkest color which indicates higher density when profit is 6 and sales is 13.
Thanks
Iris
The answer for 35 appears to be wrong. Alexandria has the closest annual premium. Silver Spring has the closest AVERAGE annual premium, which the question does not ask for.
Hi
Thank you for letting us know. We will fix the problem soon as we can.
Thanks,
Iris
Thanks LuKas for your useful course, I’ve been practicing your tests over and over again. Today I passed my exam with 85%.
Hello,
Is it me or was the 3rd practice exam super difficult? A lot more difficult than the first 2 practice exams. Kindly let us know which we should expect. And if any one else reads my comment and has already taken the exam, please let us know your experience. Was it as difficult as the 3rd practice exam?
Thank you for putting this course together. I’ve learned so much.
Hi Tina,
I have taken the CA exam in June 2020. Based on my personal experience, the difficulty of hands on questions in the real text is between practice exam 1/2 and 3 while the knowledge based ones are closer to 3 as you need to use google to find the answer in most cases.
Thanks,
Iris
For question 10, why should we use join rather than blending the two data sources? The two sources are at different levels of detail. Thanks.
Hi
You use joins when you mainly want to add additional info to each row and you use blending when you want to use different dimensions/measures that are not corresponding with each data points at a one-on-one level.
Thanks
Iris
For question 15, you have October 2017 highlighted in the picture, but the answer on the practice exam says October 2016. Your screenshot is correct, but the exam answer of “October 2016” does not appear to be correct. Check please?
Thanks for all the help!
Hi
I double checked the solution guide and “October 26” is highlighted in both picture and question text. Please see the caption of the highlighted point in the picture.
Thanks,
Iris
Hi,
Thank you for posting solution guide , pdf. I have a doubt in explanation of Question 20. Column has Year(Order date) and Row has Sum(Sales).
When hover mouse over trend-line, coefficient of Year of Order Date should say SUM of increase in sales per year right?
But explanation says ” The coefficient of Year of Order Date is the average increase in sales per year.”
I am trying to understand how does the coefficient says average as Row shelf has SUM(SALES) rather than average of sales
Hi
It does reflect the average increase. A simple example could be:
Assuming the function between Year(order date) and Sum(sales) is “Sum(sales)= A * Year(order date) + B”. In 2013, sales = 2013A+B and in 2014, sales = 2014A+B. Then the increase between the sales of 2013 and that of 2014 is 2014A + B – 2013A – B = A (the coefficient), which indicates average increase in sales per year.
Thanks,
Iris
Hi
in the question 2, what indicated you to use a blend to find the answer ?
thank you
Hi Eddy,
The 2 tables have a different level of granularity (Premium Target is at a car model level and Insurance Data is at a customer level), so a blend is necessary for finding the correct answer.
Hope this answer your question,
Narcis
Hello,
In one of the comments above, I read that google can be used to answer the knowledge based questions in the actual exam. Is that correct?
Thanks,
Shikha
Hi Shikha,
Yes, you can use google during the real exam. But keep in mind that you can only use google from the VM, not from your local machine and that you can waste a lot of time searching for answers.
Best regards,
Narcis
Hello! Happy New Year!
For question 8, the question says “Determine the number of days from the order date to the ship date for each Row ID. ” In this case, why don’t we use Fixed [Row ID]? Can you please explain? Thank you in advance!
Hello Ed and Happy New Year!!
You can also use a fixed calculation like – {FIXED [Row ID]: AVG(DATEDIFF(“day”,[Order Date],[Ship Date]))}, and we would get to the correct answer. But in this scenario we are adding unnecessary complexity to the calculations without reducing the number of steps required to find the answer.
Hope this helps,
Narcis
For Q2: Is it okay to use relationships instead of blending ?
Hi Madhurima,
Relationships were introduced in the version 2020.2 and currently the exam is taken on the version 2020.1 . So you need to know blending very well since in the real exam you won’t have the possibility to use relationships.
In the next couple of months the exam will probably switch to a newer version that will include relationships, but until then you would have to use blends and joins.
Hope this helps,
Narcis
I just passed my CA exam with 89% score today. Thank you Learning Tableau for having these extremely useful mock exams along with frequent email updates on some important topics (eg. LOD practice questions). Based on my exam experience today, my questions are easier than some mock questions and there are no complicated calculation questions. But Learning Tableau gives me confidence during the exam as I know I have practiced as many complicated questions as I can on Learning Tableau. Thanks again!
Exam 3 Q3 – I am unsure why I have different answer. I calculated 2018 average Deduction as 1350.44 and 2019 as 1438.92 based on Deductible and 2019 Deductible respectively. These values being the basis for % increase calculation. My final % increase being 6.14 Solution listed a different 2018 average discount value and but same 2019 average discount as mine and thus calculated a different result to mine. Any ideas why I’m getting different answer?
3. Combine the Insurance Data and the 2019 data. What was the % increase in average annual deductible from 2018 to 2019 for cars made by Toyota?
Hi Nicolas,
The average deduction for 2019 for Toyota is wrong in your calculation, this is why you do not have the same answer. It looks like you haven’t filtered on Toyota on your calculation, check that and after this, you should have the correct answer 🙂
Thank you,
Narcis
Just passed the exam on 1/23/2021, thanks to this course. Please do not freak out on the Exam/Practice 3, the real exam is easier but use it as a reference to cover your knowledge gap.
Congrats & thanks Clara!
Hi Guys,
Q10:
Help me understand why the use of left join?
I used the Inner join and found the same answer.
Q5:
thanks for this method, it helped me understand more.
there is also another way to get the same answer :
-Bring Share to the view and filter out the Null.
-then group “2,3,4” since it is shared.
-Bring the “Number of Records per prizes” to text.
we use this because according to the number of records for a prize,
it indicates whether shared or not.
-add the table calculation Percent of total, you will get the answer.
Q15:
November 2016 also follows the same pattern,
Negative Profit and positive sales
Why did you pick October?
Q36:
can you please tell me why do you take “2019 Data (count)” do determine the number of policies ?
Tanks
Hello Eddy,
Most of the questions in Tableau can be solved in different methods (similar to math where you can get to the same result in different ways). Q10 – indeed, if you use inner join you will get the same answer, I guess left join was used out of habit ( it’s used more because it doesn’t exclude rows from your table of interest which is usually the left one ).
Q15 – In November, Sales and Profit increased vs the previous month while in October Sales increased vs previous month and Profit decreased vs previous month.
Q36 – each row in the 2019 Data table represents a policy, so using the auto-generated field 2019 Data (count) is the easiest way to count the number of policies.
Hope this helps,
Narcis
Question 2 is not worded correctly
“.Which model of Acura had the an average annual premium the closest to the targeted premium?”
would perhaps be better to word the question
“Which model of Acura had the an average annual premium the closest to the average targeted premium?”
Hello,
Question 16 solution is not correct. The question asks which has an average around $1800 but in your solutions file there is a typo that says $1700 . It is bin 200 which is fine at $1773
I was cruising through these 3 exams but did not pass the actual exam I got a 70% so I was fairly close. I think I may have been flustered on browser we needed to use on the actual exam. I also felt that the knowledge based questions on the real exam were much more difficult. I did well on the hands on questions during the exam but I do not know exactly what I missed. Does anyone have any recommendations on retaking the exam?
Hi John,
One tip is to try to use Tableau as much as you can in the exam, even for knowledge-based questions – try each available option to find the correct one.
Practice as much as you can with different datasets, you can find on sites like https://www.makeovermonday.co.uk/. There you can find also reports created by other users, you can download them and see how they are created.
Hope this helps,
Narcis
Hi,
Can someone please explain Q34 solution? How can I change longitude /latitude generated to AVG?
Thanks,
Zinnia
Hello,
You must use the longitude and latitude fields from the dataset, not the autogenerated ones. You will be able to change the dataset fields to AVG.
Hope this helps,
Narcis
There seems to be a problem with question 8 in that the question doesn’t make it clear with whom the comparison is made. If you compare it to Same day, it is indeed Same day vs First Class that has the biggest difference, when if you change the base to something else, then the number of days of difference changes with it.
Hi Feng,
I am afraid I don’t understand what you mean. There are 4 options available to answer and the question asks which one of the options available has the biggest difference – from those options the correct one is Same day vs First Class. Not sure how can we change the base to something else, the difference is between Order Date and Ship Date.
Keep in mind that these kind of questions were we have to choose from the options provided, not necessarily from the entire dataset are quite common in the real exam.
Hope this makes it clear.
Narcis
Q9:
Unable to re create Lukas’ answer. Can someone help. I have the same calculated fields and same fields in the view but i do not get the same view. please help.
Hi Johan,
At the end of the exam you will find a link to the solution pdf for all questions with explanations. Basically for this question you should Purchases by Customer calculated field using LOD Fixed function ({FIXED [Customer ID] : countd(Order ID)}) , Customer’s firs order year ({FIXED [Customer ID]: min([Order Year)}) and the unique count of customers (countd([Customer ID])).
Hope this helps,
Narcis