Calculated column problem

[HKTran]

First time I've been messed with this unknown error, I create a calculated column to get Week number from 1st Jan. And boom, visual displays the same data on two rows/columns/bars... The new column have 53 distinct values means that there is no thing goes wrong with values trimming or whatever. So why did it turn out this way?

I did try few options like Quotient(day, 7) or divide/int, etc. but no thing works.

Any one can help me with this problem?

[Anonymous]

Hi @HKTran ,

I don't quite understand what you mean, is there a detailed error message for the unknown error you are referring to? Can you show the output you expected?

Best Regards,
Community Support Team _ Caitlyn

[HKTran]

Hi @Anonymous 

I did request a ticket and Ms Support has reached me. I'm waiting for their detail explain though.

It's seem like a bug to me, an appropriate report should look like this, but I got a duplicate per Week as you can see in my post. Me and Ms Support had tried a few options and there is one can work is that I delete another Week calculated column (I have 3 others), and then re-created it again, works like a magic cause no one know what is the problem here 😂