New pre-defined date filter - financial quarter

This should convert the date into a quarter value (1 to 4) allowing easy grouping of quarters and reporting on historical values for comparisson

Hi Veronika,

yes, I think that's a great idea, so I have raised an internal enhancement request (YFN-9347) for it.

Thank you for your input.

regards,

David

Hi All,

do we know if this progressed at all?

Cheers Peter

Hi Peter,

good news, I had a look in a recent build of 7.3 and it looks like it is there now, just make sure your date filter is using the BETWEEN operator rather that EQUAL TO :

regards,

David

hello again Peter,

actually I've just realised that the second part of your request is not possible (the date should be converted into a quarter value 1-4) via the Financial Quarter Predefined Date Filter.

However, it would be possible if there were a Date Function in the View Builder's Prepare screen called Financial Quarter, however at the moment there is only one called "Quarter" which in fact is Calendar Quarter (I tested it out on the current date and it came out with a 2 instead of 4)

So what I will do is to keep that enhancement request open and add a new part to it: "Please add a new Date Function in the View Builder called "Financial Quarter""

As well as that, I think I should inform you that what you want is currently possible if you create a Calculated Field, choose the "Freehand SQL" Formula Type and then enter in some SQL code that will do the job such as the example below:

CASE
    WHEN MONTH(MyDate) BETWEEN 7 AND 9 THEN 1
    WHEN MONTH(MyDate) BETWEEN 10 AND 12 THEN 2
    WHEN MONTH(MyDate) BETWEEN 1 AND 3 THEN 3
    WHEN MONTH(MyDate) BETWEEN 4 AND 6 THEN 4
END

David

Hello David,

Thank you for also informing me about the progress. A new Date Function would be a great idea because our customers often using the financial quarter and if they have to add a calcualtion within every report this is not the best resolution.

Regards,

Veronika

Hi Veronika,

yes I agree, a new Date Function called "Financial Quarter" would be great!

One more thing, I mention this just as a workaround until the new Date Function "Financial Quarter" gets created, please keep in mind that the Calculated Field idea I mentioned in my previous email can be created at the view level, thus if you created it just once in a view then all clients would be able to use it in the reports without having to create it again themselves. Also, I gave an example using the Freehand SQL Calculated Field, but please keep in mind that you can achieve the same result using the Formula Builder of the Simple Calculated Field as well.

regards,

David

Hi David,

thank you for all the info. I'm just having a little trouble getting my head around how to go about what I want to do.

I have a table where sales figures for example are currently broken down by Month. I have created this using cross tab and in the columns I used the Pre-defined Year, pre-defined Month(number so that the months are in the right order, Month Name. I want to use Quarters in the same way so that n my report I have 12 columns of figures, one for each month and then four columns of figures, one fore each quarter.

Would I use your SQL statement above in the Calculated field and that should just work if I drag it into columns are Month Name?

Cheers Peter

Hi Peter,

yes, unless I've misunderstood you, that is exactly what I meant. To make sure that we aren't misunderstanding one another I have attached a short video to show you what I meant, please let me know if it is the same thing you are talking about - I certainly hope it is!

regards,

David

Hi Dave,

I just wanted to ask if there are any News?

Regards,

Veronika

Ver

Hi Veronika,

I've checked the enhancement request and there has been no movement on it yet.

regards,

David

Hi Dave,

hmm okay thank you for the information.

Regards,

Veronika

Hi Veronika,

if it's very important to you then please let me know and I will try my best to fight for it.

regards,

David

Hi David,

it would be great to have this feature because our clients start to create reports and some of them do have different accounting years.

And in our business it is very important to calculate the costs by quarter. So I would be thankful if you could try to fight for it 😊

Regards,

Veronika

Hi Veronika,

I'm sorry but after I put forward my convincing argument that it would be a quick enhancement to do, and it would help many clients, I was told "I don't see this being looked at anytime soon." I guess that is because all developers are very busy at the moment working towards the release of the next major version.

The only other thing I can suggest is to contact your Account Manager and discuss it with them, because sometimes they can work some magic!

regards,

David

Hi David,

okay thank you for your information and effort in my issue.

I guess I will look through all my ideas with are created for me and then I will get in touch with my account manager.

Maybe it is better if I do have more issues to be solved 😊

Regards,

Veronika

Hi Veronika,

yes, good idea, it makes more sense to discuss all outstanding defects in the same meeting rather than one at a time.

regards,

David

Hi Veronika,

I hope you're doing well!

Just doing some clean-up of old tickets.

I believe that the date filter 'financial quarter' has been added to Yellowfin in recent releases. You can find some documentation on Financial Quarter and other quarterly phrases over on our Date Filter Periods wiki page.

I'll close this off, but let me know if you have any questions and we can pick this up.

Kind regards,

Chris