Percentage of quarter completed

[agoyal28]

Hi,

I want to calculate the percentage of quarter completed. i.e. total numbers of days in quarter so far/total number of days in quarter. 

I have a transnational level data with one of the columns as date (see below for reference). i want to calculate the percentage of quarter completed so far with the max date in the data.

Date

3-Jul

10-Jul

12-Jul

20-Jul

29-Jul

10-Aug

20-Aug

28-Aug

Can someone please help me on this?

[BenMoss · Accepted solution]

Unfortunately there is no quarter calculation in Alteryx but it can be quite easily pulled together as they never change.

I've created a workflow that performs the task outlined in the post, let me know if you have any questions.

Ben