6 Replies Latest reply: May 26, 2014 6:54 PM by jose luis rodriguez zamora RSS

    Set Analysis - Error in set modifier ad hoc element list

      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