Filter and Count

In my Szenario i get via Personio API Data of a report. I have to filter out people that have gone in the current month. I put in an iterator for that.

i am getting this information for one person:

image

What i have to do is, if the value of “dynamic_11044633” is this month, than it can pass through, everything else should be blocked. And in the end i have to count how many people has gone through the filter.

Here is the code output of the iterater:

[
    {
        "employee_id": 14943390,
        "attributes": [
            {
                "attribute_id": "first_name",
                "data_type": "TEXT",
                "employee_id": 14943390,
                "value": "Nina"
            },
            {
                "attribute_id": "last_name",
                "data_type": "TEXT",
                "employee_id": 14943390,
                "value": "Mustermann"
            },
            {
                "attribute_id": "status",
                "data_type": "TEXT",
                "employee_id": 14943390,
                "value": "inactive"
            },
            {
                "attribute_id": "dynamic_11044633",
                "data_type": "DATE",
                "employee_id": 14943390,
                "value": "2024-06-24"
            },
            {
                "attribute_id": "dynamic_11044636",
                "data_type": "OPTION",
                "employee_id": 14943390,
                "value": "Arbeitnehmerseitig"
            }
        ],
        "__IMTINDEX__": 1,
        "__IMTLENGTH__": 2
    },
    {
        "employee_id": 19107872,
        "attributes": [
            {
                "attribute_id": "first_name",
                "data_type": "TEXT",
                "employee_id": 19107872,
                "value": "Julian"
            },
            {
                "attribute_id": "last_name",
                "data_type": "TEXT",
                "employee_id": 19107872,
                "value": "Mustermann"
            },
            {
                "attribute_id": "status",
                "data_type": "TEXT",
                "employee_id": 19107872,
                "value": "inactive"
            },
            {
                "attribute_id": "dynamic_11044633",
                "data_type": "DATE",
                "employee_id": 19107872,
                "value": "2024-04-22"
            },
            {
                "attribute_id": "dynamic_11044636",
                "data_type": "OPTION",
                "employee_id": 19107872,
                "value": "Arbeitnehmerseitig"
            }
        ],
        "__IMTINDEX__": 2,
        "__IMTLENGTH__": 2
    }
]


Hi @Kay_Dollt; a filter can check for the current month entries and use an aggregator to compile those folks. Afterwards, count your results.


Try out… blueprint.json (7.7 KB)

1 Like