Forum Discussion

Gelo's avatar
Gelo
Qrew Trainee
4 years ago

Decisions by Day Chart and Decision Date Field

We don't want a summary table. We want a visible chart. We are trying to create a chart "Decisions by Day" to see how many loans each day our loan officers are decisioning. There are four "decision" f...
Formulas and functions
reports and charts
ChristopherWhea's avatar
ChristopherWhea
Qrew Cadet
4 years ago
Hello,

You could try something like this for your Decision Date field that is a Formula - Date type:

ToDate( List( " ; ",ToText([Approved Date),ToText([Approved With Conditions Date]),ToText([Denied Date]),ToText([Suspended Date])))

It will take the first "decision" field that is not null in the list.

------------------------------
Chris Wheatley
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
I suggest making a formula date field

Max(
[Approved Date],  [Denied Date], [Suspended Date], [Approved With Conditions Date])


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • ChristopherWhea's avatar
    ChristopherWhea
    Qrew Cadet
    4 years ago
    Mark's is much cleaner! Nice.

    ------------------------------
    Chris Wheatley
    ------------------------------
    • Gelo's avatar
      Gelo
      Qrew Trainee
      4 years ago
      Thank you both! Both solutions work great

      ------------------------------
      Gelo
      ------------------------------