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.7K All Categories
 1 APAC User Group
 12 Welcome
 36 Domo News
 9.6K Using Domo
 1.9K Dataflows
 2.4K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 339 Workbench
 252 Domo Best Practices
 11 Domo Certification
 461 Domo Developer
 47 Domo Everywhere
 101 Apps
 705 New to Domo
 84 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 23 お知らせ
 63 Kowaza
 297 仲間に相談
 649 ひらめき共有