Counting Changed status

cclark53cclark53 Member Posts: 2 Learner I
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>


Answers

  • ceaperezceaperez Member Posts: 346 Unicorn
    Hi @cclark53,

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

    Best, 

    Cesar

  • cclark53cclark53 Member Posts: 2 Learner I
    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. 
  • ceaperezceaperez Member Posts: 346 Unicorn
    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
Sign In or Register to comment.