Manipulating Tracking Data

Question

Hi&nbsp;I have a table like the one below:&nbsp;ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Status1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Old1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Started1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; New2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Started2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; New3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; New4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Old4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Partially Done4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; New&nbsp;Basically what I want to be able to do is to see which IDs passed through the status 'Started' and are now at 'New'So in my case, ID 1 and 2 would fit that criteria.&nbsp;I can't find the right query to do this, I can only find the previous status but I need to look through all historical statuses.&nbsp;Any guidance would be much appreciated.&nbsp;ThanksVictoria&nbsp;&nbsp;

pragati11 · Accepted Answer

HI&nbsp;Anonymous&nbsp;,&nbsp;As you haven't mentioned the desired output, I have created a measure as follows to identify the IDs in the data which have "New" and "Started" as their statuses:&nbsp;1. GREEN highlight - This is the sample data used2. RED highlight - This shows a table with "testCheck" measure using which it only displays the IDs with "New" and "Started" statuses3. BLUE highlight - Measure created to achieve this.&nbsp;If this helps and works please give a Kudos and mark this as a solutions! 🙂&nbsp;Thanks,Pragati

Forum Discussion

Manipulating Tracking Data

2 Replies

Related content

Manipulate Data

Stored Procedure to Manipulate Tables

Tracking data changes

Basic manipulation of data from events

Data manipulation