Monthwise change in app usage

[sujayrpatil]

Hi,

I have a scenario where in I have to compare usage of each app  for each month compared to its previous month.

sample data is as in below image.

Requirement is to show the usage trend of each app month wise in a Line graph.

calculation logic : For example for month Feb 2020, For App XYZ,  we have to count userid for Feb - count userid for Jan and then divide by userid count for Jan.

Using the data in the above image : Feb 2020, For App XYZ it will be (265-237)/237 = 0.118 .

Hoping for your responses.

Br,
sujay.

[stevedark]

This application shows a number of prior period comparisons that you can use:

https://community.qlik.com/t5/Qlik-Sense-Documents-Videos/Qlik-Sense-App-Prior-Period-Comparison-wit...

Hope that's helpful.