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>

Caperez

Hi @cclark53,

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

Best, 

Cesar

Count data.rmp