Hesloan Viana Posted March 17, 2020 Share Posted March 17, 2020 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 More sharing options...
Khushboo Rabadia Posted March 24, 2020 Share Posted March 24, 2020 Seems to be duplicate of this thread -https://community.spotfire.com/questions/using-same-x-axis-2-dates Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now