Forum Discussion
Solved
c
Hi pva ,
Please do/answer the following:
- post a sample data that we can copy-paste
- how do you calculate the percentage?
- accumulation is based on what field (appears to be Day)?
- what is your expected result?
danextian thanks for your quick response
Sample
| idUser | Day |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 1 | 2 |
| 2 | 2 |
| 3 | 2 |
| 4 | 2 |
| 1 | |
| 2 | |
| 3 | |
| 4 |
Expected result
| Day | Users | % total | Cumulative |
| 1 | 4 | 33% | 33% |
| 2 | 4 | 33% | 66% |
Acumulation is based on "Days"
Thanks a lot
But how do you calculate the percentage?