Counting Changed status
Hi Team, First time poster.
I'd like to count the number of individual examples that changed status over time.
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.
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
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.
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.
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
An useful operator for this is the Aggregate Operator.
please find attached and simple example with your data.
Best,
Cesar