We've just launched a nice new feature that allows you to set a custom fiscal year date range specific to your ShufflePoint account.

To access this feature login to ShufflePoint and click on "Edit user profile"...
(click screen grabs below to view larger versions)

Then select your custom fiscal year end date and update your profile...

Once you have your custom fiscal date range set, then it's time to write some queries using it.

As usual, this can be used in queries in the Query Builder or Excel. Here is an example of the timeframe in use in a query...

SELECT
  METRICS ga:users, ga:sessions, ga:pageviews, ga:timeOnPage ON COLUMNS
  DIMENSIONS ga:yearMonth ON ROWS
FROM default
WHERE
  TIMEFRAME lastFiscalYear

You can also use lastFiscalYear2 to get the same custom fiscal date range two years ago...

Finally, you can also query the current fiscal year to date easily as in the following sample...

SELECT
  METRICS ga:users, ga:sessions, ga:pageviews, ga:timeOnPage ON COLUMNS
  DIMENSIONS ga:yearMonth ON ROWS
FROM default
WHERE
  TIMEFRAME fiscalYearToDate