I have a dataset that deals with Surveys. So the "survey status column" has text data differentiating surveys - complete vs incomplete. I need to calculate a percentage of target surveys reached which will be equal to sum of "Survey status column" ( complete + incomplete) / 18000 target number . I have tried different syntax but am unable to figure it out. Since my numerator is a text total how will the calculation syntax work?
Hello Jim,
Your post helped me a lot!! I used the calculation "If there are other statuses then you would modify the formula
(sum(if (status)='Complete' or attr(status)='Incomplete' then 1 else 0 end)/18000" It worked!!
However, can you help me understand how to stratify this formula to monthly target achieved ?
I have also been trying to make a dual axis bar chart by placing the following two on one sheet. I don't understand why it is not working.
I used the calculation : CONTAINS([Exit Message],"complete")OR CONTAINS([Exit Message],"incomplete") to compute the following bar chart
When I try to use a dual axis bar chart it turns it automatically into a scatter plot .
The Total survey is now showing up as 'True' instead of a total number showing in screenshot labelled sheet 3. Can you please help me understand what I am doing wrong?
Can't thank you enough !
Best,
Sarah.
