topic Finding of MAX date in Dashboards & Analytics Discussions

Finding of MAX date

mhornak — Wed, 29 Nov 2023 09:25:15 GMT

Hello,

I would ask you how to can find MAX date from listing table where are several dates.

I do not know which date is last, it could be from yesterday, 3 days ago... it is too flexible.

I tried to use max function but I can not define second parameter.

Something like MAX(Date, 0), but I should use the two largest values.

I just need to mark line with max date in insight.

Please could anybody help me?

Thanks

Re: Finding of MAX date

Shashidhar — Wed, 29 Nov 2023 14:39:35 GMT

Hi,

Below is the video link to calculate MAX date from a listing table. Please verify once.

Finding MAX Date From A Listing table

Re: Finding of MAX date

mhornak — Thu, 30 Nov 2023 07:25:29 GMT

Thank you.

I tried it but unfortunately I get error below. I can not save schema.

Re: Finding of MAX date

Shashidhar — Thu, 30 Nov 2023 12:07:48 GMT

Hi,

Can you please elaborate how you created analyzer table with any screenshots which helps to resolve this error? I would appreciate if you can mention your requirement with more details.

Regards,

Shashidhar.S