Dashboard Render Error

[ginandtobby]

Hi Community!

I have a Looker dashboard that runs ok - everything loads and displays nicely in the dashboard itself, but when I schedule delivery, I receive this error message:
Error: Error occurred while generating this dashboard - contact administrator (error: Render job XXX failed [query failed: Missing values for 'XXX.partition_date_month_name' were not filled. Only one dimension is allowed when filling in missing rows.])

More context on this: I'm using month_name from time dimension group to plot a chart, but I want to keep the first 3 letters instead of the month full name. I used a custom dimension to extract the month name, but I need to sort it in month orders, so I used both columns, one for x-axis value display, one for sorting:

It seems like the render error has something do to with this, but I don't know why it works fine in dashboard while showing errors in scheduled delivery. Please advise what is the quick fix for this. 

Thanks!

[ruthc · Accepted solution]

The error message suggests it's something to do with filled in dates (this is a feature whereby Looker will automatically fill in missing dates, even if there is no data for that date).

1. EITHER click on the gear icon for 'Month Name' > 'Remove filled in dates', and see if this fixes the problem; OR

2. Remove both month columns, and replace with the 'month' option from your date dimension group > click on the 'Edit' button for the visualization > 'x' tab > Time Label Format = %b (this will transform values like 2025-06 to Jun)