What type of filter is that? I would guess that's a MONTH([date]) filter rather than a continuous date filter. (Disclaimer: I have not looked at the postgres sql for either type)
Yes, it is a month filter, on a timestamp column.
Hi Bob -
To get the kind of filter you want, you will need to create a continuous date filter instead of the discrete filter you now have on the month part of the date. To do this, just drag the date itself to the filter shelf and when the dialogue asks you "Which field do you want to filter?", choose "Date (continuous)" which should be the second item from the top. You will then get a continuous date filter dialogue and you can just set the endpoints to the values you want.
I am having problem in calculating month to month growth from the Fiscal Month field. Our source data is integer
200801, 200802. How can use this field in calculating month over month, quarter over quarter and year over year time calculation.
Attached is the details with all the screen shot. My fiscal year start in August.
Fiscal month dates.jpg 16.9 KB
Looks like you'll have to stringify and chop up your integers to create date objects. Something like this:
DATE( LEFT(STR([Period]),4) + "-" RIGHT(STR([Period]),2) + "-01" )
This creates a string of the form "YYYY-MM-DD" (where your days are always 01) and then parses that string to create a Date object.