Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to count the number of cars sold 'yesterday' after I refresh my dashboard on a daily basis.
How do I show this in a straight table and in a text object?
The expression I have tried is;
=count(distinct(if (InDay ([Cars]='Sold, Today(), -1), [Car Id], )))
Many thanks
Hi All,
thanks for your comments.
I used
=count(distinct(if(Inday([Cars], Today(), -1) and [Car status]= 'Sold', [Car type], )))
May be this:
=Count({<Date = {"$(=Date(Max(Date) - 1))"}>}DISTINCT [Car Id])
try,
count({<Cars ={'Sold'},Date ={"$(=date(today()-1,'Yourdateformat'))"}>} distinct [Car Id])
try this
=Count({<Date = {"$(=max(Date)-1)"}>}Distinct Carid)
Hi
count({<Cars ={'Sold'},Date ={"$(=Date(Max(Date) - 1))"}>} distinct [Car Id])
Hi All,
thanks for your comments.
I used
=count(distinct(if(Inday([Cars], Today(), -1) and [Car status]= 'Sold', [Car type], )))