Forum Discussion

mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
3 years ago

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 ...
Need Help
sergej_og's avatar
sergej_og
Icon for Super User rankSuper User
3 years ago

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?

  • mlsx4's avatar
    mlsx4
    Icon for Memorable Member rankMemorable Member
    3 years ago

    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.