Skip to main content
Topics#Reports & DashboardsFrage von System Administrator
System Administrator fragte in #Reports & Dashboards
23. Aug. 2011, 03:56

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 Antworten
  1. Steve Molis (You Owe Me a Beer, Inc.)
    23. Aug. 2011, 04:00
    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))))
Antwort schreiben...
0/9000