AnsweredAssumed Answered

Cannot see Aggregate data in Portal

Question asked by FergyMitch on Sep 3, 2016
Latest reply on Sep 3, 2016 by beverly

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

Outcomes