Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I would like to show the percentages for each of the dimension values instead of the sheer values. How can I do this in this chart?
Here an excerpt of the data
| Risorsa | Conformità | Risorsa |
| User1 | Conforme | 100 |
| User1 | Non Conforme | 48 |
| User2 | Conforme | 3 |
| User2 | Non Conforme | 1 |
| User3 | Conforme | 47 |
| User3 | Non Conforme | 40 |
| User4 | Conforme | 105 |
| User4 | Non Conforme | 13 |
Hello,
Does this measure meet your needs?
Sum(Risorsa)/sum(total Risorsa)
Please see attached.
Mark the solution as accepted that solved your problem and if you found it useful, press the like button! Check out my YouTube Channel | Follow me on LinkedIn
@JandreKillianRIC hello, thanks a lot for your help.
For some reasons, I can't import the .qvf into my QMC. I am afraid it's because my company doesn't allow external qvfs. Could you kindly point me to the resolution?
Conforme
Sum({<[Conformità] = {'Conforme'}>} Risorsa2)
/
Sum(Total Risorsa2)
Non Conforme
Sum({<[Conformità] = {'Non Conforme'}>} Risorsa2)/
Sum(Total Risorsa2)
And then on the Presentation Tab
Regards - Jandre
Mark the solution as accepted that solved your problem and if you found it useful, press the like button! Check out my YouTube Channel | Follow me on LinkedIn