topic Re: how to avoid repeated values in a maxdate to -30 days in App Development

how to avoid repeated values in a maxdate to -30 days

ramrongala — Sat, 16 Nov 2024 00:23:04 GMT

Hi expertise,

MY TABLE:

data:
load *Inline [
Ticket_ID,Serial_No,Date
1,123,01/01/2021
2,234,10/01/2021
3,123,25/01/2021
4,234,27/02/2021
5, 456,28/02/2021

];

Requirement: need to display the count of ticket repeated for Serial_No between max(Date) to -30 days

Output should be: here max date is 28/02/2021, last 30 days no repeated serial no so output will be "0" .

i have tried below code(backend):

data:
load *Inline [
Ticket_ID,Serial_No,Date
1,123,01/01/2021
2,234,10/01/2021
3,123,25/01/2021
4,234,27/02/2021
5, 456,28/02/2021

];
NoConcatenate

data1:
load *,
Autonumber(Ticket_ID,Serial_No) as [Sequence No],
date(Date) as updated_Date
Resident data;
Drop Table data;

Expression: count( {<[Sequence No]-={1},Date={">$(=Date(Max(updated_Date)-30))<=$(=Max(updated_Date))"}>} Ticket_ID)

My output:

here serial no 234 also should be skip, but its appear

please help me how to archive this.

Re: how to avoid repeated values in a maxdate to -30 days

Anil_Babu_Samineni — Wed, 24 Mar 2021 20:09:50 GMT

Perhaps this in design?

Count({<Date={">=$(=Date(AddMonths(Max(Date), -1)))<=$(=Date(Max(Date)))"},
Ticket_ID={"=Count({<Date={>=$(=Date(AddMonths(Max(Date), -1)))<=$(=Date(Max(Date)))}>} TOTAL <Serial_No> Serial_No)>1"}>} Serial_No)

Re: how to avoid repeated values in a maxdate to -30 days

ramrongala — Thu, 08 Apr 2021 05:08:48 GMT

Hi Anil,

Thank you for providing solution , its working i have done some changes as per my requirement.

but reload time very huge(around 3 hours takes time) when i used above code(see me code above).

so any idea how we can reduce that load time or any other way to archive this.

Re: how to avoid repeated values in a maxdate to -30 days

Anil_Babu_Samineni — Wed, 21 Jul 2021 06:11:35 GMT

I would recommend to create new ticket for this with more information.