Modifying a Summary Number
I have a column in my data sheet with values like 0.202321. I display the AVERAGE of those values but when I select the NUMBER FORMAT as PERCENTAGE in the SUMMARY NUMBER, I get something like 20.2% when in fact the percentage should looke like 0.20%.
How would you go about transforming these values? One idea I had was creating a new column using ETL.
Column X divided by 100
It seems odd that this is the correct solution.
Comments
-
What if you just created a calculated field and do
AVG(`column`) * 100
Then use that new columns as the summary value
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0 -
hi
0 -
That is interesting that there is not a "multiply by 100" checkbox in the summary number formatting section like there is when you use a field in the main card area. If that was offered, you could just uncheck that box. Since that isn't option, you should create a calculated field and create the formula like this:
AVG('ColumnX'/100)
You need to use an aggregate function like AVG for your newly created calculated field to show up in the list of fields when selecting a summary number. You could also use SUM, MIN, or MAX if those functions suit your needs better. Hope this helps.
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有