# Visual type **URL:** \ **Category:** Q&A\ **Tags:** bar-chart, visuals, calculations, Business-Intelligence-Engineer, quick-sight\ **Created:** [September 13, 2023, 2:12pm UTC](https://community.amazonquick.com/t/visual-type/17992 "2023-09-13T14:12:41Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![pbehrani](https://avatars.discourse-cdn.com/v4/letter/p/e19adc/32.png) [@pbehrani](https://community.amazonquick.com/u/pbehrani)\ **Post date:** [September 13, 2023, 2:12pm UTC](https://community.amazonquick.com/t/visual-type/17992/1 "2023-09-13T14:12:41Z")
I have companies related data (Sample shown below): Company Associated Industries 3001 International Government , Information Technology , Software 9wood Architecture , Manufacturing There are hundreds of companies in the data set. I want to show metrics for number (or percentage) of companies associated with specific industries, like how many or what percentage of companies are associated with for instance, Software. What would be a good visual to show this information. I was thinking Pie chart, but the default functionality does not work very well for this type of representation. I would appreciate guidance. ---
**Author:** ![pbehrani](https://avatars.discourse-cdn.com/v4/letter/p/e19adc/32.png) [@pbehrani](https://community.amazonquick.com/u/pbehrani)\ **Post date:** [September 13, 2023, 2:14pm UTC](https://community.amazonquick.com/t/visual-type/17992/2 "2023-09-13T14:14:47Z")
The data fields should look like this: Company -----------------Associated Industries 3001 International ------Government , Information Technology , Software 9wood --------------------Architecture , Manufacturing Somehow spaces were collapsed in the original question ---
**Author:** ![Naveed](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/naveed/32/961_2.png) [@Naveed](https://community.amazonquick.com/u/Naveed)\ **Post date:** [September 14, 2023, 8:06am UTC](https://community.amazonquick.com/t/visual-type/17992/3 "2023-09-14T08:06:43Z")
Hi, You can use the vertical bar chart. regards, Naveed Ali ---
**Author:** ![pbehrani](https://avatars.discourse-cdn.com/v4/letter/p/e19adc/32.png) [@pbehrani](https://community.amazonquick.com/u/pbehrani)\ **Post date:** [September 14, 2023, 1:30pm UTC](https://community.amazonquick.com/t/visual-type/17992/4 "2023-09-14T13:30:03Z")
Thanks Naveed for responding. So, how would that work. Lets say, 10 companies out of 100 have the Keyword Software listed in the industries column, along with other keywords as shown in the example, would a vertical chart show 10 % companies associated with software industry? ---
**Author:** ![pbehrani](https://avatars.discourse-cdn.com/v4/letter/p/e19adc/32.png) [@pbehrani](https://community.amazonquick.com/u/pbehrani)\ **Post date:** [September 15, 2023, 6:39pm UTC](https://community.amazonquick.com/t/visual-type/17992/5 "2023-09-15T18:39:00Z")
Anyone else, please feel free to chime in. Thanks. ---
**Author:** ![WLS-DM](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-dm/32/36109_2.png) [@WLS-DM](https://community.amazonquick.com/u/WLS-DM)\ **Post date:** [November 28, 2023, 7:03pm UTC](https://community.amazonquick.com/t/visual-type/17992/6 "2023-11-28T19:03:06Z")
Hello @pbehrani, my apologies for the delayed response. I hope you were able to resolve this and find the proper display for your visuals but in case you are still having an issue I think Naveed is right and the bar chart will be the best use case. You can even do a stacked percent bar chart where you would show the percentage of companies that are and are not associated with each industry. You could have 2 calculated fields: For companies associated with the industry - `distinctCountOver({company}, [{Associated Industry}], PRE_AGG)` Total companies - `distinctCountOver({company}, [], PRE_AGG)` I suggested using distinctCountOver for both calculated fields so you can aggregate the 2 if necessary. To get the remaining companies not associated with the industry, you would want to subtract those associated from the total. I hope this helps with your path moving forward. Thank you!