🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Counting Changed status

User: "cclark53"
New Altair Community Member
Updated by Jocelyn
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>


Find more posts tagged with

Sort by:
1 - 3 of 31
    User: "Caperez"
    Altair Community Member
    Hi @cclark53,

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

    Best, 

    Cesar

    User: "cclark53"
    New Altair Community Member
    OP
    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. 
    User: "Caperez"
    Altair Community Member
    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