topic Tracking changes over time in App Development

Tracking changes over time

florinaturlea — Tue, 03 Oct 2023 06:57:55 GMT

Hello,

I have the below example:

Object	Flag	Date
A	0	01.09.2023
A	1	02.09.2023
A	0	03.09.2023
A	0	04.09.2023
A	1	05.09.2023
B	0	01.09.2023
B	1	02.09.2023
B	0	03.09.2023
B	1	04.09.2023
C	1	01.09.2023
C	0	02.09.2023

This is just a subset of my data. I have a list of objects, each of them has a flag (1 or 0) that is changing over time. Following my business rules, the objects should change only once from 0 to 1.

But, in my data, I see objects A and B change 2 times.

For example: A's flag has set to 0 in 01.09.2023, changed to 1 in 02.09.2023, back to 0 in 03.09.2023 and then back to 1 in 05.09.2023. Same story with B, the change from 0 to 1 is happening twice.

Object C is ok, because the change from 0 to 1 is happening only once.

How can I search in this table and count the number of objects that are changing 2 times?

Thank you!

Re: Tracking changes over time

vincent_ardiet_ — Tue, 03 Oct 2023 15:09:20 GMT

You want to do this identification in a script or in chart?

Re: Tracking changes over time

florinaturlea — Wed, 04 Oct 2023 06:06:21 GMT

Hi! Ideally, in a chart.

Re: Tracking changes over time

vincent_ardiet_ — Wed, 04 Oct 2023 07:21:56 GMT

If can create a table with "Object" as dimension.
And then an expression like this:

=If( Min({<Flag={1}>Date)<>Max({<Flag={1}>Date) And Max({<Flag={0}>Date)> Min({<Flag={1}>Date) And Min({<Flag={0}>Date)< Max({<Flag={1}>Date) ,'Multiple changes' ,'Single change')

Re: Tracking changes over time

florinaturlea — Thu, 19 Oct 2023 07:54:57 GMT

Many thanks!!!