Add a Group By Week option in reports

Idea created by Inner10Capital Inner10Capital on Oct 29, 2015
    Delivered
    Score30
    • Mishelle Fisher
    • ikeith ikeith
    • KateLloyd
    • Inner10Capital Inner10Capital
    • Ishani Lad
    • Elizabeth Crandall

    Hi,

    I like to generate a report that summarizes target acquisition and (multiple) campaign activity by week.

    For instance:


    WeekEnding  CountOfTargets  GrowthFromPreviousWeek  SentEmails
    2014-06-01  32              n/a                     14
    2014-06-08  62              99%                     43
    2014-06-15  68              10%                     32


    How can I generate a report like this in SugarCRM? Even just getting a weekly summary of new targets seems hard, let alone joining against campaign activity.  I come from the SQL world so could write the queries directly if I knew what was in all the different tables...

    Thanks
    John