Last tested: Jan 2, 2020
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.
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.
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: