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
33 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
411 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
758 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
40 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
103 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,326 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
49 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
755 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
37 views