Custom Field won't show up in future months.... [Looker newbie here]

[lookeruserjy]

hello - I set up a custom field as a measure, and I attempted to populate it for all months in 2020, but it will only populate for values up until the current month, which is May.

For example, if I inputted Revenue Forecast month for 2020, and I want these to plot as a dot in visualization, it’s only plotting up until May 2020. How do I get these to show for future months?

[Cyril_MTL_Analy]

Hello @lookeruserjy and welcome!

You need to have data points available for each months to be able to plot them in a visualization.

Can you give more details, screenshots of your current setup?

[izzymiller]

Also, check out this article for a table calc approach:

Looker Help Center

How to Forecast in Looker with Table Calculations

The Problem: I Need to See the Future! This page references Explore examples from the Looker Learn instance. If you do not have access to the Looker Learn instance, contact Looker Support for crede...