Specific grouping in Tableau HeatMaps

0 votes

I would like to join an Excel dataset which contains:

  • The name of a course
  • The ID of a problem from this course (many pb per course)
  • The ID of a user that has submitted an answer for this problem from this course
  • the grade that the user has obtained at this pb from this course

What I try to achieve:

  • Axe x : Every problem for each course
  • Axe y : value of the grade (from 0 to 100)
  • Axe z : Number of user for each Note value

So, if for the pb A of the Course A, the dispersion is like this:

  • 9 users have 100
  • 21 users have 80
  • 40 users have 60
  • 5 users have 40
  • 10 users have 20
  • 15 users have 0

I would like to have every value displayed on a bar and each value would be displayed by a square. Each square having a different color regarding the value represented. So, here, 60 would be darker than any other value (since the amount of people having this grade is the greatest) and 20 would be clearer than 0, 60, 80 & 100 but darker than 40 Then, just next to this bar, the same for the pb B & C. 

Aug 28, 2018 in Tableau by Nitish
• 630 points
40 views

1 answer to this question.

0 votes
  1. Move grade, name of a course, ID of a problem to Dimensions.
  2. Put name of a course and ID of a problem on the columns.
  3. Put grade on the rows.
  4. Find a drop down list on the Marks tab and select Square.
  5. Put COUNT(ID of a user) on the Color on the Marks tab
answered Aug 28, 2018 by Naruto
• 710 points

Related Questions In Tableau

0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 29, 2018 in Tableau by QueenBee
• 1,810 points
689 views
0 votes
1 answer

How to group bins in a tableau histogram?

One of the simple way is by ...READ MORE

answered Apr 3, 2018 in Tableau by xyz
• 1,550 points
1,135 views
0 votes
1 answer

Dropdown to change x-axis in Tableau

You need to create a  str datatype parameter ...READ MORE

answered Apr 3, 2018 in Tableau by QueenBee
• 1,810 points
58 views
0 votes
1 answer

How to use a IFF statement in Tableau

Use this syntax -  IIF(([Avg_sale] > [Today]),STR([Avg_sale ...READ MORE

answered Apr 5, 2018 in Tableau by QueenBee
• 1,810 points
158 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
2,004 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
89 views
+2 votes
1 answer
0 votes
1 answer

How to refresh the extracted data source automatically in Tableau Desktop?

Hi AwesomeSauce, This comes up every so often!  Tableau ...READ MORE

answered Aug 13, 2018 in Tableau by Naruto
• 710 points
1,209 views
0 votes
1 answer

How to make number of equally sized bins in tableau?

You can simply right click on the ...READ MORE

answered Aug 16, 2018 in Tableau by Naruto
• 710 points
57 views