I have a week dimension and then I want to change it to 2 weeks and 4 weeks period.
Right now I grouped them manually but here's the issue I encountered: I want to transfer the chart into line chart but I cannot change the grouped dimension to discrete or contionous.
Or should I create a calculation filed for 2 weeks and 4 weeks period? I also wonder if there's a more efficient way to do this change.
I feel like a calculated field is your best bet. It's going to be dynamic as well to save you creating groups in the future.