Summary field Count distinct
I'm this is impossible for Quickbase....but I wanted to ask. I have a Parent Table (customers) and a child table (orders).... I want to see a which customers have placed an order in each month over...
Forum Discussion
hmmm I�m sure I posted a response but it did not get saved.
A partial solution.
Make a formula numeric field with a value of 1
Summary report on Maximum of that field.
That will give the counts but not the total by week as the Total will in fact be a Max.
Export to Excel
Make your totals in excel.
A partial solution.
Make a formula numeric field with a value of 1
Summary report on Maximum of that field.
That will give the counts but not the total by week as the Total will in fact be a Max.
Export to Excel
Make your totals in excel.
- I have a similar situation I have been trying to figure out.
Parent NODE to Child Poles.
Parent PERMITS to Child Poles.
No relationship between the two parents Node and Permits, however, all three tables are Child to DOCKS.
On NODE table, I want a distinct count of PERMITS for the Poles in that NODE.
I can get # of Poles per NODE
I can get # of Poles per PERMIT
I can get # of Poles per DOCK, # of PERMITS per DOCK, # of NODES per DOCK.
I tried take "# of Permits per Dock Summary field" from DOCK and add as lookup field on Nodes, but that shows total number of Permits for the DOCK, not broken out for each Node which is what I need.
Just can't figure out how to show on the NODES table, the # of PERMITS.
I have ready some of your related posts but am not sure where to put Minimums or Maximums at which tables, what to lookup from where.
Any advice?
Thanks. - I suggest that you post this as a new question so more people will see it.
