英文:
How to display data in a graph, where one attribute has 90% data and others attributes have significantly lower data
问题
我需要你的帮助来理解如何以图形方式显示数据。我们收到了IOT数据，其中有一个活动在一段时间内占了90%，而其他活动的数据显著较低。
最佳的方式是如何在图表中显示所有数据，以便能够轻松理解。
属性1（90%）
属性2（2%）
属性3（2%）
属性4（2%）
我尝试使用折线图来显示数据，但折线图上的数据看起来不好。因为属性1有很多数据，其他数据在图表中不适应（或者无法看到）。
英文:
I need your help to understand best graphs to display data in a graph. We received IOT data, and for one activity we received 90% in a time frame, and other activities we received significantly lower data.
What is the best way to display all data in the graph, so that it can understood easily.
attribute1(90%)
attribute2(2%)
attribute3(2%)
attribute4(2%)
I tried to use line chart to display data, but data on the line chart does not looks good. As attribute1 has a lot of data and other data does not fit(or cannot see) in the graph
答案1
得分: 1
没有“正确”的答案，这取决于：
1）属性数量> 1
2）测量的含义
3）属性1的重要性
4）属性1当前值是否为90%是否不同寻常
5）你想要进行的比较是什么？
6）是否需要完全显示属性1？
话虽如此，在社区精神的基础上，考虑一些因素：
如果除了主要属性之外只有少数属性，饼图可能足够（尽管反对饼图的人可能会说什么）：
如果属性太多，这将无济于事：
如果它始终占总数的90％，并且这个部分可能被认为不太有趣，你可以考虑不显示属性1：
你可以计算每个属性与过去值的偏差，或者它们与平均值的偏差，或者如果属性可以分组，你可以将它们分组以使它们更显著：
这可以继续下去。
最终，我建议你将焦点集中在你试图用数据传达的信息上，然后根据这个目标处理和可视化你的数据。
英文:
There is no "right" answer to this question as it depends on:
- the count of attributes > 1
- the meaning of measurements
- the importance of attribute1
- whether attribute1's current value of 90% is out of the ordinary
- what is the comparison you're trying to make?
- do you need to show attribute1 at all?
That said, in the spirit of community, some things to consider are:
If you only have a few attributes other than the big one, a pie chart might suffice (despite what the anti-pie-chart crowd might say):
If there are too many attributes, it won't help:
If it's always 90% of the total, and that face could be considered not interesting, you could consider not showing attribute1 at all:
You could calculate each attribute's deviation from past values, or their deviation from the mean, or if the attributes are groupable, you could group them to make them stand out more significantly:
This could go on and on.
Ultimately, I recommend you get laser-focused on the message you are trying to convey with your data and then process and visualize your data to that end.
答案2
得分: 0
你可以使用所谓的帕累托图。它的基本目标是突出显示数据集中的最大因素。
链接：https://support.microsoft.com/en-gb/office/create-a-pareto-chart-a1512496-6dba-4743-9ab1-df5012972856#:~:text=Click%20Insert%20%3E%20Insert%20Statistic%20Chart,Recommended%20Charts%20%3E%20All%20Charts%20tab.
英文:
You can use what is called a pareto chart. It's basic aim is to <highlight the biggest factors in a data set>
https://support.microsoft.com/en-gb/office/create-a-pareto-chart-a1512496-6dba-4743-9ab1-df5012972856#:~:text=Click%20Insert%20%3E%20Insert%20Statistic%20Chart,Recommended%20Charts%20%3E%20All%20Charts%20tab.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论