Align Block Exercise - Values aren't adding up right?

Question

Hi. I just finished the Align Block Dimensions for Formula Operations exercise. In the final table, we are to add the four metrics we created. No problem. But, when I look at the table my bonus metric does not match the “solution”. When I check the data, it adds up correctly to year and the formulas match. Any suggestions? Same formula. Did I miss a stop in the course? I didn’t see any instructions on how to build this table, so i’m kind of winging it.

Here’s my result:

Here’s the solution:

icon

Best answer by CDALMAY 6 June 2024, 21:00

View original

CDALMAY · Accepted Answer

Hi @Jared Dolich,I’m assuming this is because of a dimensionality issue as you can see with the yellow icon.When summing metric you should make sure the dimensionality is matching and otherwise add some modifier to remove/add/aggregate some dimensions.Can you share what is the dimensionissue for those metrics ?

CDALMAY · Answer

Glad that was able to fix it.Maybe because when you created the Special Bonus metric, you included both Year and Month. Thus your metric had Year and Month.For modeling, you will rarely have the need to include 2 time dimension in a metric as Year can be inherited from Month in thiscase. This will cause over dimensionalissues.For instance you will have a combination of FY24 with Mar-22 which rarely makes sense.