Forum Discussion
Triming unwanted data and create another field
Hi Anonymous,
if you only want to cut the "Q...-" text in your column. You can:
1) go into the query editor
2) click on "Split column" -> "by delimiter"
3) "select or enter delimiter" --> "--custom--" --> -
4) "Split" --> "at the right-most delimiter"
5) ok
And this is the result:
Let me know if it works.
#I'M Not An Expert#
Do all the steps above, but first duplicate the column. Then split the duplicated column as suggested and leave the original alone and you'll have both.
Hi Anonymous,
if you only want to cut the "Q...-" text in your column. You can:
1) go into the query editor
2) click on "Split column" -> "by delimiter"
3) "select or enter delimiter" --> "--custom--" --> -
4) "Split" --> "at the right-most delimiter"
5) ok
And this is the result:
Let me know if it works.
#I'M Not An Expert#
Impactful IndividualTo avoid the zig-zag and get proper order, change (or add a field) to Year-Qtr (2015-Q1, 2015-Q2, etc.). It will then sort properly on the x-axis.