Forum Discussion

YifengGu's avatar
YifengGu
Qrew Trainee
6 years ago

How to Create a Report or Chart that Show "# of Cases" by Multiple Fields

Hi my name is Ethan. To be short, each "record" has 3 "Date" fields (let's say "Date 1", "Date 2", and "Date 3"), and I want to find a way to include all 3 Dates and show "# of records" by date (ei...
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
np, make three formula fields like like this

[Worked Date 1] as a formula numeric 
formula:

IF(not IsNull([Date 1],1,0)

same for the other two,

Then make a summary report with three columns to total up the value of those three fields on one summary report - ie, summarize three different fields.


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • YifengGu's avatar
    YifengGu
    Qrew Trainee
    6 years ago
    Hi Mark - Thank you for the quick response!

    I am confused about the second part of your solution - "Make a summary report". 

    What I need is: the first column should be Date, and the second column should be "total worked cases on that date".  for example, if I have a record that has three dates, in other words, been worked on three different dates, let's say 1/1/2020, 1/15/2020, and 1/31/2020.  Then this record should be counted three times, separately.

    ------------------------------
    Yifeng Gu
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      sorry, now I see your point. Let me think a bit when I get a chance.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • YifengGu's avatar
        YifengGu
        Qrew Trainee
        6 years ago
        Thank you for the help Mark!

        ------------------------------
        Yifeng Gu
        ------------------------------