Milestone automatic

0 votes
I have students data and their marks, details, etc. I want to add 5% marks set for each class greater than their previous exam avg marks. So i want to set the marks for each student for the teacher to evaluate students. how to do this?
May 7 in Tableau by Karthick
11 views

1 answer to this question.

0 votes
Hi Karthick,

For example, you can add 0.5 avg for the next exam overall grade of students.

1. Create a calculated field to get the current avg for all students.

current avg = AVG([Grade])

2. Create another calculative field as

target avg = [current avg] + 0.05*[current avg].

3. Calculative field to compare whether the reached the milestone/target.

IF [Current avg] >= [target avg] THEN "Reached"

ELSE "Not Reached"

END

The above field can help you see whether the class has reached the target.

Hope it helps you.
answered May 7 by Cherukuri
• 17,630 points

Related Questions In Tableau

0 votes
1 answer

Performing automatic read and update data source from a web data connector

Dashboard on Tableau Public can only be ...READ MORE

answered Aug 27, 2018 in Tableau by Atul
• 10,240 points
18 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,309 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
48 views
+2 votes
1 answer
0 votes
1 answer

How to deploy Liberty packaged server automatic delivery

Here is a concept regarding your query. It ...READ MORE

answered Jul 11, 2018 in DevOps Tools by Atul
• 10,240 points
36 views
0 votes
1 answer

AWS:Which automatic gears help us with spinup services?

API tools that are normally used for ...READ MORE

answered Jul 20, 2018 in Cloud Computing by DragonLord999
• 8,380 points
20 views
0 votes
1 answer

Configuring a Windows 10 IoT App for Automatic Restart

Have you tried using powershell right after ...READ MORE

answered Oct 10, 2018 in IoT (Internet of Things) by anonymous2
• 4,260 points
34 views