Aggregating cells

  3 minute read  

It is possible to execute Mongo DB aggregation pipelines in the Data Miner app. The output from the aggregations can be in two formats - CSV and JSON.

Note
 CSV format is good for simple structures, while JSON can contain any structures.

Create pipeline

  1. Press the Add stage button.

    Add stage button
    Figure 1. Add stage button

  2. The new stage is displayed.

    New stage
    Figure 2. New stage

  3. Press Select stage to see the list of available operators.

    Select stage operator
    Figure 3. Select stage operator

  4. Every operator has a prepared stage body, which can be left as it is or changed.

    Stage body
    Figure 4. Stage body

    If the stage body is valid, a partial result is visible on the side. The result depends on the stage it belongs to and all the stages before.

    Stage body
    Figure 5. Stage body

Change the order of stages

Move up/down buttons become visible if there is more than 1 stage.

Move stage buttons
Figure 6. Move stage buttons

Enable and disable stage

Stages can be enabled or disabled using the Enabled button. Preview is displayed only if the stage is enabled and correct.

  1. To run only specific stages in the pipeline, press the Enabled button to enable the stage.

Enabled button
Figure 7. Enabled button

  1. As the stage is disabled, there is no partial result.

    Deactivated stages can still be edited, moved, or removed. All without influencing the pipeline.

New favorite Aggregations

Aggregation can be saved as a favorite one and loaded back later.

  1. Press the New favorite aggregation button.

    New favorite aggregation button
    Figure 8. New favorite aggregation button

  2. Pop up window asking about the name of the new favorite aggregation is displayed.

    Add favorite aggregation
    Figure 9. Add favorite aggregation

  3. Press the Add button to save aggregation as a favorite.

    Loaded favorite aggregation
    Figure 10. Loaded favorite aggregation

Save favorite aggregation

  1. Press the Save button to save changes in the aggregation.

    Save aggregation button
    Figure 11. Save aggregation button

Load favorite aggregation

  1. Press the name of the selected favorite aggregation to see a list of all saved favorite aggregations.

    List of favorite aggregations
    Figure 12. List of favorite aggregations

  2. Select aggregation to load.

Import aggregation

  1. Press the Import pipeline button to import aggregation.

    Import pipeline button
    Figure 13. Import pipeline button

  2. The Aggregation import window is opened, add inside the aggregation to upload.

    Aggregation import window
    Figure 14. Aggregation import window

  3. Press the Ok button to load aggregation.

Export aggregation

  1. To export aggregation press the Export aggregation button.

    Export aggregation button
    Figure 15. Export aggregation button

  2. The Aggregation export window is opened, with aggregation in text form.

    Aggregation export window
    Figure 16. Aggregation export window

Run aggregation

  1. Press the Run aggregation button.

    Run aggregation button
    Figure 17. Run the aggregation button

  2. Select output format.

    Output format
    Figure 18. Output format options

  3. The window with the result is displayed. Press the Download button to download the result.