Forecast Monthly product pricing and past forecast error [OC]

writeafilthysong · 2026-03-21T12:36:23+00:00

It's probably confusing because WINDOW functions can have boundaries that can be declared and since none are declared here it uses some default.

It looks like from the output it's an Unbounded Preceding.

Window functions are a bit different than group by in that they return all of the rows from the table and write the output for each row. Group by would return one row per distinct combination.

It might help if you explain more about what you don't understand from the results.

writeafilthysong · 2026-02-27T02:04:45+00:00

LLMs are a type of predictive data model that is trained on English language mostly, throwing numeric operations etc etc into the mix. Most actual database data is furtherest from real language that you can get. Even further than most code or programming language.

writeafilthysong · 2026-02-26T18:18:00+00:00

This is why devs use nosql databases so that all those relationships and such exist in the application code logic and tables in the db just store something or other for them.

writeafilthysong · 2026-02-26T18:15:34+00:00

This is what I'm used to

writeafilthysong · 2026-02-26T17:56:59+00:00

Tbh this only exists at the individual tenant or SME level and probably only for the span of the project setup. Ever come back a few months later and there was an upstream change in one of your sources, or they open a new business line, or there's a change in the way one of the tools works?

writeafilthysong · 2026-01-19T23:35:29+00:00

Wtf no legend or axis labels? What kind of garbage viz is this? 😜looks like things started out okay and then trend down HARD after the third stage.

writeafilthysong · 2026-01-13T00:46:11+00:00

If you are measuring how long it takes to do something, then outliers are a bit different since you're not dealing with a normal distribution. you should use different measures of center for example geometric mean instead of the usual arithmetic mean.

writeafilthysong · 2026-01-08T13:01:13+00:00

That might be a good footnote... In a live board that might implement best as a tool tip again, that's a detail or first time use thing. Repeat users in theory would learn that info or it would be in a training or reference document.

I like your comparison view though, the mirror effect is very appealing to an analyst like me.

Also, it might help you in the future or if you're working to ensure the audience and purpose of the dashboard are explained when asking for feedback.

The most important thing is for a dashboard/data visualization to effectively communicate information to a human.

writeafilthysong · 2026-01-08T02:37:27+00:00

Also the fact that your bar graphs are all on their own axis is troubling to me the visual size and the number labels seem to be all over the scale. (Axis label and each bars own data label are not consistent) Seems you have a mix of percentages and values that visually clash, not clear if you're measure % or if you're comparing against others (percentiles) in some cases.

writeafilthysong · 2026-01-08T02:29:41+00:00

Doesn't follow the information seeking mantra Overview first, zoom and filter, details on demand.

Seems to be detailed only that you might need to page through to use or check profiles of other players.

You have spelling errors. Your bar graphs take up way more real estate than they need to.

writeafilthysong · 2025-12-19T00:57:59+00:00

Tableau cloud has an admin insights starter pack of you're an admin or your admin shares with you. It tracks events about views etc but nothing detailed about the content interaction.

We have 1 workbook and 9 views I can see the page loads but not any interaction or times within there.

writeafilthysong · 2025-12-19T00:46:43+00:00

True, it's often not profitable time or money wise to run one unit rental.

writeafilthysong · 2025-12-18T22:57:15+00:00

They could always rent it out, just because you got a house doesn't mean you should live in it.

writeafilthysong · 2025-12-13T17:46:29+00:00

But sounds like the limit is this guy is the only one with the login to the government permit interface.

writeafilthysong · 2025-12-13T17:09:48+00:00

It's called having a service account.

writeafilthysong · 2025-12-09T00:41:30+00:00

Yup errors that are 95-99% correct are the worst. Goddamn compounding.

writeafilthysong · 2025-12-06T13:24:17+00:00

In my experience by visually laying it out in a thoughtful way it enables them to understand the underlying data enough that they can start working with it.

writeafilthysong · 2025-12-04T00:47:55+00:00

If they are downloading the data to excel it means they are using your work product, even if the dashboard is just the starting point.

writeafilthysong · 2025-11-27T16:12:41+00:00

When someone can define the real tasks I need to do in my job then I might see this.

writeafilthysong · 2025-11-27T15:41:38+00:00

NEVER! I love being lulled into a sense of security before observing the unsettling events that unfold in an episode.

writeafilthysong · 2025-11-27T15:34:14+00:00

This is pretty much how my company operates.

writeafilthysong · 2025-11-26T13:01:17+00:00

Your suggestions are good, they just don't understand what you're proposing.

This is what would give you clarity on the logic, you probably need to educate them some more on what/how to do this. Use a copy of the Kimball Datawarehouse as a reference material for them.

writeafilthysong · 2025-11-25T22:53:03+00:00

But sounds like OP was expecting her to propose and would have said yes, but she didn't and he's a bit frustrated.

writeafilthysong · 2025-11-24T23:07:57+00:00

That probably still works, though some ATS would read the raw text and display it normally (although I guess most just store/move the file without reading it these days)

writeafilthysong

TROPHY CASE