Yearly Quarters

Question & Answer
, ,
1

Currently my data looks like this :
image

I want to add a new column named quarter which is like this :
image

How can I achieve this?

2

Hi @maitreya10
one option would be:

concat("Q",toString(extract("Q",parseDate(concat("01/",{Month},"/",{Year}),"dd/MMM/yyyy"))),"-",{Year})

If year is a numeric field you need to do toString({year})

BR

3

@ErikG This works like a charm, thank you!

1 Like