include a variable in load script

[martin_hamilton]

Hi

Am determining the quarter based on a date field but want to include a variable for the current year or pull it from the original date field. so far i have this:

'Q' & ceil(month([CONNECTED_MONTH])/3)

Which is created a value of Q1, Q2, Q3, Q4.

I wish to have it state Q1-2016, etc

Any help appreciated.

Cheers

Martin

[sunny_talwar]

Not sure I understand the logic for creating Q1-2016. Can you elaborate?

[martin_hamilton]

I was looking at providing a filter function on a dashboard so someone could select the Quarter data associated with the records.

[Anil_Babu_Samineni]

You want to show like this

Q1-2016

Q2-2016

Q3-2016

Q4-2016

[martin_hamilton]

yes if possible.

thanks