Track Data

[#1]

Hi Everyone

I have a question about Data tracking.

For Example

ID, RLD, date

1, 99, 01.03.2015

2, 18, 01.03.2015

3, 15, 01.03.2015

4, 25, 01.03.2015

I have a limit by 18 at the RLD for all ID's.

I like to track the data how long they stay under 18 or 18 RLD.

explanation: if a ID under 18 RLD - a person have to do something and after that the RLD change and I like to track the id until they change their data.

I hope some can help me.

sorry about my English.

THAAANKs:)

[jonathandienst]

A little more representative data and some expected results may help to clarify your requirement.

Are you getting a date range from your data source?

Do you want to track the RLD by ID?

What exactly do you mean by "track"? For example, "show all the IDs where RLD<=18 with the duration that RLD was <=18"

[swuehl]

I agree that's it not 100% clear what you expect.

Maybe something like this?

LOAD *,

          if(RLD <= 18, rangesum(1,peek(Track)),0) as Track

INLINE [

ID, RLD, date

1, 99, 01.03.2015

2, 18, 01.03.2015

3, 15, 01.03.2015

4, 25, 01.03.2015

];

[#4]

thanks for the answers.

But if the RLD change from 15 to 55. the track value change also ? I like to see how long they under 18. also if they change the RLD value.

or something like if the value from RLD change. which date it is.

someone can understand me

tanks for your answers!!!

[swuehl]

Fabian,

given your above table, what outcome do you expect to see? Could you post a table like you want to have as result?

[#6]

Inline [

ID, RLD, date, track, datachange

1,99,01.03.2015, 0, 01.02.2015 --> because the value was under 18 but it change to 99 on 01.02.2015 

2,18,01.03.2015, 1, no

3,15,01.03.2015, 2, no

4,25,01.03.2015, 0, 01.01.2015 ---> from value under 18 to 25 for example

];

[swuehl]

Ok, but where do the datachange values come from? I can't see 1.2.2015 resp. 1.1.2015 in your original table, date field.

[#8]

there change the data from a other system/tool. I took only the data from the databank.

hm.

is this possible to see when there change their data? 

[swuehl]

Sorry, I don't fully understand.

Maybe you want to ask the question in german?

If your database holds more information you want to show in QV, you should LOAD these fields, too.

[#10]

you can understand german ??