Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Matrix - Calculation inside a matrix

I'm not sure how to explain my request clairly but I will try me best. I have to make this matrix - let's say on a User Table to simplify - On this table I have the subscription date (User[sub_dat...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous ,

    Your "date_inscription is a Date Hierarchy ? If yes can you show me how it's made please ? 

     

    I used measures too, not calculated columns for "Inscrites Valides" and "avec Campagnes", I wanted to have the same model as yours to make something similar, and theyre made like the two you sent me earlier. I just displayed them in the table so its clearer to you. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Now I would like to have the same matrix but the value should be the number I got in a cell, divided by the total number of "valid User" (all user but with some filter, measure that I already made). I though about doing a simple measure like and put it as the value of the matrix :

 
Ratio actives / valides = DIVIDE(
    User[with Paiement],
    User[Valide]
)
 
But I just get 100% everywhere.
 
But If I put this measure as it is as a simply card I got the right number I was wainting for the whole set of data (I have a date slicer on this page).
 
A colleague did what we are trying to do with excel.
 
2019
Mois d'inscription de l'association
JanvierFévrierMarsAvrilMaiJuinJuilletaoûtsept.oct.nov.déc.
Assos inscrites298824673637398838803243141     
Assos actives
131411221323115610254883     
 44%45%36%29%26%15%     
Assos inactives167413452314283228552755      
             
Assos qui s'activent entre :            
J+0 - J+14
669532730647684292      
 22%20%20%16%18%9%     
J+15 - J+30
2572472512522558      
 9%10%7%6%7%0%     
J+31 - J+45
1339713313376       
 4%4%4%3%2%      
J+46 et +
2552462091240       
 9%10%6%3%0%      


The % (what I'm trying to get in my matrix) is the division of the number just upper by the total of User sub you can read on each columns.

 

For Febuary (Fevrier) J0 -J14 is 22% because it's 669/2988.

 

Hope is clear enough.