HI All,
I am trying to calculate user retention rate month on month.
I want to calculate Perc Column in Qliksense table
Formula for Perc is Measure1(Jan)/Measure1(Jan) for jan and for Feb Measure1(feb)/Measure1(Jan) and for march will be measure1(Mar)/measure1(Jan) and so on.
| |
Jan |
Feb |
| |
measure1 |
Perc |
measure1 |
Perc |
| 01-01-2024 |
250 |
100 |
30 |
0.12 |
| 01-02-2024 |
120 |
100 |
90 |
0.9 |
| 01-03-2024 |
250 |
100 |
30 |
0.12 |
Data in Table:
| Date |
Month |
Users |
Perc |
| 01-01-2024 |
jan |
250 |
250/250 |
| 01-01-2024 |
Feb |
30 |
30/250 |
| 01-01-2024 |
mar |
25 |
25/250 |
| 01-01-2024 |
apr |
20 |
20/250 |
| 01-02-2024 |
jan |
120 |
120/120 |
| 01-02-2024 |
feb |
90 |
90/120 |
| 01-02-2024 |
mar |
30 |
30/120 |
| 01-02-2024 |
apr |
10 |
10/120 |
| 01-03-2024 |
Jan |
250 |
250/250 |
| 01-03-2024 |
Feb |
30 |
30/250 |
| 01-03-2024 |
Mar |
20 |
20/250 |
Can someone please help me on this.
Thanks in Advance
