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
10 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 13,940 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,200 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,200 points
948 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,200 points
36 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,200 points
30 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,360 points
16 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
23 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.