summary number
Hi,
I'm very new to DOMO and can't figure out this summary number right....
I have no idea where the summary number 15.0% comes from.
If I select only one campaign_name, then summary number is correct but when selecting more than one campaign_name, the number looks really odd.
I noticed under filed&function, there is no second drop down to choose aggregation. How can I get that drop down?
Can anyone help to have a look?
Best Answer
-
This would be easier to explain if I could see some of the data behind the calculations.
Can you add a total row under the chart properties? Then add the total open and total click fields to the table.
That should show you how the summary number is getting it's value
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
Answers
-
In this case, you are using a calculated field to display your summary number. The aggregation is then happening withing that calculated field statement. Presumably CTR / Open Rate which are also two calculated fields.
Would you mind sharing the code for the CTO beastmode along with what your desired summary calculation should equal given the tata shown in the image you shared?
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
If you want to sum the individual CTO's for each campaign, I would recommend a different beastmode.
try creating a CTO Summary field
sum((`total_click` / `total_open`))
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
I tried your suggession but the result of CTO is not correct.
Because each campaign has multiple rows so with your formula, each CTO is considered as an individual campaign.
Is there a way to aggregate total_open and total_click. I tried sum(total_open) but gives the same number as total_open.
0 -
I think I should back up and explain what your original beastmode was doing when you used it as a summary number. It was adding up all of clicks (for every campaign) and dividing that by the total opens (for every campaign). This would mean that you are not getting a sum of each campaigns individual CTO, but rather an overall CTO for all campaigns.
sum(total_click) / sum(total_open)
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
I'm looking for an overall campaign CTO. But where does the summary number come from
0 -
This would be easier to explain if I could see some of the data behind the calculations.
Can you add a total row under the chart properties? Then add the total open and total click fields to the table.
That should show you how the summary number is getting it's value
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
Ah ha!
That explains everything.
Thank you so much!
2
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive