Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Summing and Averaging By Matrix Level

Hello. Working in different levels of a matrix. The levels are Date->Hour->City->Locations. City names are blocked out in red. I am trying to sum all the values of the locations level so that the ci...
Need Help
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    Anonymous 

    Hello, 

     

    use isinscope ()  function..

     

    and change the calculation depending on which level you are in the matrix. 

     

     

    NB :  when using isinscope start from the lowest level , check below .

     

    measure = 

    switch( 

    true() , 

    isinscope(location ) ,  -- your calcultion , 

    isinscope(cityt) ,  -- your calcultion , 

    isinscope(hour) ,  -- average 

    isinscope(date) ,  -- your calcultion , 

    ) 

     

     

     

     

    If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍

Daniel29195's avatar
Daniel29195
Icon for Community Champion rankCommunity Champion
2 years ago

Anonymous 

Hello, 

 

use isinscope ()  function..

 

and change the calculation depending on which level you are in the matrix. 

 

 

NB :  when using isinscope start from the lowest level , check below .

 

measure = 

switch( 

true() , 

isinscope(location ) ,  -- your calcultion , 

isinscope(cityt) ,  -- your calcultion , 

isinscope(hour) ,  -- average 

isinscope(date) ,  -- your calcultion , 

) 

 

 

 

 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍