Jump to content

Using the same XAxis for 2 dates


Hesloan Viana

Recommended Posts

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...