Arcade expression for percentage and status

[BethTobin]

Hi! 

I need help with advanced formatting a list element in my dashboard. I have a data set that contains the number of completed questionnaires per topic and the target number of questionnaires. How do i write an arcade expression to calculate the progress as a percentage for each topic (Questionnaires completed/Target) and state whether the topic is 'outstanding' (highlighted in red) or 'achieved' (highlighted in green) based on the percentage. 

Thank you 🙂

Topic	Questionnaires completed	Target
1	1	17
2	14	17
3	12	17
4	14	17
5	10	17
6	14	17
7	21	17
8	16	17
9	8	17
10	14	17
11	12	17
12	15	17
13	13	17
15	11	17
16	13	16
17	17	16
18	22	16
19	15	16
20	12	16
21	26	16
22	17	16

[jcarlson]

Is your example table the way the data itself is organized? What's the source table look like? Assuming your table is an accurate representation, here's what it could look like:

// calculating your percentage

var q_complete = $datapoint['questionnaires_completed']
var q_target = $datapoint['target']

var percentage = (q_complete / q_target) * 100

// color based on percentage; replace with whatever hex codes you like

var status_color = Iif(
  percentage == 100,
  '#ddffdd', // green
  '#ffdddd' // red
)

// returning the values

return {
  backgroundColor: status_color,
  attributes: {
    percentage
  }
}

Then in your list item template, reference {expression/percentage} to pull in the percentage value.

[BethTobin]

I have another follow on question from the above. I am trying to have a variable called 'status' indicating whether the topic has still got outstanding questionnaires. I am also trying to change the text colour of the percentage value. The below 'status_colour' expression does not work. Neither does my IIF statement for the status variable, only 'outstanding' is returned even if the value is >=100. 

var q_complete = $datapoint['questionnaires_completed']

var q_target = $datapoint['target']

var percentage = Round((q_complete / q_target) * 100) +'%'

var status = IIf(percentage >=100, 'Achieved', 'Outstanding')

var status_colour = Iif(

  percentage >= 100,

 '#ddffdd',

'#ffdddd'

)

return {

  textColor: '',

  backgroundColor: '',

  separatorColor:'',

  selectionColor: '#30c5ad',

 

 attributes: {

    percentage,

    status_colour,

    status

  }

}