You need to use the datetrunc() function extensively.
[# of Tickets open today]
If [Start Date] = Today THEN 1 ELSE 0 END
[# of Tickets opened as of Most recent Quarter End]
// Count all tickets that have Start Date BETWEEN, first and last date of the last quarter
If [Start Date] <=DateADD('day',-1,DATETRUNC('quarter', TODAY())) and [Start Date] >=DateADD('month',-3,DATETRUNC('quarter', TODAY())) THEN 1 ELSE 0 END
Similarly you can build the formula to find ticket count for Start Date beween first and last day of previous to previous quarter.
Thanks Sujay - really appreciate this. One question, though. . . How do I dynamically name/label the variables? Same manner? As a calculations?