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

Question

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 (either a chart or a table will work).  Please see the below picture:

Now I have to create 3 summary reports and export them to excel above (column "Date 1", "Date 2", and "Date 3") to add them up.  All I need is either a Table/Chart/Summary to show the last column "Total".  The problem is that QB can only count each record once, however, in my case, each record may be counted up to 3 times.Any thoughts will be greatly appreciated!------------------------------Ethan (Yifeng Gu)------------------------------

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community