Forum Discussion
Solved
cross calculation in matrix chart
Hello community, I ask you for help for a particular calculation, I have a table under the name f_evaluacion_diagnostico, in which I have 2 columns: evaluation_result and result_verification. In ...
Hi,
PBi file attached.
Hope this helps.
Hello lbendlin ,
Here I share some fictitious data so you can understand what I need, in the first column are the results of the initial evaluation and in the second column the results of the final evaluation, what I need is to put the results in rows and columns and count how many There is from the initial evaluation to the final one, as I show in the second table:
| diag_result | veri_result |
| INI | PROC |
| INI | LOG |
| LOG | INI |
| LOG | PROC |
| PROC | PROC |
| INI | INI |
| INI | INI |
| PROC | INI |
| LOG | LOG |
| LOG | LOG |
| LOG | PROC |
| INI | LOG |
| INI | INI |
| INI | INI |
| LOG | LOG |
| PROC | PROC |
| INI | LOG |
| LOG | PROC |
| LOG | INI |
| PROC | INI |
| INI | INI |
| PROC | PROC |
This is the table I want to have as a result:
| veri_result | |||
| diag_result | INI | PROC | LOG |
| INI | 5 | 1 | 3 |
| PROC | 2 | 3 | 0 |
| LOG | 2 | 3 | 3 |
Thanks for your help!
Regards!
DC
Ashish_Mathur
Super User
Super UserHi,
PBi file attached.
Hope this helps.