You wanna know why this dashboard takes a full minute to load? It's because it joins every table in the fucking database because some people can't be bothered to look at a separate page for certain information.

[–] PhlubbaDubba@lemm.ee 5 points 1 year ago (2 children)

See this is where Excel ... well, excels!

Pivot tables do these data pulls pretty easy

[–] UnrepententProcrastinator@lemmy.ca 7 points 1 year ago (1 children)

Please don't tell that to any manager. They'll misinterpret it.

[–] PhlubbaDubba@lemm.ee 3 points 1 year ago

Nah this is one of those slick work deals, legit all you need to do is list all your entries, order a pivot table, and then you can just arrange your variables to display however you want them to, do a little format pizaz, and voila, here's that "report" you asked for!

[–] oce@jlai.lu 6 points 1 year ago

Is it ironic?

[–] squeezeyerbawdy@lemmy.world 3 points 1 year ago

Oooh I had a 45 second coughing fit- thanks flu and you dear poster!

[–] fibojoly@sh.itjust.works 3 points 1 year ago

Me right now, discovering that our archives data have file sizes... sometimes in bytes, sometimes in kilobytes. I found some pattern this morning thinking I could know which was which, then the pattern collapsed at some date in the past.
Joy.

[–] lorty@lemmygrad.ml 2 points 1 year ago

You forgot the 3 paragraph WHERE clause to get every data point of a wednesday of an even year of a person who stubbed their toes on a roomba in their parent's basement.

load more comments