I have a beginner’s question. I am not entirely sure I understand the difference between BY and ADD.
I understand both can be used to split the data into additional dimensions but not sure when I should use which. For example - I have data by Period and Account. For the purpose of dimensions alignment with other metrics, I need to add Channel and Country assuming the same values for Channel and Country per Period and Account. I know I can use BY or BY CONSTANT but what if I use ADD? What would be the difference?
Best answer by WILLIAM.MONTEROView original