Some day someone asked how do I go from here:
To something like this:
I know, the very fast answer: go talk to your BD admin and ask him to build such x-axis independent variable.
But what if I feel brave enough to try it directly working on Looker?
Well, here are the steps I took to achieve it:
1.- First, grabbing any enough long in rows DB field, like ID for example, through ROW_NUMBER() function, I could set up a derived table that contains a regular paced variable with a proper alias.
derived_table: {
sql: select row_number() over(order by Id) as consecutivos from public.products;;
}
2.- If the field with jumps is a Dimension, convert it to a Measure. Using this awesome trick
https://community.looker.com/technical-tips-tricks-1021/how-do-i-visualize-a-dimension-as-a-measure-...3.- Merge accordingly, taking as primary query the regular paced x-axis independent variable that was made before. And match it with the dimension with jumps. So it will generate Null values where it doesn’t find a match. And include the correspondent measure. At the end, I got something like this:
Anyway. This is as far as I got. I hope you may find it useful.
Blessings.
Juan P