is it possible to create a report that will show t...
# generala
Ali
03/03/2020, 12:52 PMis it possible to create a report that will show the number of open cases per customer?
d
DonkeyBot
03/03/2020, 12:56 PMGroup customer Count open cases
a
Ali
03/03/2020, 1:01 PM@DonkeyBot thanks
basically I want to show open and closed cases in different columns, is that possible?
d
DonkeyBot
03/03/2020, 1:07 PMYes, CASE statement will do that
DonkeyBot
03/03/2020, 1:08 PMSet the condition to 1, then count the column
a
Ali
03/03/2020, 1:10 PMcould you please explain more
Ali
03/03/2020, 1:10 PMhow can I set the condition to 1?
Ali
03/03/2020, 1:22 PMthat's a report, not a search
I can't see any condition
d
DonkeyBot
03/03/2020, 1:23 PMCASE WHEN "open cases" = 1 THEN 1 ELSE 0 END
DonkeyBot
03/03/2020, 1:23 PMor > 0
a
Ali
03/03/2020, 1:24 PMhow you can add that
Ali
03/03/2020, 1:24 PMto a report
Ali
03/03/2020, 1:24 PMit's a report not a saved search
d
DonkeyBot
03/03/2020, 1:30 PMAh reports are a bit tricker. I think there's a pre-configured report for Cases.