Running into a issue with a field aggregation in domo table visual

Utz
Utz Member
in Cards, Dashboards, Stories

Hi I am running into a weird issue in domo table I have multiple metrics inside the table two of the metrics need to be at no aggregation since it is a price and an average of the landed cost, but the rest of the fields need to be summed. Issue I am running into is the first field, which is webretailprice, when that is switched from sum to no aggregation, all fields remain as they are summed up when I switch average landed cost to no aggregation, which is a beast mode calculation "(COGSDollars/(QtyMarketingForecast - QtyCancel - QtySoldout))" It changes all of the metrics to no aggregation

Here are the fields before switching average landed cost to no aggregation

image.png

Switching to no aggregation for average landed cost

image.png

After Switching to No Aggregation:

image.png
Tagged:

Best Answer

  • MichelleH
    MichelleH Coach
    Answer ✓

    @Utz This is pretty common, since switching a field to No Aggregation is the equivalent of moving that field to the Group By clause (i.e. all other fields must be grouped by each unique value of that field).

    To resolve this, you will need to update your beast mode so that each individual field in the calculation uses the same aggregation that it is in the card. For example, if all of your fields are being summed in the card, then your beast mode should look like this:

    sum(`COGSDollars`)/(sum(`QtyMarketingForecast`) - sum(`QtyCancel`) - sum(`QtySoldOut`))

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓

    @Utz This is pretty common, since switching a field to No Aggregation is the equivalent of moving that field to the Group By clause (i.e. all other fields must be grouped by each unique value of that field).

    To resolve this, you will need to update your beast mode so that each individual field in the calculation uses the same aggregation that it is in the card. For example, if all of your fields are being summed in the card, then your beast mode should look like this:

    sum(`COGSDollars`)/(sum(`QtyMarketingForecast`) - sum(`QtyCancel`) - sum(`QtySoldOut`))
  • Utz
    Utz Member

    Thank you @MichelleH this worked I appreciate your quick response and help!

Categories