I have a report that is grouped by Quarter and I am wanting to change how its presented from QX-YYYY to YYYY-QX. I looked in setting, rule transformations, cases but nothing is allowing me to switch the position of the quarter and the year. Anyone have success doing this?
Hello Ty, and welcome to the Community.
I’ve yet to see a way to alter that Quarter format. There’s little customization or custom formatting that one can apply to date formats.
What’s your end need or goal? Perhaps we can brainstorm some solutions if we know the end state you seek.
Hi Matt, I ended up creating a picklist where created YYYY Qx, then used criteria on actions to set the the correct option.
The goal of this is when exporting data it can be sorted without any other manipulation.
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.