Using the same XAxis for 2 dates

[Hesloan Viana]

Hey all, i need to create a graph showing the % of questions and asnwer.

But, in database, there is 2 dates, one for the question submission and one for the asnwer.

For example:

 

 

 

 

QUESTION_ID

ASNWER_ID

DATE_QUESTION

DATE_ASNWER

 

 

 

 

1

1

30 JANUARY

31 JANUARY

 

 

2

2

30 JANUARY

02 FEBRUARY

 

 

3

3

30 JANUARY

04 FEBRUARY

 

 

4

4

30 JANUARY

30 JANUARY

 

 

5

5

06 FEBRUARY

09 FEBRUARY

 

 

6

6

06 FEBRUARY

14 FEBRUARY

 

 

7

7

06 FEBRUARY

-

 

 

 

 

So, for this example, i need to show:

In january-> 4 questions and 2 asnwer, so.... 2/4

In february -> 3 questions and 4 asnwer, so... 4/3

But i have two different dates, one for the question and one for the asnwer, and in the X axis i need to show the date_asnwer, so how can i have the sum of all questions if there are 2 different dates

[Khushboo Rabadia]

Seems to be duplicate of this thread -https://community.spotfire.com/questions/using-same-x-axis-2-dates