2 Replies Latest reply on Sep 3, 2016 8:12 PM by beverly

    Cannot see Aggregate data in Portal

    FergyMitch

      I have a stock trading application that uses a Dashboard opening page to show a number of metrics in portals looking at the various tables Watchlist, Tips, Prices, Orders etc. The Dashboard table has a single field  "LINK"=1 that links it to all the related tables.

       

      I also have a table of StkCycles that captures the Stk code, date, and Stk price increase for each stock based on certain criteria, and I use a Summary Field "Num Cycles" and a calculation field "Num Cycles by Stk" to summarise the multiple records for each stock as shown below.

      StkCycle.jpg

      This displays the summaries as required in the StkCycles layout, but I cannot get the "Num Cycles" or "Num Cycles by Stk" data to display in the Dashboard portal.

      I have sorted the Portal by the Stock Code as shown below.

      PortalSort.jpg

      Any ideas on why this does not work - or suggestions on how I could better approach this?

      Thanks