Forum Discussion
Problem with granularity
Hello everyone! I have a problem that I cannot figure out how to solve. Let's say I need to compute the difference between my theoretical rate and my real rate. Therefore I have a table for my ...
Do you have a target result which you can provide here?
Difficult to understand just seeing at your Screenshot and a bit discription.
What is your expected goal?
Hi sergej_og
This is my expected output. Imagine the top part are the slicers options.
If I do things just for a center (no selectors) I can achieve it without any problem. The thing is that I have all centers in the same file (coded as 11A,11B, 12A...) and the date handicap, since theoretical rates can change from one month to another.
Also, as you can see granularity in the output is daily, but I only have theoretical rates within a date (the one in which is established).
It has been a headache for myself try to solve it.
Thank you for trying to help.