My beast mode is not calculating correctly
SUM(SUM(BILLABLE_ORDERS
) FIXED (add COUNTRY_NAME
)) / SUM(SUM(ATTEMPTED_TXNS
+VOUCHER_TXNS
) FIXED (add COUNTRY_NAME
))
It should be 0.82
Below is an extract of the data
Best Answers
-
Any reason why you're using FIXED (add
field
) ? If you would explain what you're trying to calculate in words that could help but if the idea is to do the total of the Billable Orders divided the total sum of Attempted__txns plus Voucher_txns and calculating this at whatever level your card is displaying using just:SUM(`BILLABLE_ORDERS`)/SUM(COALESCE(`ATTEMPTED_TXNS`,0)+COALSECE(`VOUCHER_TXNS`,0))
In most cases, you will use FIXED when you want the calculation to be performed at a different level than the one used for the card (like you want to show global average next to the value for each country). Coalesce is just being added to ensure it either of the two values is null that we use 0 instead.
1 -
Your numerator appears to be totaling the billable orders by country. Over the total of attempted transactions and voucher transactions by country. The use of "FIXED" seems redundant. What happens if you simply to something like SUM(BILLABLE_ORDERS)/SUM(ATTEMPTED_TXNS + VOUCHER_TXNS)?
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1
Answers
-
Any reason why you're using FIXED (add
field
) ? If you would explain what you're trying to calculate in words that could help but if the idea is to do the total of the Billable Orders divided the total sum of Attempted__txns plus Voucher_txns and calculating this at whatever level your card is displaying using just:SUM(`BILLABLE_ORDERS`)/SUM(COALESCE(`ATTEMPTED_TXNS`,0)+COALSECE(`VOUCHER_TXNS`,0))
In most cases, you will use FIXED when you want the calculation to be performed at a different level than the one used for the card (like you want to show global average next to the value for each country). Coalesce is just being added to ensure it either of the two values is null that we use 0 instead.
1 -
Your numerator appears to be totaling the billable orders by country. Over the total of attempted transactions and voucher transactions by country. The use of "FIXED" seems redundant. What happens if you simply to something like SUM(BILLABLE_ORDERS)/SUM(ATTEMPTED_TXNS + VOUCHER_TXNS)?
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive