Hi All, Is there a way to compare the total count of starting and ending assignments in a monthly period( blue for starting and green for ending)? I have both columns start and end date in the same dataset.

Hi Manny, You can create custom metrics for the month, that explicitly calculate the total values for the first and last day of the month. You can do this by finding the min/max dates in a month. The metrics would look something like this: SELECT SUM(Order unit quantity) WHERE Date - Day of Month = (SELECT MIN(Date - Day of Month,Order lines)) SELECT SUM(Order unit quantity) WHERE Date - Day of Month = (SELECT MAX(Date - Day of Month,Order lines)) Next, you can take these values of the max/min dates and apply them as an internal metrics to compare with other dates. I hope this helps guide to your desired results, . Best regards,

Hi @Yvonne Changamuka, I have assignments dataset with fields Assignment ID, Worker Name, Assignment Start date and Assignment End date. I would like to achieve this table showing the cumulative remaining workers by getting the difference of starting and ending assignments in each period .i.e Yearly. I am sharing the table structure and the report that I wanted to achieve.

Hi Manny, you should be able to create this by subtracting the end date that you calculating (Max) and subtracting it from the start date (Min). In this case, make sure to utilize an IFNULL statement to enforce a numerical value instead of the "-". Also, you can set a filter for the correct dates that you wish to view too.