Select Hub_Name__r.Name hubName, Account__r.Name accName, Count(ID) FROM Survey_Results__c WHERE Survey_Date__c = THIS_MONTH Group By Hub_Name__r.Name, Account__r.Name ORDER By Hub_Name__r.Name ASC, Account__r.Name ASC

<style>

        #nav {
        width:15%;
        float:left;
        padding:5px;
        color:black;
        }
        
    </style> 

<div id="nav">
            <apex:pageblock tabStyle="License__c" >
                <apex:pageBlockSection title="Options:" columns="1" collapsible="false">
                    <apex:inputCheckbox value="{!showAll}">
                        Show All Licensed
                        <apex:actionSupport event="onchange" rerender="thePage" status="tbloading"/>
                    </apex:inputCheckbox>
                </apex:pageBlockSection>
                <apex:pageBlockSection title="Licenses:" columns="1" collapsible="false">
                    <apex:outputPanel >
                        <apex:selectList id="statelist"  
                                         value="{!States}" 
                                         multiselect="true" 
                                         size="10" 
                                         style="width: 100%;overflow-x:auto;overflow:auto;">
                            <apex:selectOptions value="{!items}"/>
                        </apex:selectList>
                    </apex:outputPanel>
                </apex:pageBlockSection>
                <apex:pageBlockSection columns="2">
                    <apex:commandButton action="{!stateFilter}" rerender="thePage" title="Filter" value="Filter" status="tbloading">
                        <apex:param name="offsetsize" assignTo="{!offsetsize}" value=""/>
                        <apex:param name="AccRendered" assignTo="{!AccRendered}" value="FALSE"/>
                    </apex:commandButton>
                    <apex:commandButton action="{!resetFilter}" rerender="theForm" title="Reset" value="Reset" status="tbloading">
                        <apex:param name="offsetsize" assignTo="{!offsetsize}" value=""/>
                        <apex:param name="AccRendered" assignTo="{!AccRendered}" value="FALSE"/>
                        <apex:param name="bcsPaging" assignTo="{!bcsPaging}" value="TRUE"/>
                        <apex:param name="showAll" assignTo="{!showAll}" value="FALSE"/>
                    </apex:commandButton>
                </apex:pageBlockSection>
            </apex:pageblock>
        </div>

Select Id, Name, User__r.Name, 
(Select Id,Account__c,Account__r.Name,Hub_Name__r.Name FROM Account_Counselors__r), 
(Select Name FROM Licenses__r) 
FROM BCS__c WHERE Inactive__C = FALSE

trigger ININRelatedToFix on Task (after Insert, after Update) {
    
    //Get Record Type    
    RecordType Five9Rec = [select id from RecordType where name = 'Five9 Call' AND sobjecttype = 'Task' limit 1];
    system.debug('RecordType= '+Five9Rec.Id);
    
    //Create List for bulkified update
    List<Task> taskList = new List<Task>();
    
    //Loop through each task handed to trigger
    for (Task T : Trigger.new) {
        
        //If Call is related to Employee Session instead of Employee
        //*******************
        If(T.What.Type.equals('Employee_Session__c') && T.RecordTypeId == Five9Rec.Id){
            
            //Get the employee
            Employee_Session__c Emp = [Select Employee__c FROM Employee_Session__c WHERE ID = :T.WhatId];
            
            //Fix Relationship
            T.WhatId = Emp.Employee__c;
            taskList.add(t);
        }
    }
    
    //Builify Update
    update tasklist;
}

global class BCI_Account_State_Count_Rollup implements Schedulable {
/*
Created by MM - 1/25/2016
Purpose - count the state field for each active employee on 
an account and update the corresponding state field count
on the account page. 
*/

//Used for aggregrateresults
Public Summary[] Summaries { get; set; }

//Make class schedulable    
global void execute(SchedulableContext ctx) {        
    CronTrigger ct = [SELECT Id, CronExpression, TimesTriggered, NextFireTime
                      FROM CronTrigger WHERE Id = :ctx.getTriggerId()];


    //Create Set with fields from Account page.
    Set<String> statesAcct = new Set<string>{
        'AL','AK','AZ','AR','CA','CO',
            'CT','DE','FL','GA','HI','ID',
            'IL','IN','IA','KS','KY','LA',
            'ME','MD','MA','MI','MN','MS',
            'MO','MT','NE','NV','NH','NJ',
            'NM','NY','NC','ND','OH','OK',
            'OR','PA','RI','SC','SD','TN',
            'TX','UT','VT','VA','WA','WV',
            'WI','WY',
            //Commonwealth/Territories
            'DC'};


                //Create List of active accounts
                list<account> myAccounts = new list<account>();
    myAccounts = [Select ID, Name from Account WHERE Type = 'Client'];

    //Create list to bulkify update command at end of loop
    list<account> accountsToUpdate = new list<account>();

    //Get active employee counts for every account.
    //Getting all at once to limit SOQL queries. 
    Summaries = new List<Summary>();

//CODE THAT IS BREAKING DUE TO SOQL LIMIT
        AggregateResult[] groupedResults = [SELECT COUNT(ID) ct, State__c st, Account__c acct FROM Employees__c WHERE Type__c = 'Client' AND Inactive__c != 'X' GROUP BY Account__c,State__c];
//END BROKEN CODE

    for (AggregateResult ar : groupedResults) {
        Summaries.add(new Summary(ar));
    }


    //Loop MyAccounts
    for ( Account a : myAccounts ){

        //Create map of specific account aggregrate results per state. 
        Map<String, integer> aggregateAcct = new Map<String, integer>();


        //Loop - extract aggregrateResult data just for current account. 
        for(Summary s : Summaries ){
            //system.debug('Summary' + s.acctid);
            //system.debug('Account' + a.Id);

            if(s.acctId == a.id){
                aggregateAcct.put(s.stateName,s.stateCount);
                //System.debug('aggregateAcct - ' + s.stateName + '-' + s.stateCount); 
            } 
        }
        //End Loop - Summaries

        //Create State Name to State count field Map
        Map<String, integer> stateCount = new Map<String, integer>();

        //Link the state count to the field name that is used on the Account object 
        //This way we only get values for states that we have fields for on Account object.
        for(String st : statesAcct){
            StateCount.Put(st, aggregateAcct.get(st));  
        }

        //Now update each state field using our stored values. 
        //Values in StateCount map are now StateAbbreviation and Count

        a.AK__c = stateCount.get('AK');
        a.AL__c = stateCount.get('AL');
        a.AR__c = stateCount.get('AR');
        a.AZ__c = stateCount.get('AZ');
        a.CA__c = stateCount.get('CA');
        a.CO__c = stateCount.get('CO');
        a.CT__c = stateCount.get('CT');
        a.DE__c = stateCount.get('DE');
        a.FL__c = stateCount.get('FL');
        a.GA__c = stateCount.get('GA');
        a.HI__c = stateCount.get('HI');
        a.IA__c = stateCount.get('IA');
        a.ID__c = stateCount.get('ID');
        a.IL__c = stateCount.get('IL');
        a.IN__c = stateCount.get('IN');
        a.KS__c = stateCount.get('KS');
        a.KY__c = stateCount.get('KY');
        a.LA__c = stateCount.get('LA');
        a.MA__c = stateCount.get('MA');
        a.MD__c = stateCount.get('MD');
        a.ME__c = stateCount.get('ME');
        a.MI__c = stateCount.get('MI');
        a.MN__c = stateCount.get('MN');
        a.MO__c = stateCount.get('MO');
        a.MS__c = stateCount.get('MS');
        a.MT__c = stateCount.get('MT');
        a.NC__c = stateCount.get('NC');
        a.ND__c = stateCount.get('ND');
        a.NE__c = stateCount.get('NE');
        a.NH__c = stateCount.get('NH');
        a.NJ__c = stateCount.get('NJ');
        a.NM__c = stateCount.get('NM');
        a.NV__c = stateCount.get('NV');
        a.NY__c = stateCount.get('NY');
        a.OH__c = stateCount.get('OH');
        a.OK__c = stateCount.get('OK');
        a.OR__c = stateCount.get('OR');
        a.PA__c = stateCount.get('PA');
        a.RI__c = stateCount.get('RI');
        a.SC__c = stateCount.get('SC');
        a.SD__c = stateCount.get('SD');
        a.TN__c = stateCount.get('TN');
        a.TX__c = stateCount.get('TX');
        a.UT__c = stateCount.get('UT');
        a.VA__c = stateCount.get('VA');
        a.VT__c = stateCount.get('VT');
        a.WA__c = stateCount.get('WA');
        a.WI__c = stateCount.get('WI');
        a.WV__c = stateCount.get('WV');
        a.WY__c = stateCount.get('WY');
        a.DC__c = stateCount.get('DC');


        accountsToUpdate.add(a);

    }
    //End Loop - Account

    update accountsToUpdate;

}

ConnectApi.FeedItem fi = ConnectApiHelper.postFeedItemWithMentions(Network.getNetworkId(), 'me', 'Hey there {005D00000015tjz}, how are you?');

<apex:column headerValue="Election Status">
                    <img src="/resource/acorn" title="   {!$ObjectType.Employee_Session_Benefit__c.Fields.Election_Status__c.inlineHelpText}" height="13" width="13" />
                        <apex:inputField value="{!rev.Election_Status__c}" rendered="{!paperRender}" />
                        <apex:outputText value="{!rev.Election_Status__c}" rendered="{!!paperRender}" />
                    </apex:column>

My pagereference is being shown within the existing VF page instead of redirecting to a new page. Can someone tell me what i have done wrong? 

Here is the VF page before I click the button:



Here is the page after I click the button:


Here is the code for that group of buttons:

<apex:pageBlockButtons id="pbb_save" location="bottom" rendered="{!!sessionEditDisable}">
                    <apex:commandButton action="{!saveChangesNewPage}" value="Save Voluntary Info" rendered="{!!serviceSession}" rerender="theForm" status="status" />
                    
                    <apex:commandButton action="{!ScheduleReview}" value="Save,Schedule Review" rendered="{!!serviceSession}" rerender="theForm" status="status" />
                    
                    <apex:commandButton action="{!assignFollowUpTask}" value="Save,Assign Follow-Up Task" rendered="{!!serviceSession}" rerender="theForm" status="status" />

                     <apex:actionStatus id="status">
                        <apex:facet name="start">
                            <div style="position: fixed; top: 0; left: 0; right: 0; bottom: 0; opacity: 0.50; z-index: 1000; background-color: gray;">
                                &nbsp;
                            </div>
                            <div style="position: fixed; left: 0; top: 0; bottom: 0; right: 0; z-index: 1001; margin: 20% 50%">
                                <img src="/img/loading32.gif"/>
                            </div >
                        </apex:facet>
                    </apex:actionStatus>
                    
                </apex:pageBlockButtons>

public pageReference scheduleReview() {
        
        system.debug('in scheduleReview method'); 
        
        saveChanges();
        recordTypes = [SELECT id FROM RecordType WHERE (Name = 'ScheduleReview' OR Name = 'Schedule Review') AND sObjectType = 'Event' ];
        Employee_Session__c es = [SELECT id,Employee__c,Session_Status__c FROM Employee_Session__c WHERE id = :esId];
        
        PageReference pr;
        pr = new PageReference('/00U/e?');
        pr.getParameters().put('what_id',es.Employee__c);
        pr.getParameters().put('retURL','%2F' + es.Employee__c);
        pr.getParameters().put('RecordType',recordTypes[0].id);
        pr.getParameters().put('ent','Event');
        return pr;
    }

List<ContentFolder> folder = new List<ContentFolder>();
            folder.add(new ContentFolder(
                Name 					= 'HR Buzz',
                ParentContentFolderId 	= '05880000000PvIv'
            ));
        
        insert folder;

<apex:pageBlockSectionItem >
                            <apex:outputText value="Benefits Filter: " />
                            <apex:selectList value="{!benefitType}" size="1">
                                <apex:selectOptions value="{!benefitTypes}" />
                                <apex:actionSupport event="onchange" action="{!loadESBs}" rerender="Detail" status="status"/>
                            </apex:selectList>
                        </apex:pageBlockSectionItem>

CASE( Session_Status_Picklist__c,
"Complete", IMAGE("/servlet/servlet.FileDownload?file=01518000000EvIC","! Completed",50,50),
"In Progress", IMAGE("/servlet/servlet.FileDownload?file=01518000000EvI2","! In Progess",50,50),
"Under Admin Review", IMAGE("/servlet/servlet.FileDownload?file=01518000000EvIW","! Under Review",50,50),
""
)

public class ContestEntryController {

    public Contest_Tracking__c contest  { get; private set; }
    public BCS__c hub                   { get; private set; }

    public ContestEntryController() {

        //Capture choices
        contest = new Contest_Tracking__c(); 

        //Find Hub for user
        hub = [Select Id FROM BCS__c WHERE User__c = :UserInfo.getUserId()];
    }

    public PageReference save() {
        try {
            contest.Contest_Name__c     = contest.Picklist_Contest_Name__c;
            contest.Related_to__c       = hub.Id;
            contest.User__c             = UserInfo.getUserId();
            contest.Keyword__c          = contest.Picklist_Contest_Name__c;
            insert(contest);
            return null;
        } catch(System.DMLException e) {
            ApexPages.addMessages(e);
            return null;
        }

    }
}

<apex:page controller="ContestEntryController" showHeader="false" sidebar="false" tabStyle="Contest_Tracking__c">

    <script> function refreshFeed() {
    Sfdc.canvas.publisher.publish({name : 'publisher.close', payload : {feed: true}}); }
  </script>

    <apex:form style="width:90%;margin:auto;" >
        <apex:pageBlock mode="edit" >
            <!-- Enter Contest --> 
            <apex:pageBlockSection columns="2" showHeader="true" title="Create Contest Entry">
                <apex:outputLabel value="Contest Name"/>
                             <apex:actionRegion >
                              <apex:inputField value="{!contest.Picklist_Contest_Name__c}" required="true">
                              <apex:actionSupport event="onchange" reRender="MarchMadness"/>
                              </apex:inputField>
                             </apex:actionRegion>
                <apex:outputLabel value="Contest Vote"/>
                             <apex:actionRegion >
                              <apex:inputField value="{!contest.Picklist_Contest_Vote__c}" required="true">
                              <apex:actionSupport event="onchange" reRender="MarchMadness" />
                              </apex:inputField>
                             </apex:actionRegion>
            </apex:pageBlockSection>

            <!-- Button Section -->
            <apex:pageBlockButtons location="bottom">
                <apex:commandButton value="Submit Entry" action="{!save}" oncomplete="refreshFeed();" />
            </apex:pageBlockButtons>

            <!-- Rules -->
            <apex:pageBlockSection columns="1" showHeader="true" title="Contest Rules">
                <apex:pageblocksection id="MarchMadness" columns="1">
                <apex:outputPanel styleClass="rules" style="width:80%" rendered="{!contest.Picklist_Contest_Name__c == 'March Madness'}">
                    1. Be sure to complete you bracket at CBS Sport to be eligible for prizes.<br />
                    2. Guess your champion here to earn 10 points for Culture Club.<br /> <br />
                    If you did not get a CBS Sports bracket invitation, please email Jim.<br /><br />
                </apex:outputPanel>
                    </apex:pageblocksection>
            </apex:pageBlockSection>
        </apex:pageBlock>
    </apex:form>

    <!-- CSS -->
    <style>
        .logo {
        float: right;
        width: 200px;
        margin: -65px 20px 0 0;
        padding: 20px;
        }
        .rules {
        color: black;
        font-size: 18px;     
        float: left;
        width: 100%;
        }
    </style>
</apex:page>

System.DmlException: Insert failed. First exception on row 0; first error: MIXED_DML_OPERATION, DML operation on setup object is not permitted after you have updated a non-setup object (or vice versa): Account, original object: User: []

@isTest
//Created by Matt - March 2016
//Designed for the Acorn Release
//

public class Test_Session_and_Session_Benefit {
    @testSetup static void setupTestData(){
        
        Test.startTest(); 
        List<User>testUsers = new List<User>();
        
        //Create Admin User
        Profile p = [SELECT Id FROM Profile WHERE Name='System Administrator']; 
        testUsers.add(new User(Alias = 'SysAdmin', Email='admin@bcinsourcing.com', 
                          EmailEncodingKey='UTF-8', LastName='Testing', LanguageLocaleKey='en_US', 
                          LocaleSidKey='en_US', TimeZoneSidKey='America/Los_Angeles', ProfileId = p.Id, 
                          UserName='admin@bcinsourcing.com'));

         //Create Manager
        Profile pM = [SELECT Id FROM Profile WHERE Name='BCS Manager']; 
        testUsers.add(new User(Alias = 'TSTMGR', Email='testmanager@bcinsourcing.com', 
            EmailEncodingKey='UTF-8', LastName='TSTMGR', LanguageLocaleKey='en_US', 
            LocaleSidKey='en_US', TimeZoneSidKey='America/Los_Angeles', ProfileId = pM.Id, 
            UserName='testmanager@bcinsourcing.com'));

        //Create Standard User
        Profile pS = [SELECT Id FROM Profile WHERE Name='Chatter Only - BCS Standard']; 
        testUsers.add(new User(Alias = 'TSTBCS', Email='TSTBCS@bcinsourcing.com', 
            EmailEncodingKey='UTF-8', LastName='TSTBCS', LanguageLocaleKey='en_US', 
            LocaleSidKey='en_US', TimeZoneSidKey='America/Los_Angeles', ProfileId = pS.Id, 
            UserName='TSTBCS@bcinsourcing.com'));
        
        	Insert testUsers;
                 
        //Create Accounts
        List<Account> accounts = new List<Account>();
        for(Integer i=0;i < 2;i++){
            accounts.add(new Account(
                Name = 'Test Acc' +i,
                Account_Code__c = 'AC' +i,
                Type = 'Client',
                Niche__c = 'Services'
            ));
        }
        
        	insert accounts; 
        Test.stopTest();
 
        //Create Public Group
        List<Group> pubGroup = new List<Group>();
        for(Account acc:accounts){
            pubGroup.add(new Group(
                Name             = acc.Name,
                DeveloperName    = acc.Name,
                Type             = 'Regular'
             ));
        }
        
        	insert pubGroup;
        
        //Create Carriers
        List<Account> carriers = new List<Account>();
        for(Integer i=0;i < 2;i++){
            carriers.add(new Account(
                Name = 'Test Carrier' +i,
                Account_Code__c = 'CA' +i,
                Type = 'Carrier'
            ));
        }
        insert carriers;
        
        //Create Hub
        List<BCS__c> theHub = new List<BCS__c>();
        for(Integer i=0;i < 1;i++){
            theHub.add(new BCS__c(
                Name = testUsers.get(0).LastName,
                DOH__c = Date.today().addDays(2),
                User__c = testUsers.get(0).Id
            ));
        }
        insert theHub;
        
        //Create Benefit Masters
        List<Benefit_Master__c> benMasters = new List<Benefit_Master__c>();
        for(Account car:carriers){
            for(Integer i=0;i < 2;i++){
                benMasters.add(new Benefit_Master__c(
                    Name = 'BenMaster'+i,
                    Carrier__c = car.Id
                ));
            }
        }
        insert benMasters;
        
        //Create Account Benefits
        List<Account_Benefit__c> AccBenefit = new List<Account_Benefit__c>();
        for(Benefit_Master__c master:benMasters){
            for(Integer i=0;i < 2;i++){
                AccBenefit.add(new Account_Benefit__c(
                    Name = master.Name,
                    Benefits_Master__c = master.id,
                    Account__c = accounts.get(i).Id,
                    Show_Elimination_Period__c   = false,
                    Show_Volume__c               = false
                ));
            }
        }
        insert AccBenefit;
        
        //Create Employees
        List<Employees__c> employee = new List<Employees__c>();
        for(Account acc:accounts){
            for(Integer i=0;i < 10;i++){
                employee.add(new Employees__c(
                    Name = acc.Account_Code__c + i, //Creates a HBS ID like AC11 and AC12
                    First_Name__c = 'First'+i,
                    Last_Name__c = 'Last'+i,
                    Account__c = acc.Id,
                    Review_End_Date__c = Date.today(),
                    DOH__c = Date.today(),
                    PayCy__c = 'Biweekly'
                ));
            }
        }
        insert employee;
    }
    
    
    //Create Acorn Sessions  
    static testMethod void testCreateSessions(){
        
        ....subsequent code redacted....
}

/a1M/e?CF00N800000056AV2={!Employees__c.Name}
&CF00N800000056AV2_lkid={!Employees__c.Id}
&retURL=%2F{!Employees__c.Id}
&RecordType=012180000000AhdAAE
&ent=01I80000000pYzR
&Name={!Employees__c.Name} {!TODAY()}
&00N18000000IXlB={!Employees__c.Acquisition_Rollover_Window_Start_Date__c}
&00N18000000IXlG={!Employees__c.Acquisition_Window_End_Date__c}
&00N18000000IXkw={!Employees__c.Review_End_Date__c}
&00N18000000IXlL={!Employees__c.Status_Change_Date__c}
&00N18000000IXf8={!Account.No_Core_Benefits__c}
&00N800000056AVn={!TODAY()}
&No_Core_Account__c={!Account.No_Core_Benefits__c}

09:00:25:612 FLOW_VALUE_ASSIGNMENT 3327be5ac80f0d842d9d2f061289153095dc09d-1678|varTMPriorValues|BM Web Enroll;We Care

09:00:25:612 FLOW_VALUE_ASSIGNMENT 3327be5ac80f0d842d9d2f061289153095dc09d-1678|varTMValues|Aflac;BM Web Enroll;We Care

List<ContentFolder> folder = new List<ContentFolder>();
            folder.add(new ContentFolder(
                Name 					= 'HR Buzz',
                ParentContentFolderId 	= '05880000000PvIv'
            ));
        
        insert folder;

Select Id, Name, User__r.Name, 
(Select Id,Account__c,Account__r.Name,Hub_Name__r.Name FROM Account_Counselors__r), 
(Select Name FROM Licenses__r) 
FROM BCS__c WHERE Inactive__C = FALSE

trigger ININRelatedToFix on Task (after Insert, after Update) {
    
    //Get Record Type    
    RecordType Five9Rec = [select id from RecordType where name = 'Five9 Call' AND sobjecttype = 'Task' limit 1];
    system.debug('RecordType= '+Five9Rec.Id);
    
    //Create List for bulkified update
    List<Task> taskList = new List<Task>();
    
    //Loop through each task handed to trigger
    for (Task T : Trigger.new) {
        
        //If Call is related to Employee Session instead of Employee
        //*******************
        If(T.What.Type.equals('Employee_Session__c') && T.RecordTypeId == Five9Rec.Id){
            
            //Get the employee
            Employee_Session__c Emp = [Select Employee__c FROM Employee_Session__c WHERE ID = :T.WhatId];
            
            //Fix Relationship
            T.WhatId = Emp.Employee__c;
            taskList.add(t);
        }
    }
    
    //Builify Update
    update tasklist;
}

global class BCI_Account_State_Count_Rollup implements Schedulable {
/*
Created by MM - 1/25/2016
Purpose - count the state field for each active employee on 
an account and update the corresponding state field count
on the account page. 
*/

//Used for aggregrateresults
Public Summary[] Summaries { get; set; }

//Make class schedulable    
global void execute(SchedulableContext ctx) {        
    CronTrigger ct = [SELECT Id, CronExpression, TimesTriggered, NextFireTime
                      FROM CronTrigger WHERE Id = :ctx.getTriggerId()];


    //Create Set with fields from Account page.
    Set<String> statesAcct = new Set<string>{
        'AL','AK','AZ','AR','CA','CO',
            'CT','DE','FL','GA','HI','ID',
            'IL','IN','IA','KS','KY','LA',
            'ME','MD','MA','MI','MN','MS',
            'MO','MT','NE','NV','NH','NJ',
            'NM','NY','NC','ND','OH','OK',
            'OR','PA','RI','SC','SD','TN',
            'TX','UT','VT','VA','WA','WV',
            'WI','WY',
            //Commonwealth/Territories
            'DC'};


                //Create List of active accounts
                list<account> myAccounts = new list<account>();
    myAccounts = [Select ID, Name from Account WHERE Type = 'Client'];

    //Create list to bulkify update command at end of loop
    list<account> accountsToUpdate = new list<account>();

    //Get active employee counts for every account.
    //Getting all at once to limit SOQL queries. 
    Summaries = new List<Summary>();

//CODE THAT IS BREAKING DUE TO SOQL LIMIT
        AggregateResult[] groupedResults = [SELECT COUNT(ID) ct, State__c st, Account__c acct FROM Employees__c WHERE Type__c = 'Client' AND Inactive__c != 'X' GROUP BY Account__c,State__c];
//END BROKEN CODE

    for (AggregateResult ar : groupedResults) {
        Summaries.add(new Summary(ar));
    }


    //Loop MyAccounts
    for ( Account a : myAccounts ){

        //Create map of specific account aggregrate results per state. 
        Map<String, integer> aggregateAcct = new Map<String, integer>();


        //Loop - extract aggregrateResult data just for current account. 
        for(Summary s : Summaries ){
            //system.debug('Summary' + s.acctid);
            //system.debug('Account' + a.Id);

            if(s.acctId == a.id){
                aggregateAcct.put(s.stateName,s.stateCount);
                //System.debug('aggregateAcct - ' + s.stateName + '-' + s.stateCount); 
            } 
        }
        //End Loop - Summaries

        //Create State Name to State count field Map
        Map<String, integer> stateCount = new Map<String, integer>();

        //Link the state count to the field name that is used on the Account object 
        //This way we only get values for states that we have fields for on Account object.
        for(String st : statesAcct){
            StateCount.Put(st, aggregateAcct.get(st));  
        }

        //Now update each state field using our stored values. 
        //Values in StateCount map are now StateAbbreviation and Count

        a.AK__c = stateCount.get('AK');
        a.AL__c = stateCount.get('AL');
        a.AR__c = stateCount.get('AR');
        a.AZ__c = stateCount.get('AZ');
        a.CA__c = stateCount.get('CA');
        a.CO__c = stateCount.get('CO');
        a.CT__c = stateCount.get('CT');
        a.DE__c = stateCount.get('DE');
        a.FL__c = stateCount.get('FL');
        a.GA__c = stateCount.get('GA');
        a.HI__c = stateCount.get('HI');
        a.IA__c = stateCount.get('IA');
        a.ID__c = stateCount.get('ID');
        a.IL__c = stateCount.get('IL');
        a.IN__c = stateCount.get('IN');
        a.KS__c = stateCount.get('KS');
        a.KY__c = stateCount.get('KY');
        a.LA__c = stateCount.get('LA');
        a.MA__c = stateCount.get('MA');
        a.MD__c = stateCount.get('MD');
        a.ME__c = stateCount.get('ME');
        a.MI__c = stateCount.get('MI');
        a.MN__c = stateCount.get('MN');
        a.MO__c = stateCount.get('MO');
        a.MS__c = stateCount.get('MS');
        a.MT__c = stateCount.get('MT');
        a.NC__c = stateCount.get('NC');
        a.ND__c = stateCount.get('ND');
        a.NE__c = stateCount.get('NE');
        a.NH__c = stateCount.get('NH');
        a.NJ__c = stateCount.get('NJ');
        a.NM__c = stateCount.get('NM');
        a.NV__c = stateCount.get('NV');
        a.NY__c = stateCount.get('NY');
        a.OH__c = stateCount.get('OH');
        a.OK__c = stateCount.get('OK');
        a.OR__c = stateCount.get('OR');
        a.PA__c = stateCount.get('PA');
        a.RI__c = stateCount.get('RI');
        a.SC__c = stateCount.get('SC');
        a.SD__c = stateCount.get('SD');
        a.TN__c = stateCount.get('TN');
        a.TX__c = stateCount.get('TX');
        a.UT__c = stateCount.get('UT');
        a.VA__c = stateCount.get('VA');
        a.VT__c = stateCount.get('VT');
        a.WA__c = stateCount.get('WA');
        a.WI__c = stateCount.get('WI');
        a.WV__c = stateCount.get('WV');
        a.WY__c = stateCount.get('WY');
        a.DC__c = stateCount.get('DC');


        accountsToUpdate.add(a);

    }
    //End Loop - Account

    update accountsToUpdate;

}

ConnectApi.FeedItem fi = ConnectApiHelper.postFeedItemWithMentions(Network.getNetworkId(), 'me', 'Hey there {005D00000015tjz}, how are you?');

<apex:column headerValue="Election Status">
                    <img src="/resource/acorn" title="   {!$ObjectType.Employee_Session_Benefit__c.Fields.Election_Status__c.inlineHelpText}" height="13" width="13" />
                        <apex:inputField value="{!rev.Election_Status__c}" rendered="{!paperRender}" />
                        <apex:outputText value="{!rev.Election_Status__c}" rendered="{!!paperRender}" />
                    </apex:column>

CASE( Session_Status_Picklist__c,
"Complete", IMAGE("/servlet/servlet.FileDownload?file=01518000000EvIC","! Completed",50,50),
"In Progress", IMAGE("/servlet/servlet.FileDownload?file=01518000000EvI2","! In Progess",50,50),
"Under Admin Review", IMAGE("/servlet/servlet.FileDownload?file=01518000000EvIW","! Under Review",50,50),
""
)

09:00:25:612 FLOW_VALUE_ASSIGNMENT 3327be5ac80f0d842d9d2f061289153095dc09d-1678|varTMPriorValues|BM Web Enroll;We Care

09:00:25:612 FLOW_VALUE_ASSIGNMENT 3327be5ac80f0d842d9d2f061289153095dc09d-1678|varTMValues|Aflac;BM Web Enroll;We Care

trigger ScheduledReviewDate on Event (after insert) {
    for (Event e: trigger.new){
    
    }
}

Hi,

I would like to be able to show a gif spinner on my visual force page as I am doing something on the background like loading data or waiting for data to come back before I update the page.

It will be ideal if I can replace apex:tags with a stylesheet that will be turned off or on based on user click.

Does anyone have a good solution for that I ma not very ajax savvy per say so any ideas will be appreciated.

Thank you.