KPI Count and Week Expression

[Mgi]

Hello, I need help.

I've been trying different expressions but I can't find the correct one.

On one hand I want to count the "Subscription count" until previous month.
Fields:

Date   and Subscription Count

and on the other hand I want to calculate the revenue until last week.

Date  and   Amount.

Thank you in advance!

[vinieme12]

can you provide some sample data and the more information on expected output

[Mgi]

Sure,

I solved one issue, But I can't find the correct one for the following topic:

 I want to define a KPI with the sum "Transaction_Amount" of the latest 7 days:

and also, compare this against the week before.

DS_Date	numMonth	Month	Transaction_Amount
17/2/21	2	Feb	102,88
19/2/21	2	Feb	-0,52
26/2/21	2	Feb	102,25
28/2/21	2	Feb	102,52
1/3/21	3	Mar	-102,88
3/3/21	3	Mar	-0,53
9/3/21	3	Mar	583,06
11/3/21	3	Mar	-2,97
17/3/21	3	Mar	104,49
19/3/21	3	Mar	-0,53
24/3/21	3	Mar	62,6
26/3/21	3	Mar	105,29
28/3/21	3	Mar	-0,54
29/3/21	3	Mar	987,78
31/3/21	3	Mar	-5,04
5/4/21	4	Apr	63,06
7/4/21	4	Apr	-0,32
13/4/21	4	Apr	62,34
15/4/21	4	Apr	-0,32
16/4/21	4	Apr	1238,36
17/4/21	4	Apr	103,82
19/4/21	4	Apr	-6,32
20/4/21	4	Apr	73,96
21/4/21	4	Apr	61,75
22/4/21	4	Apr	103,78
23/4/21	4	Apr	-0,7
24/4/21	4	Apr	60,75
26/4/21	4	Apr	102,63
28/4/21	4	Apr	676,6
29/4/21	4	Apr	102,54
30/4/21	4	Apr	-3,45
1/5/21	5	May	-0,52