Using the same X axis for 2 dates

[Hesloan Viana]

Hey all, i need to plot on a graph the % of asnwers / total questions per month.

But i have a problem, the date of my XAxis is the date of the asnwer, and i can have a asnwer on 01 of march but the question need to count on february.

For example:

 

 

 

ID Question

ID Asnwer

Date_Question

Date_Answer

Rank

 

 

 

 

1

1

18 February 2020

03 March 2020

 

1

 

 

 

2

2

18 February 2020

22 February 2020

1

 

 

3

3

01 March 2020

02 March 2020

 

1

 

 

 

4

4

 

30 January 2020

 

3 February 2020

 

1

 

 

 

 

 

On my graph, i need to show:

For january: 1 question and 0 aswner

For february: 2 questions and 2 answer

For March: 1 question and 2 aswner

 

But how i can do this with 2 different dates on the same graph

[Khushboo Rabadia]

One easy solution would be to unpivot the data table to have dates of both question/answer in one column

https://docs.tibco.com/pub/sfire-analyst/10.8.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/data/data_unpivoting_data.htmrhhlterm=unpivot&rhsyns=%20