Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
how do i calculte count for some field for the max day?
emp:
count(distinct(myfield)) , i want to show only for the max date that i have ( the same if i chose the date manule).
thanks'
yarin.
Define a variable like:
vMax =Date(Max(DateField)) // Put '=' in the definition of the variable
Then expression should be like: =Sum({<DateField={'$(vMax)'}>} Distinct YourField)
count({<datefield={$(=Max(datefield))}>} distinct myfield)
Hi,
Try like this
Create a variable like this
vMaxDate = Date(Max(DateDimensionName))
Note: your DateDimension values and Today() should be in same format
Now use below expression
=Sum({<DateDimensionName={'$(vMaxDate)'}>} Distinct DimensionName)
If you don't want to use variables then try like this
=Sum({<DateDimensionName={'$(=Date(Max(DateDimensionName)))'}>} Distinct DimensionName)
Hope this helps you.
Regards,
Jagan.