Recent comments in /f/dataisbeautiful

groovycoyote t1_j15qbyx wrote

Then that is your takeaway. There is absolutely no need to use so much text and color. Choose a few key categories that are a good representation of people's overall shopping habits and add those as your colored lines. You can add another line with a neutral color combining all the rest and show the average values over time. Drop all the numbers from the chart and add a subtitle that says how nothing has changed despite this and that. And please use a logical order for the dates on the X axis.

3

semideclared OP t1_j15p3d3 wrote

Thats it though....theres been no change

The biggest shopping weekend in 4 years was the 2 weeks in the middle of March 2020 as everyone panic bought. Every Year July 4th, Memorial Day, Christmas and Thanksgiving are the normal outliers for shopping

That left April Covid and October Inflation as good comparisons

Inflation, and a Pandemic....and we still buy the same kind of things

Ground Beef or Steak, Cokes and Pepsi, Fruit Drinks, Crackers, Cookies, and Frozen Meals

None of this really changed in the Same week in each year even as life changed so much

0

groovycoyote t1_j15lhjh wrote

There are a number of issues with this visualization, so I'll try to be concise. Please don't take it as a harsh criticism but more as a helpful learning moment.

Is there a key takeaway or two that you have identified and that you would like the audience to notice? At the moment I just don't see it because you're trying to fit so much information into one single visual that I don't know what I'm supposed to concentrate on. It looks like you got some data and put together a visual without much thought to what you're wanting to communicate or you didn't even think about any findings at all.

It looks like you're trying to show certain trends over time, but bar charts are not the best choice for this kind of data. You've tried to fit too much information into one single visual, but in reality it's just excessive text and color everywhere. When stacked bar charts are appropriate, you should use no more than 5 colors.

The time intervals appear really inconsistent. We want to see intervals like day, week, month, quarter or year, not jump from random dates to another as it's misleading and disruptive.

If your intention is to show trends over time, use an area or line chart instead. For example, an area chart showing the total (as opposed to a second bar), and lines showing different categories (as opposed to stacked bars). Now, instead of showing an excessive number of different colored lines, think what you are trying to communicate.

Option 1: Is it really necessary to show all these different categories separately if nothing really stands out and if it's so difficult to tell which is which due the high number of them? Combine them into no more than 5 bigger categories and draw attention to the most important or interesting ones by using distinctive colors, the uninteresting ones can all have the same neutral tone of grey for example.

Option 2: Are there any product categories with a very surprising or significant change in the trend? Let's say there is and you find that the sale of bread has skyrocketed since the pandemic began compared to all other categories combined. That would be your interesting finding to focus on, one line representing bread and another the rest. Color that line with one that stands out and leave the other one neutral. Everyone's eyes will be drawn immediately to the fact that there's an interesting trend with bread.

6

Ramental t1_j15kvrl wrote

Ok, I've read it, but still, why the heck the problem can't be fixed after at least 15 years of existence?

https://en.wikipedia.org/wiki/South_African_energy_crisis

South Africa is even richer than Ukraine, but also self-provides itself all the coal it needs. In fact, it mines enough coal for 3 South Africas. Further, it's usually mined in open pits rather than underground mines, which is safer and cheaper.

I get that Zuma was corrupt and blamed, but why was he elected again if he didn't do crap about such an important problem?

2

AftyOfTheUK t1_j15asq5 wrote

Wouldn't this ratio be highly affected by the ratio of publicly-traded versus privately traded companies?

What does this figure tell us?

If several large companies were to IPO, then the ratio would rise rapidly, but little would have changed within those companies or the country. Similarly, if a number of large companies had management buyouts with private equity, again the ratio would drop - but those companies would continue to operate with the same staff doing the same things.

Not sure what conclusions we can draw from this data?

3

chestas_ OP t1_j159woz wrote

Google sheet is used.

Data collected based on personal observations

​

Data, csv

Start Time,End Time,Total,Date,Date Formated,Total Min

12:07:00,21:31:16,9:24:16,21.12.2022,2022.12.21,564

2:47:00,7:40:00,4:53:00,21.12.2022,2022.12.21,293

1:05:00,18:05:00,17:00:00,20.12.2022,2022.12.20,1020

10:16:00,21:21:00,11:05:00,19.12.2022,2022.12.19,665

0:00:00,3:54:00,3:54:00,19.12.2022,2022.12.19,234

15:12:00,22:47:00,7:35:00,18.12.2022,2022.12.18,455

8:37:00,13:11:00,4:34:00,18.12.2022,2022.12.18,274

0:00:00,2:43:00,2:43:00,18.12.2022,2022.12.18,163

16:27:00,18:37:00,2:10:00,17.12.2022,2022.12.17,130

7:41:00,9:10:00,1:29:00,17.12.2022 23:09:10,2022.12.17,89

9:59:00,23:28:00,13:29:00,16.12.2022,2022.12.16,809

18:02:00,21:24:00,3:22:00,15.12.2022,2022.12.15,202

9:03:00,13:15:00,4:12:00,15.12.2022,2022.12.15,252

15:02:00,18:16:00,3:14:00,14.12.2022,2022.12.14,194

8:11:00,9:35:00,1:24:00,14.12.2022,2022.12.14,84

12:24:00,15:20:00,2:56:00,13.12.2022,2022.12.13,176

18:17:00,20:12:00,1:55:00,12.12.2022,2022.12.12,115

7:51:00,12:04:00,4:13:00,12.12.2022,2022.12.12,253

0:12:00,3:12:00,3:00:00,12.12.2022,2022.12.12,180

18:50:00,20:12:00,1:22:00,11.12.2022,2022.12.11,82

8:30:00,12:19:00,3:49:00,11.12.2022,2022.12.11,229

0:00:00,3:10:00,3:10:00,11.12.2022,2022.12.11,190

12:07:00,16:21:00,4:14:00,10.12.2022,2022.12.10,254

3:03:00,6:59:00,3:56:00,10.12.2022,2022.12.10,236

18:13:00,18:52:00,0:39:00,09.12.2022,2022.12.9,39

12:07:00,13:54:00,1:47:00,09.12.2022,2022.12.9,107

10:00:00,10:10:00,0:10:00,09.12.2022,2022.12.9,10

3:31:00,6:28:00,2:57:00,09.12.2022,2022.12.9,177

15:17:00,21:48:00,6:31:00,08.12.2022,2022.12.8,391

9:04:00,12:09:00,3:05:00,08.12.2022,2022.12.8,185

0:07:00,3:30:00,3:23:00,08.12.2022,2022.12.8,203

12:51:00,18:28:00,5:37:00,07.12.2022,2022.12.7,337

7:35:00,9:28:00,1:53:00,07.12.2022,2022.12.7,113

0:00:00,0:26:00,0:26:00,07.12.2022,2022.12.7,26

18:00:00,23:59:59,5:59:59,06.12.2022,2022.12.6,359

12:51:00,15:38:00,2:47:00,06.12.2022 9:56:48,2022.12.6,167

5:24:00,6:45:00,1:21:00,06.12.2022 9:56:48,2022.12.6,81

16:35:00,21:14:00,4:39:00,05.12.2022 9:56:48,2022.12.5,279

9:00:00,12:21:00,3:21:00,05.12.2022 9:56:48,2022.12.5,201

0:06:00,0:41:00,0:35:00,05.12.2022 9:56:48,2022.12.5,35

18:22:00,21:06:00,2:44:00,04.12.2022 9:56:48,2022.12.4,164

9:37:00,12:50:00,3:13:00,04.12.2022 9:56:48,2022.12.4,193

0:02:00,1:26:00,1:24:00,04.12.2022 9:56:48,2022.12.4,84

16:51:00,18:50:00,1:59:00,03.12.2022 9:56:48,2022.12.3,119

0:00:00,1:44:00,1:44:00,03.12.2022 9:56:48,2022.12.3,104

22:29:00,23:59:59,1:30:59,02.12.2022 9:56:48,2022.12.2,90

16:17:00,18:14:00,1:57:00,02.12.2022 9:56:48,2022.12.2,117

12:10:00,15:25:00,3:15:00,02.12.2022 9:56:48,2022.12.2,195

6:06:00,9:27:00,3:21:00,02.12.2022 9:56:48,2022.12.2,201

0:00:00,1:27:00,1:27:00,02.12.2022 9:56:48,2022.12.2,87

21:40:00,23:59:59,2:19:59,01.12.2022 9:56:48,2022.12.1,139

11:30:00,17:07:00,5:37:00,01.12.2022 9:56:48,2022.12.1,337

15:00:00,21:15:00,6:15:00,30.11.2022 9:56:48,2022.11.30,375

7:15:00,9:15:00,2:00:00,30.11.2022 9:56:48,2022.11.30,120

21:40:00,23:59:59,2:19:59,29.11.2022 9:56:48,2022.11.29,139

12:10:00,16:00:00,3:50:00,29.11.2022 9:56:48,2022.11.29,230

18:10:00,22:10:00,4:00:00,28.11.2022 9:56:48,2022.11.28,240

9:10:00,15:20:00,6:10:00,28.11.2022 9:56:48,2022.11.28,370

1:30:00,3:00:00,1:30:00,28.11.2022 9:56:48,2022.11.28,90

18:20:00,23:30:00,5:10:00,27.11.2022 9:56:48,2022.11.27,310

10:40:00,14:40:00,4:00:00,27.11.2022 9:56:48,2022.11.27,240

17:20:00,21:10:00,3:50:00,26.11.2022 9:56:48,2022.11.26,230

12:20:00,19:30:00,7:10:00,25.11.2022 9:56:48,2022.11.25,430

6:15:00,11:05:00,4:50:00,25.11.2022 9:56:48,2022.11.25,290

0:00:00,1:00:00,1:00:00,25.11.2022 9:56:48,2022.11.25,60

11:00:00,23:59:59,12:59:59,24.11.2022 9:56:48,2022.11.24,779

21:00:00,23:59:59,2:59:59,22.11.2022 9:56:48,2022.11.22,179

12:00:00,15:00:00,3:00:00,22.11.2022 9:56:48,2022.11.22,180

​

*The data for one particular building. Some buildings have more or fewer power cuts

#russiaisaterroriststate

10