Forum Discussion

ushadow91's avatar
ushadow91
Data Storage
07-19-2023

Conditional CASE Indicator Widget

I'm attempting to create an indicator widget that calculates the total number of overdue tickets.  It would use two formulas to determine the difference between the total due date day allotment(Ticke...
dashboards & reporting
ushadow91's avatar
ushadow91
Data Storage
07-20-2023

Thanks HamzaJ  I'm getting

  • "Unexpected Token '[' in FunctionParameters Definition".
  • "Unexpected token')' in Boolean expression"  

 

sum([All Tickets],
CASE
WHEN MAX(DDIFF(NOW()[Days Difference])) >1
THEN sum([All Tickets])
WHEN MAX(DDIFF(NOW()[Days Difference])) < 1
THEN 0
end)

 

HamzaJ's avatar
HamzaJ
Data Integration
07-20-2023

You forgot the , . Try the following:

sum([All Tickets],
CASE
WHEN MAX(DDIFF(NOW(),[Days Difference])) >1
THEN sum([All Tickets])
WHEN MAX(DDIFF(NOW(),[Days Difference])) < 1
THEN 0
else 0
end)