topic Re: Greater than in set analysis in Management & Governance

Greater than in set analysis

thiago_alessand — Sat, 16 Nov 2024 06:35:23 GMT

Hello,

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

I tried, but not working:

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

Re: Greater than in set analysis

elvis_schwarz — Thu, 14 Feb 2019 17:46:25 GMT

Tenta da seguinte forma:

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

Re: Greater than in set analysis

pradosh_thakur — Thu, 14 Feb 2019 17:46:57 GMT

try the below

if(DataAtendimentoChamadoAtrasadoTI  > DataPrazoChamadoAtrasadoTI , COUNT(NumChamadoAtrasadoTI)
)

I hope you are using it in a table or simillar

Re: Greater than in set analysis

pradosh_thakur — Thu, 14 Feb 2019 17:48:28 GMT

If you could tell us something about it, it would be easier to help as the expression may vary according to that.

Re: Greater than in set analysis

thiago_alessand — Thu, 14 Feb 2019 17:50:58 GMT

Obrigado pelo retorno. Trouxe apenas valor 0.

Re: Greater than in set analysis

thiago_alessand — Thu, 14 Feb 2019 17:53:51 GMT

Thank you for your help.

But, isn't working. I'm using in normal table.

The results was for all columns: "-"

Re: Greater than in set analysis

pradosh_thakur — Thu, 14 Feb 2019 18:01:51 GMT

Can you add some sample data and the output you are expecting.

Re: Greater than in set analysis

thiago_alessand — Thu, 14 Feb 2019 18:07:15 GMT

The results are just 0 or -.

The expected results are 2,1,3,2,9....

Both fields come from database and are in format YYYY-MM-DD (Sample: 14/02/2019)

Re: Greater than in set analysis

pradosh_thakur — Thu, 14 Feb 2019 18:32:42 GMT

Well.. I am not seeing any data so this won't make much sense to me. If you can add a few lines of input data and the output , it would be easier.

Re: Greater than in set analysis

thiago_alessand — Thu, 14 Feb 2019 18:50:37 GMT

There may be something stange in this code, but is because I already tried sometimes without success.

ChamadosAtrasadosTI:
Load
	num_chamado,
    data_abertura,
	categoria,
//    prazo,
    MAKEDATE(YEAR(prazo),MONTH(prazo),DAY(prazo)) AS prazo,
    hora_prazo,
    data_conclusao,
    //data_atendido,
    MAKEDATE(YEAR(data_atendido),MONTH(data_atendido),DAY(data_atendido)) AS data_atendido,
    //dataAtendimento,
    MAKEDATE(YEAR(dataAtendimento),MONTH(dataAtendimento),DAY(dataAtendimento)) AS dataAtendimento,
    horaAtendimento,
    prioridade,
    autor_chamado,
    status,
    dataPrazo;
    

SQL SELECT c.num_chamado, c.data_abertura, c.categoria, (SELECT STR_TO_DATE(prazo, '%d/%m/%Y') FROM complemento WHERE num_chamado = c.num_chamado and prazo is not null 
ORDER BY id_complemento DESC LIMIT 1) AS prazo, (SELECT hora_prazo FROM complemento WHERE num_chamado = c.num_chamado and hora_prazo is not null
ORDER BY id_complemento DESC LIMIT 1) AS hora_prazo, c.data_conclusao,c.data_atendido, DATE(data_atendido) AS dataAtendimento, TIME(data_atendido) AS horaAtendimento,
c.prioridade, c.autor_chamado, c.status, CAST(CONCAT(prazo, ' ', hora_prazo) AS datetime) AS dataPrazo
FROM chamado AS c 
WHERE //DATE(data_atendido) > prazo OR  ( DATE(data_atendido) = prazo and TIME(data_atendido) > hora_prazo)
YEAR(data_abertura) = $(vrAno);

Re: Greater than in set analysis

akhi9219 — Fri, 15 Feb 2019 06:31:33 GMT

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

Re: Greater than in set analysis

Anders_Eriksson — Fri, 15 Feb 2019 07:21:18 GMT

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)