set analysis

[DGAL1]

i want to get count of item ids that the store had for yesturday 

[Ahidhar]

count({<Date={"$(=Date(today(),'DD/MM/YYYY') -1)"}>} item_id)

[DGAL1]

The above formula gives me the total of 56,113 and i want only yesterday as for 2023 i have 41065 and 2024 i have 15,048 

[vinieme12 · Accepted solution]

as below

=count({<Date={"$(=Date(Max(Date)-1,'DD/MM/YYYY'))"}>} item_id)

[vinieme12 · Accepted solution]

=count({<Date={"$(=Date(Max(Date)-1,'DD/MM/YYYY'))"}>} item_id)

[DGAL1]

Thanks Vineeth Pujari , the above has worked for me

[vinieme12]

Happy to help, please make the response as solution to close the thread