Creating Quarters Field

[#1]

Hello Everyone,

I am looking for some advice on how to create a quarters field.

To give you some background, I have a script that looks like this, it's pretty simple:

So, I had a number of tables which each have tables for Employee ID, Gender and Current Job Title. Each table pertain to a different month so I used the FileBaseName function to generate a field based on the name of the excel document.

Now, would it be possible to generate a field called quarters?

If you could, please provide an explanation of how your expression works, as this is just a test and I'd like to be able to apply the solution myself to other data sets.

Thank you in advance,

Alison

[Matthew-Thornington]

Another option could be just to leave the date field in the script and use the new(ish) autoCalendar functionality to create visualizations by quarters in the sheets view. It depends what your end goal is.

[#3]

Ah ok!

Thank you so much, I understand now!