Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
Iam new here in this community, i want help to separate two values deepens on max and min date.
the expression for max date: (if the date is max then count id)
=count(distinct(if(max(date), id)
the expression for min date: (if the date is min then count id)
=count(distinct(if(min(date), id)
Thnx for help
=count({<Date={"$(=Date(max(Date)))"}>}ID) -> For Max
=count({<Date={"$(=Date(min(Date)))"}>}ID) -> from Min
Thank you Kushal , but the code dosn't work !
May be the reason date format? What is the date format from your Model
=count({<Date={"$(=Date(max(Date),'YourFormatHere'))"}>}ID) -> For Max
=count({<Date={"$(=Date(min(Date),'YourFormatHere'))"}>}ID) -> from Min
=count({<Date={"$(=Date(max(Date),'DD/MM/YYYY'))"}>}ID) -> For Max
=count({<Date={"$(=Date(min(Date),'DD/MM/YYYY'))"}>}ID) -> from Min