Percent of total line chart
Is there an easy way to graph percent of total on a line chart rather than the individual values?
It seems like it shouldn't be too difficult but I don't see an option.
Comments
-
Yes there is, in your chart, go to Chart Properties -> Data Label Settings -> Click the plus sign on Text to reveal a list -> Click on %_PERCENT_OF_TOTAL
4 -
That simply changes the label. It does not appear to have an impact on the values in the chart. As you can see in the image, the scale on the left is not percent of total.
0 -
You need to make sure the "window functions in beast modes" is enabled in your instance. Your CSM can get it enabled for you if it is not. You can then do something like this, changing the name of the field to yours:
sum(amount) / sum(sum(amount))
You can watch this video for a good walkthrough about it.
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
@MarkSnodgrass if I am graphing
count(id)
over time, how would I change your formula?0 -
Dealing with counts is a little different. Try this:
SUM(SUM(1)) OVER (PARTITION BY `id`) / SUM(SUM(1)) OVER ()
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Hmm... Doesn't seem to be working. It seems bizarre that this is difficult.
0 -
SUM(1) / SUM(SUM(1)) OVER ()
SUM(1) will get you the total number of within the grouping defined on your card.
SUM(SUM(1)) OVER ()
This returns the total for your entire dataset after filtering has been applied.
This version is simply counting the number of rows for each group and the total number of rows across the entire dataset. If you care about just counting IDs (if it may be null sometimes) you can do something like:
COUNT(`id`) / SUM(COUNT(`id`)) OVER ()
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**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
- 344 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 467 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 654 ひらめき共有