Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone
This is my first question this forum. I have a table which contains some student and unit data based on their teaching period.
The table depicted as follows,
Student and Unit | Teaching Period 1 | Teaching Period 2 | Teaching Period 3
Unit 320 | 60.1 | 58.1 | 60.5
David | 55.3 | 65.3 | 53.1
Asker | 80.3 | 56.6 | 63.7
Piter | 75.3 | 63.5 | 49.2
I would like to colour code the student marks based on the unit average mark which is stated in the first row of the table.
PS- There can be many teaching periods that means columns are dynamic depending on user selection from filters.
Expected output:
Student and Unit | Teaching Period 1 | Teaching Period 2 | Teaching Period 3
Unit 320 | 60.1 | 58.1 | 60.5
David | 55.3 | 65.3 | 53.1
Asker | 80.3 | 56.6 | 63.7
Piter | 75.3 | 63.5 | 49.2
Any help or advice is very appreciated.
Thanks.
can you shares some sample data and expressions you used for these teaching period1, 2, and 3? Is this how you data going to be?
Following links may help you to understand.....
You want to effect this in row level?
Hi Anil
Yes, that is right. I need to colour the background of the cell in each column based on the unit average mark and teaching period.
Hi,
You can find the your answer in chart properties : visual cues.
Regards,
Vinod.
Hi Sahan,
In Expression add -> text color by condition
Expression 1: if([ Teaching Period 1 ]>=55 and [ Teaching Period 1 ]<60,rgb(255,0,0),
if([ Teaching Period 1 ]>61,rgb(0,255,0)))
Expression 2: if([ Teaching Period 2 ]>=55 and [ Teaching Period 2 ]<58,rgb(255,0,0),
if([ Teaching Period 2 ]>59,rgb(0,255,0)))
Expression 3: if([ Teaching Period 3 ]>=49 and [ Teaching Period 3 ]<54,rgb(255,0,0),
if([ Teaching Period 3 ]>61,rgb(0,255,0)))