AnsweredAssumed Answered

Analytics Sort by Metro Name Summary then by Rank Listing

Question asked by MacMak on Jan 12, 2012
Latest reply on Jan 13, 2012 by philmodjunk

Title

Analytics Sort by Metro Name Summary then by Rank Listing

Post

Hello.

    I have records in one table that contain metro names, id's and ranking from another table called 'Metros'. They are related by a metros foreign key.

I have an analytics layout that displays Metro Names from the 'Metros" Table Vertically and a MainTable::metro_summary which contains a Summary of metro id's from a foreign key field in the main table.

I need to be able to sort each metro but also sorted by a rank number that each metro id is associated with so the top will be metro number 1 then metro number 2 etc. The chart type is a horizontal bar.

Thanks again and any help would be appreciated.

 

Outcomes