Bell Curve - Large Data
Hello,
I am working with a large amount of rows, due to sales items having multiple sizes/colors. Looking to build a size/bell curve to present to the client but when I use the Histogram, it doesn't group by the category names/sizes but in the table view it shows the units by group.
Histogram:
Thank you in advance for the help and any recommendations to visual this, outside of a tabular/table view, would be helpful.
Best Answers
-
The first thing that jumps out at me that might be throwing off the histogram chart is that you have something in the Sorting properties. Try removing that and see if that allows it to distribute better.
If you haven't looked at the KB article, this can be helpful in understanding how the chart is intended to function.
https://domo-support.domo.com/s/article/360043429193?language=en_USWith so many sizes, I wonder if a Word Cloud chart might be easier for a user to digest. You might want to look at that chart.
**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'm not sure about using a histogram. I'd use a bar chart. Note - my fake data does not exactly match yours. :)
Creating SizeAsInteger with the formula : CAST(RIGHT(Size, 3) AS Integer)
You can create bins (show above). Which seems customary for histograms and sizing.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **2 -
You can make your vertical card look more like a histogram by changing the bar width in the properties, that might be more visually pleasant for your use case.
1
Answers
-
The first thing that jumps out at me that might be throwing off the histogram chart is that you have something in the Sorting properties. Try removing that and see if that allows it to distribute better.
If you haven't looked at the KB article, this can be helpful in understanding how the chart is intended to function.
https://domo-support.domo.com/s/article/360043429193?language=en_USWith so many sizes, I wonder if a Word Cloud chart might be easier for a user to digest. You might want to look at that chart.
**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'm not sure about using a histogram. I'd use a bar chart. Note - my fake data does not exactly match yours. :)
Creating SizeAsInteger with the formula : CAST(RIGHT(Size, 3) AS Integer)
You can create bins (show above). Which seems customary for histograms and sizing.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **2 -
@MarkSnodgrass Thank you for the help. I removed the sort previously and still got the same response.
I'm sure it's just the size of my data to the chart. Was able to achieve it using some other vertical bar charts but the formatting on the histogram is so nice.
Appreciate the help.
0 -
Thank you @ArborRose - That works nicely. Appreciate the help.
0 -
You can make your vertical card look more like a histogram by changing the bar width in the properties, that might be more visually pleasant for your use case.
1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive