Forum Discussion

DeanOusterhout's avatar
DeanOusterhout
Qrew Assistant Captain
9 years ago

How to create a Bar Chart Report where the Bars are summarized based on two different date fields?

We have a table, Projects, with a SellingPrice and we track events that occur to the project, the date a customer said yes(SaleDate) and the date we received payment(PaymentDate). We would like a r...
AnnSwelgin's avatar
AnnSwelgin
Qrew Trainee
8 years ago
I have pretty much the same question. Permit draft date and permit acquired date. I want to show how many records per month in each "category" drafted or acquired. Is there an easy way to make a calculated column in the bar chart to do this? I was thinking Case so that it would put the case values on the Y axis.. but I am not that advanced yet :)