num aggregation inside count

[#1]

Hi everybody ,

i stuck for 2 days, i want to do a num aggregation inside a count but it didn't work

here is my expression

=count( {$ <4={" num(day(today())) "}> }  [Nom Client])

thanks in advance.

[Gysbert_Wassenaar]

In a set analysis expression you must use a field name on the left side of the comparison. So if 4 is not a field name replace it with something that is. Something like: =count( {$ <MyDayNumber={"$(=num(day(today())))"}> }  [Nom Client])

[Peter_Cammaert · Accepted solution]

Change " num(day(today())) " into "$(=num(day(today()))) "

Best,

Peter

[#4]

i tried both and it works but the result is not correct

what im trying to do is obtaining total commands of today for distinct clients

count( {$ <"$(=num(day(date(today()))))"="$(=num(day(date([Date CA]))))"> } distinct [Nom Client])

[MK_QSL]

What is Total Commands? Is it a field?

[#6]

sorry i made a mistake , a client can get many commands but i want to get number of distinct clients for to day who has made commands , nom client and date ca are fields

thx

[Peter_Cammaert]

You should have an OrderNumber and an OrderDate somewhere. If I read your requirement correctly, the following should do:

=count({<OrderDate={"$(=today())"}>} distinct OrderNumber)

Change my fieldnames in yours. Then put this expression in a Straight table and add CustomerName as dimension.

Peter

[Peter_Cammaert]

How about this:

=count(aggr(count({<[Date CA]={"$(=today())"}>} OrderNumber), [Nom Client]))

Replace OrderNumber with the correct field name.

Peter

[Peter_Cammaert]

Or maybe even simpler?

=count({<[Date CA]={"$(=today())"}>} distinct [Nom Client])

Best,

Peter

[#10]

it gives me the same result for day,month and total clients, so it not making selections