Knowledge Drop

Why are my week dimension rows duplicating when I have the month dimension selected?


Last tested; Feb 1, 2021
 

You may notice that when you select the week dimension and some other fields, your data looks alright!

Screen Shot 2021-02-01 at 12.17.16 PM.png

However, when you add in your month dimension, some of your week rows are duplicating!

Screen Shot 2021-02-01 at 12.19.22 PM.png

Why is this happening? In this case, we can see 2020-12-28 getting repeated. This is because this week starts in the month 2021-012 and ends in 2021-01. There are two of the same week values, but they're getting correlated to two different months, causing the duplication.

How can we fix it? We can add in a table calculation to extract the month. This will correlate the week to the month it starts in.

Screen Shot 2021-02-01 at 12.24.39 PM.png

Screen Shot 2021-02-01 at 12.23.56 PM.png

 

This content is subject to limited support.                

 

 


0 replies

Be the first to reply!

Reply