Greater than in set analysis

[thiago_alessand]

Hello,

How can I use greater than signals with 2 date fields, in set analysis?

I tried, but not working:

COUNT({<DataAtendimentoChamadoAtrasadoTI = {">DataPrazoChamadoAtrasadoTI"}>}NumChamadoAtrasadoTI)

[akhi9219]

Dear Thiago,
TRY this
COUNT({<Date_field_on-which-filter-is-to-be-applied=
{">=$(=Min(Datefield))<=$(=Max(Datefield))"}>}NumChamadoAtrasadoTI)

check the date format is same when MIN and MAX Function is applied on datefield sometimes it is different from "Date_field_on-which-filter-is-to-be-applied" that is why you can't find the correct data.

Regards,
Akhilesh

[Anders_Eriksson]

NO, don't replace a set analysis with if-statements!
The set analysis is executed once before rendering visualization.
If-statement is executed on every data row for every presentation row in your visualization.
The degradation of performance can be horrifying.

To use dates in set analysis you must use the text representation of the date.
Something like;

COUNT({<DataAtendimentoChamadoAtrasadoTI = {">$(=Text(Date(DataPrazoChamadoAtrasadoTI)))"}>} NumChamadoAtrasadoTI)