Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What I want to do is display chart data for the last date in a table.
I've tried all of the various methods to get this to work in a chart as an Expression, but either I get an error or 'No data to display'.
=sum({1<T_PageViewDate = {'$(=Max(T_PageViewDate))'}>} T_ErrTypTotal) == no data
=sum({1<T_PageViewDate = {$(=Max(T_PageViewDate))}>} T_ErrTypTotal) == no data
=sum({1<T_PageViewDate = {=Max(T_PageViewDate)}>} T_ErrTypTotal) == error
=sum({1<T_PageViewDate = {=Max(T_PageViewDate)}>} T_ErrTypTotal) == error
Even using the Set Analysis wizard, the result yields "No data"
=Sum({$<T_PageViewDate={$(=Max(T_PageViewDate))}>}T_ErrTypTotal)
If I do a simply = Sum(T_ErrTypTotal), it works, but I get all of the data, not just for the date I want.
Thanks,
-- Matt
Could be a problem with date format mismatch, try using an appropriate date format with your dollar sign expansion:
=sum({1<T_PageViewDate = {'$(=Date(Max(T_PageViewDate)))'}>} T_ErrTypTotal)
if T_PageViewDate is formatted with your standard date format (otherwise state the format needed in Date() function as second argument.
Hi Matt,
Would it be possible to attach a reduced version(scrambled if it's sensitive data), as it will be easier to test.
Cheers!
I don't know how to do a reduced set or scramble it. Sorry...still quite a newbie.
Could be a problem with date format mismatch, try using an appropriate date format with your dollar sign expansion:
=sum({1<T_PageViewDate = {'$(=Date(Max(T_PageViewDate)))'}>} T_ErrTypTotal)
if T_PageViewDate is formatted with your standard date format (otherwise state the format needed in Date() function as second argument.
That worked!! Thanks a ton!
How about -
sum(aggr(max({$<T_PageViewDate= p(T_PageViewDate) >} T_ErrTypTotal),id))
?
Good afternoon,
could please help me, I have the same problem but I can not seem to solve.
with the following problems:
= Sum ({1} = {$(=Date(Max(FechaFacturacion)))}> <FechaFacturacion ItemValorVenta)
= sum ({<FechaFacturacion={$(=(Min(FechaFacturacion)))}> ItemValorVenta)
= Sum ({1} = {'$(=Date(Max(FechaFacturacion)))'}> <FechaFacturacion ItemValorVenta)