Question

Date fill not showing on future months in column visualization

  • 22 August 2022
  • 0 replies
  • 76 views

Hello, 

I have this dashboard tile that shows a measure broken down by month name and pivoted by year. This is filtered to `Matches (Advanced) “last 2 years”`.

 

I have no data returning for the months of Jan, Feb, Mar, Nov, Dec.

 

In the visualization, Looker does show the first null three months and the data in the following months, but stops at October, omitting November and December. Both November and December are showing in the Data section.

Any ideas on how I can force Looker to show all 12 months regardless if there is data? I have tried adding a date filter for “before next year” and the same thing happens. Date-fill is enabled at the dimension level too.

 

Thank you


This topic has been closed for comments