topic Re: Show only last 10 business dates in App Development

Show only last 10 business dates

Anjaneya_prasad_Chattu — Fri, 09 Aug 2024 11:35:01 GMT

Hello everyone,

I have a question about displaying only the last 10 business dates in the filter pane. But i want all business dates in backend. Here are the business dates I have so far:

Month	Business Date
January	2024-01-31
February	2024-02-29
March	2024-03-29
April	2024-04-30
May	2024-05-31
June	2024-06-28
July	2024-07-31
August	2024-08-01
August	2024-08-02
August	2024-08-05
August	2024-08-06
August	2024-08-07
August	2024-08-08
August	2024-08-09

I need to filter the data to show only the last 10 business dates. How can I set this up in the filter pane?

Thank you!

Re: Show only last 10 business dates

Padma123 — Fri, 09 Aug 2024 06:05:51 GMT

Try This.....

table2:

load Month,
[Business Date]
where not Match(WeekDay([Business Date]),'Sat','Sun') and RowNo()<10;

load * Resident table1
order by [Business Date];

Re: Show only last 10 business dates

Kushal_Chawda — Fri, 09 Aug 2024 13:20:19 GMT

@Anjaneya_prasad_Chattu

If you want last 10 business date excluding missing dates then try below

=aggr(only({<Date ={">=$(=date(max(Date)-9))<=$(=date(max(Date)))"}>}Date),Date)

If you want last 10 business date including missing dates then try below

=aggr(only({<Date ={">=$(=max(Date,10))<=$(=max(Date))"}>}Date),Date)

Re: Show only last 10 business dates

Anjaneya_prasad_Chattu — Fri, 09 Aug 2024 16:20:20 GMT

Thank You @Kushal_Chawda , It worked.