Skip to main content
Topics#Reports & DashboardsSystem Administrator's Question
System Administrator asked in #Reports & Dashboards
Aug 23, 2011, 3:56 AM

Need to Display Age range in the Dashboard

I want to display the following age range in the Dashboard report

 

<20

 

>20-30

 

>30-40

 

<50
2 answers
  1. Steve Molis (You Owe Me a Beer, Inc.)
    Aug 23, 2011, 4:00 AM
    The easiest way to do that would be to create a custom Formula Field and refernce that in your DB Chart.

     

    The formula would look something like this:

     

    IF(Age > 50, "50+",

     

    IF(Age > 40, "40-50",

     

    IF(Age > 30, "30-40",

     

    IF(Age > 20, "20-30",

     

    "< 20))))
Write an answer...
0/9000