That won't affect a thing, you could always use your exsting fields in other charts, and use only your new field in the bar chart you're willing to make :
If you have other answers, you can add Everything, like THIS. and do NOT CHANGE A THING in your other charts, they won't be affected.
LOAD `survey_id`,
`lender_offer_id`,
`survey_question_id`,
'Strongly Agree' as Answer,
`answer_text`
where `answer_text` ='Strongly Agree' or `answer_text`='Excellent'
;
SQL SELECT `survey_id`,
`user_id`,
`lender_offer_id`,
`batch_meta_data_id`,
`survey_question_id`,
`answer_text`
FROM SURVEY;
LOAD `survey_id`,
`lender_offer_id`,
`survey_question_id`,
'Agree' as Answer,
`answer_text`
where `answer_text` ='Agree' or `answer_text`='Above Average'
;
SQL SELECT `survey_id`,
`user_id`,
`lender_offer_id`,
`batch_meta_data_id`,
`survey_question_id`,
`answer_text`
FROM SURVEY;
LOAD `survey_id`,
`lender_offer_id`,
`survey_question_id`,
'Other as Answer,
`answer_text`
where `answer_text` <>'Strongly Agree' and `answer_text`<>'Excellent' and `answer_text` <>'Agree' and`answer_text`<>'Above Average'
;
SQL SELECT `survey_id`,
`user_id`,
`lender_offer_id`,
`batch_meta_data_id`,
`survey_question_id`,
`answer_text`
FROM SURVEY;
Now in your bar chart, If I fully understand, you want to divide by the count of these 2 answers (strongly agree, and agree?)
Do as follow:
As dimension; choose your newly created field: Answer
As a measure:
count(lender_offer_id ) / count({<Answer={'Agree','Strongly Agree'}>}total lender_offer_id )
and format it as %.
