Counting Changed status

cclark53

Hi Team, First time poster. 

 I'd like to count the number of individual examples that changed status over time. 

9440370	8/1/2022	Scheduled
3709785	8/1/2022	In Review

9440370	8/8/2022	In Review
3709785	8/8/2022	In Review

Here one example #9440370 changed from scheduled to in review between 8/1 and 8/8 (when the data was pulled). Data set will have upwards of 10,000 examples and 6 different statuses.

<?xml version="1.0" encoding="UTF-8"?><process version="9.10.011">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="9.10.011" expanded="true" name="Process">
    <parameter key="logverbosity" value="init"/>
    <parameter key="random_seed" value="2001"/>
    <parameter key="send_mail" value="never"/>
    <parameter key="notification_email" value=""/>
    <parameter key="process_duration_for_mail" value="30"/>
    <parameter key="encoding" value="SYSTEM"/>
    <process expanded="true">
      <operator activated="true" class="retrieve" compatibility="9.10.011" expanded="true" height="68" name="Retrieve Copy of Medical Evaluations Data Analytics" width="90" x="45" y="85">
        <parameter key="repository_entry" value="//Local Repository/data/Copy of Medical Evaluations Data Analytics"/>
      </operator>
      <connect from_op="Retrieve Copy of Medical Evaluations Data Analytics" from_port="output" to_port="result 1"/>
      <portSpacing port="source_input 1" spacing="0"/>
      <portSpacing port="sink_result 1" spacing="0"/>
      <portSpacing port="sink_result 2" spacing="0"/>
    </process>
  </operator>
</process>

ceaperez

Hi @cclark53,

An useful operator for this is the Aggregate Operator. 
please find attached and simple example with your data. 

Best, 

Cesar

cclark53

Hi @ceaperez thanks for the response. I've played around with the aggregate operator but I couldn't quite get it to return the numbers I was expecting. 

I made a new sheet in the attached work book to show what I'm after, see rows 10, 12, and 14 in the conversion rates sheet. 

I'm interested in the quantity of unique ID numbers that changed status from one report date to another. 

ceaperez

Hi @cclark53, 

Due to the data corresponding of a specific report period is not clear, at least in your dataset, you can create a new attribute to assign the examples to a specific report period by this way you can use the new attribute as a parameter for aggregation. 

please find attached a simple example. 

Best