Hello everyone,

I'm angry with Tableau right now because I can't do something that in my mind appear very easy and also in excel appear easy as well.

I think that I have a mindset issue and I hope some of you can help to clarify the theory about WHY I can't do some so easy in my mind.

I have a table with 2 columns both in format Date.

I need to verify if the value in the column 2 is higher that the minimum of the column 1. Then sum the number of cells that are true.

WHAT I DO EASILY IN EXCEL

I have a lot of way to do that in excel, COUNTIF for exaple, but I go with the dumbest way as if I'm using Tableau.

I create a column "Result" that give me the result of IF and then sum.

Result: =IF(B2<MIN(A2:A146);1;0)

Sum: =SUM(C:C)

(I attach the file even if it's not so useful)

EASY

WHAT I CAN'T DO EASILY IN TABLEAU

If I use in tableau:  IF [Date 2]<MIN([Date 1]) THEN 1 ELSE 0 END

It's of course a mistake because I cannot mix aggregate and not-aggregate arguments but... WHY?

And even if I use ATTR for date 2, then my calculation is aggregated and I can't SUM because I can't SUM that is aggregated.

W(hy)TF?

In particular I very often have the same issue with aggregation/non-aggregation issue expectially because if I use a value from another data source this will be usable only with ATTR.

I created a variable that is the first day of the last suitable week in a specific data source that MUST be used transversely in all other data sources.

I do the same with the last dat of the last suitable week.

I "just" need to check if, in another data source a date is between these two dates but, as I said, if I use them I can use them only inside ATTR().

I would like to know:

1) a solution to my issue

2) why it's so difficult do something easy. Is there a reason?