topic Re: count churn user in Data Movement & Streaming

count churn user

torraninboo — Wed, 19 Mar 2025 22:43:16 GMT

i want to count fid that include new user, same user ,churn user but i dont know how to count its

example my data and i want to made report like this

but i dont know how to count its can someone help me

PrashantSangle — Fri, 08 Dec 2023 09:54:30 GMT

where you want to do it??

Qlikview? QlikSense?

what is logic for New User? Same? Churn??

You have to provide more details for more accurate answer.

torraninboo — Fri, 08 Dec 2023 09:59:21 GMT

Oh sry I forgot ,I want to do in qliksense

logic

example month 202201,202202

if fid in monthyear 202202 but not in 202201 = new user

if fid in monthyear 202201 but not in 202202 = churn user

if fid in 202201 and 202202 = same user

PrashantSangle — Fri, 08 Dec 2023 10:51:30 GMT

understood. Can you provide some sample data?

sidhiq91 — Fri, 08 Dec 2023 13:07:44 GMT

@torraninboo Please provide some sample data?

torraninboo — Tue, 12 Dec 2023 06:35:11 GMT

example data and result

torraninboo — Wed, 13 Dec 2023 02:33:39 GMT

example data and result

torraninboo — Wed, 13 Dec 2023 02:33:55 GMT

example data and result