Bar Graph Presentation
If P&L result is presented in a bar graph, how do I rearrange the bar to show the data in the following order: revenue, COGS, G&A, depreciation & amortization, other income & expenses, then Income taxes?
Comments
-
Hi tyeung, what type of bar chart is it? There are a couple ways you might sort based on the type of chart. However, it sounds like you need to specify the sort order, and you would do this in a beast mode like this:
CASE
WHEN `P&L BUCKET` = 'revenue' THEN 1
WHEN `P&L BUCKET` = 'COGS' THEN 2
WHEN `P&L BUCKET` = 'G&A' THEN 3
WHEN `P&L BUCKET` = 'depreciation & amortization' THEN 4
WHEN `P&L BUCKET` = 'other income & expenses' THEN 5
WHEN `P&L BUCKET` = 'Income taxes' THEN 6
END
Drop this is your card sorting settings area and set to ascending. Let me know if this works for you
0 -
I properly didn't use the command correctly. Therefore, the suggested sorting formula didn't work for me.
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 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有