LinkedIn
Twitter
Knowledge Drop
Last tested: Jan 2, 2020
The Problem
Someone sends you the following screenshot from a dashboard tile or a visualization from an explore, and wants to know why not all months are being represented on the X-axis.
A Solution
By default, the displayed points on both axes of the chart scale with the size of the window. The following screenshot is the same visualization as above, automatically scaled to display in a smaller window.
How would one change this to force all data points on the X-axis to be represented properly?
- In the visualization in the explore (i.e. if you are troubleshooting a dashboard tile, navigate to the underlying visualization), click the gear icon at the top right hand corner of the pane.
- Scroll over to 'X', and change the 'Scale Type' to 'Ordinal'.
- Note that this can be accomplished through LookML.
A Caveat
Note that even when the scale type is set to ordinal, there will be times when not every data point will be shown on the X-axis due to space limitations:
This content is subject to limited support.