Hello team, I would like to know if it is possible the following: I need to create a table where I can see by month the number of tickets that were created and resolved. These tickets can be resolved in the same month in which they were created, but there are others where they were resolved the fo…

Hi @DannyV , I’ve built an example which works for my data, and may use more calculated fields than needed, but it explains the process. I created 2 calculated fields that truncate the created_date and resolved_date fields to Month level: truncCreatedDateMM truncDate('MM',{created_date}) truncRe…

@abacon almost there, thanks for the help. I used the same data I showed above, but February doesn’t match based on your calculation. The created count is 3 when it should be 2. [image]

Merging two date fields into a single date

Q&A

Max May 10, 2023, 6:05pm 4

@DannyV checking back in. Is this still an issue?

Do all your other months work?

YOY data with pre-set date range filters

Topic		Replies	Views
Count columns based on creation date and resolved date in the same table Q&A analysis , quick-sight , calculations	3	938	April 7, 2023
Dynamic Closure Date Categorization Q&A data-source , filters , parameters , quick-sight , dashboard , calculations , Business-Intelligence-Engineer	4	126	May 15, 2024
How to count open tickets by date Q&A formulas , analysis , date , quick-sight , calculations , Business-Intelligence-Engineer	8	576	November 8, 2023
Calculating Monthly Open Tickets Q&A calculations , Business-Intelligence-Engineer	4	57	January 15, 2026
Is there any way where we create a day for an year? Q&A data-source , quick-sight , dashboard , calculations , pivot-table , Business-Intelligence-Engineer	5	193	May 22, 2024

Merging two date fields into a single date

Related topics