CODEWITHSUNDEEP
tableau-api
Someguywhocodes
Someguywhocodes

Reputation: 781

Calculated field doesn't seem to be grouping correctly

I have a dataset which looks somewhat like this;

email       minutes   date
[email protected]   40      10-01-18

[email protected]   60      10-01-18

[email protected]   10      10-01-18

[email protected]   40      10-02-18

[email protected]   60      10-02-18

I have created a calculated field to group the minutes by date, per email. This calculated field is named 'Minutes Worked' and looks like so;

 {FIXED [email], [date] : SUM([minutes])}

I wish to visualize "complete days" which would be Minutes Worked > 80. Here's what I did;

  1. YEAR(date) MONTH(date) on columns.
  2. SUM(Number of Records) on rows.
  3. SUM(Number of Records) on text.
  4. Minutes Worked > 80 on filter.

The problem is that the viz seems to be looking at each row for minutes rather than the grouping per day. I thought my calculated field would handle this but it doesn't seem to be the case. How can I get around this?

Upvotes: 1

Views: 107

Answers (1)

Jose Cherian
Jose Cherian

Reputation: 7707

I think you are confused about how the Fixed LODs work. Fixed LODs are independent of your view. Without the filter, your data will be as below. enter image description here

If you apply the filter, then here is the data in the view enter image description here

There is only a single user who meets the criteria, but there are two records. Based on your description, here is your view which is correct based on the conditions applied. enter image description here You need a different logic to find what you want. If you are looking for number of users who worked more than 80 minutes per day, you can use below calculation, but be mindfull that it is independent of your view. So if you change your view, you might need to change your calculations. This link might be helpful to understand LODs.

   IF  [Minutes Worked] > 80 
        THEN {FIXED [Email],[Date]:COUNTD([Email])} 
        ELSE 0
    END

Upvotes: 2

Related Questions