On the Explore screen, the Visualization section is used to control how the data is represented graphically.
Related information: Controlling how report data displays
Below are some common tasks.
Filling in missing dates
The default behaviour for visualisations is to only show values that appear in the Data section results. This means sometimes dates could be missing from a date range, if there is no data for that month. With the use of the Fill in Missing Dates feature, the complete date range can be seen.
Example: October is missing data for the last year, and is it not shown.
To manage this: in the heading of the Created Month dimension column, click the cog icon; then Fill in Missing Dates.
The result is that now the visualisation has the missing month of October filled in with a zero value.
Looker resource: Filling in missing dates and values
Sorting multiple columns
To sort table data by multiple columns, press the Shift key and then, in order, click the required column headers.
Looker resource: Sorting columns
Forecasting in a visualisation lets you predict future values for one or more measures for a configurable period of time into the future, and with the option of taking into account seasonality.
The report needs to have a column, bar, line or area visualisation, with a date/time dimension field.
Example: Forecasting the number of applications created per month for a job.
- In the Visualization section, click Forecast.
- In the Forecast configuration are the following:
- Select field(s) - enter the field(s) to be forecast or predicted, in this example: Totals Applicants.
- Length - enter the length of units into the future to forecast, in this example: months.
- Prediction Interval - this option allows for adjustment in the forecasted data for accuracy. If enabled, you can select the range of the forecasted data values.
- Seasonality - this option can take into account known trends in a forecast. Enter a value or use Automatic to let the system identify cycles in the data.
- Click Run to perform the prediction.
Predicted values appear in the data table as a normal column.
Looker resource: Forecasting in visualizations