6 Replies Latest reply on Jul 25, 2016 3:38 AM by Hussam Ahmed

# How to calculate charts by combining 2 date columns

Hi I have ticket numbers and ticket create date column and ticket resolved column as shown below.

Expecting a result as below

Total 9 tickets based on created dates may = 3 and June = 6 but we have some tickets closed on June. So I am expecting a result as shown below. I dont have any idea on how to acheive this. Tried breaking my head but no use

• ###### 1. Re: How to calculate charts by combining 2 date columns

Reason is I dont know which axis I should use for bringing the month column as shown in the excpected result screenshot. I have attached a sample excel

• ###### 2. Re: How to calculate charts by combining 2 date columns

Hi Vijay,

Here is what I did with your sample data set, I measure names and values (see workbook attached) and I used a LOD calcutation however it seems to add up the values for 'may' in the 'count resolved'. If you have a suggestion?

Since you can do this in excel I maybe do so, and then connect to tableau so you can use a extra measure field "number of event resolved"/ "number of event created"

• ###### 3. Re: How to calculate charts by combining 2 date columns

Workbook mentioned above*

• ###### 4. Re: How to calculate charts by combining 2 date columns

Hi Stephane,

The number of tickets closed on the month of May is 1 and not 3..

we could actually create a chart for # of tickets CREATED every month. # of tickets RESOLVED every month but as separate graphs / tables...

But the requirement here is... I have to bring both metrics in the same graph.. For example: The month MAY has 3 tickets CREATED but only one got closed in the same month..

• ###### 5. Re: How to calculate charts by combining 2 date columns

The below answer worked out greatly..

• ###### 6. Re: How to calculate charts by combining 2 date columns

hello vjay

could you please share the work book .?

belive it or not.. im breaking my head right now as im facing the same problem working with the same data set from lira database like yours.

i have tried the solution that you have mentioned in the How to combine 2 different charts? but im still getting the wrong number of resolved issues..!