Make available calendar and fiscal quarters as a time interval

OmarKhan · August 3, 2011 12:25PM

Is it possible to have available calendar and fiscal quarters as a time interval?

steve · August 3, 2011 2:16PM

In what situation (e.g. which views) in detail? And what specifically do you mean fiscal quarters? I would imagine these are different in different countries or for different corporations.

OmarKhan · August 4, 2011 7:07AM

We could set this up as a add field(Quater) and add month from Jan - Mar as Quater1,Apr - jun as Q2 and so on. I was hoping if there was something on omniscope which could do this looking at the date and cummulating it.

steve · August 4, 2011 9:29AM

I'm not sure what you mean by "cumulating it".

Where do you want to see this quarter? In table view cells? As bar view intervals?

OmarKhan · August 4, 2011 10:23AM

.

steve · August 4, 2011 10:46AM

Use a formula, such as:
DECLARE(
m, DATEUNIT([Field 1], "months"),
IF(m=null, null, m<4, "Q1", m<7, "Q2", m<10, "Q3", "Q4")<br />)

See attached example.

tjbate · August 4, 2011 11:56AM

Omar - many companies, industries and nationalities count these kinds of date intervals differently..it is best to use 'bucketing' formulae like the one above, and the one illustrated here for fiscal year bucketing:

http://www.visokio.com/kb/useful-formulae

Welcome!

Categories

Ideas Parade