Custom Metrics

Options
Yair
Yair Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 7

I'd like to generate a metric that reflects the sum of two columns:

sum(column1) + sum(column2)

Is there an option to achieve this in a 'no-code' environment, without having to use Python?

I attempted to use groupby, but it necessitated creating a column with identical values just for the groupby operation, and then choosing the sum for both columns. This feels overly complicated for a relatively straightforward task.

I was unable to find a way to perform this operation in the Metrics tab without coding.

I appreciate your assistance. Thanks.


Operating system used: Linux

Answers

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,728 Neuron
    edited July 17
    Options

    In the Group By recipe Group section uncheck "Compute Count for Each Group". Then select the checkbox for column1 and column2 but do not set any predefined aggregations. Finally in the Custom Aggregations section add this custom aggregation:

    Sum("column1") + Sum("column2")

    That should do it.

  • Yair
    Yair Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 7
    Options

    Ok, but what is the gorup key to group by? I want the sum to be on all the table, not on group from the table

    Thank you

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,728 Neuron
    Options

    If you don't group by anything then you get a single row back with the sum(). You need to decide at which level you want this sum to be. Otherwise it's not an aggregate sum() it's just column1 + column2.

  • Yair
    Yair Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 7
    Options

    I want to have Matric value of sum(column1) + sum(column2) and then add this Metric to dashboard.

    I know I dont need groupby, but I didnt find why to get this calculation for Metric without it..

    the "column1 + column2" will give me it pre row, but I need all the column sum + all other column sum

    Thank you

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,728 Neuron
    Options

    Then remove the Group Key after creating the Group By recipe and you will have a single row result. This is only allowed to do once you add a custom aggregation.

Setup Info
    Tags
      Help me…