Chart Type
Best Answer
-
I found that the Transpose option on the Table Chart Type met my needs. Thanks for the advice
0
Answers
-
I would suggest the pivot table card so that you can get it in the layout you want. I would also make Building Number a quick filter and then click on the wheel cog of that quick filter and choose Single Select, so that they can only choose one building at a time.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
I tired the Pivot Table but defaults to Count Aggregation for non-numerical fields like Address or State. Do you have any other suggestions?
0 -
I assume in your raw data you have one row per building and then the metrics going across in columns.
If that's the case then you need o collapse the metrics such that your end result is one row per building per metric. (use the collapse columns MagicETL tile).
Then you can pivot as @MarkSnodgrass where Metric is in Rows and the Value is the Metric Amount.
One of the challenges though is the the Metric Amount column will want all the data in the column to be of the same data type. So if one Metric is measured as an Integer, and another metric is text, percent, or decimal, getting the proper formatting might be tough.
@user045611 wrote:Hi,
I am trying to build a card that mimics an Excel report (See attached). User could select 1 and (only 1) building number from a Filter, and the data would populate accordingly. What is the right chart type to achieve this?
TIA
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
I found that the Transpose option on the Table Chart Type met my needs. Thanks for the advice
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive