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.” -Superman
______________________________________________________________________________________________1
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.” -Superman
______________________________________________________________________________________________0 -
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.” -Superman
______________________________________________________________________________________________0 -
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.” -Superman
______________________________________________________________________________________________0 -
I'm looking for an overall campaign CTO. But where does the summary number come from
0 -
Ah ha!
That explains everything.
Thank you so much!
2
Categories
- 11K All Categories
- 5 Private Company Board
- 2 APAC User Group
- 12 Welcome
- 42 Domo News
- 9.9K Using Domo
- 2K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 349 Workbench
- 266 Domo Best Practices
- 11 Domo Certification
- 474 Domo Developer
- 51 Domo Everywhere
- 110 Apps
- 725 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 29 お知らせ
- 65 Kowaza
- 301 仲間に相談
- 662 ひらめき共有