This is a quick and dirty tips to facet cells starting or ending with a number. Regex will be much cleaner for this but unfortunately the grel expression startsWith and endsWith does not support regex :-(
So select your column and facet and Custom text facet ....
If you want to filter all cells starting with a number use the following expression:
If you want to filter all cells ending with a number use the following expression:
So select your column and facet and Custom text facet ....
If you want to filter all cells starting with a number use the following expression:
if(startsWith(value,'0'), 'true', if(startsWith(value,'1'), 'true',if(startsWith(value,'2'), 'true',if(startsWith(value,'3'), 'true',if(startsWith(value,'4'), 'true',if(startsWith(value,'5'), 'true',if(startsWith(value,'6'), 'true',if(startsWith(value,'7'), 'true',if(startsWith(value,'8'), 'true',if(startsWith(value,'9'), 'true', 'false'))))))))))
If you want to filter all cells ending with a number use the following expression:
if(endsWith(value,'0'), 'true', if(endsWith(value,'1'), 'true',if(endsWith(value,'2'), 'true',if(endsWith(value,'3'), 'true',if(endsWith(value,'4'), 'true',if(endsWith(value,'5'), 'true',if(endsWith(value,'6'), 'true',if(endsWith(value,'7'), 'true',if(endsWith(value,'8'), 'true',if(endsWith(value,'9'), 'true', 'false'))))))))))