Chart Type

Reply
Highlighted
Yellow Belt

Chart Type

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


Accepted Solutions
Highlighted
Yellow Belt

Re: Chart Type

I found that the Transpose option on the Table Chart Type met my needs.  Thanks for the advice

View solution in original post


All Replies
Highlighted
Black Belt

Re: Chart Type

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.




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**
Highlighted
Yellow Belt

Re: Chart Type

I tired the Pivot Table but defaults to Count Aggregation for non-numerical fields like Address or State.  Do you have any other suggestions?

Highlighted
Major Red Belt

Re: Chart Type

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 heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Build a profit in loss statement in #Domo using out of the box features. "Is there any option or way to add a row heading and a blank row in pivot table." ##...
Highlighted
Yellow Belt

Re: Chart Type

I found that the Transpose option on the Table Chart Type met my needs.  Thanks for the advice

View solution in original post

Announcements
Stand out in the Dojo: Choose your own recognizable username and add a unique profile photo in your profile settings.