I have the below HTML Card on a Visual Perspective with this calculation:
<div class="trend-dlp-growth">
<<IF
COUNT DLPAlert WHERE (DLPAlert.DateGenerated >= DATE_ADD(CURRENT_DATE, -30)) > 0 AND
COUNT DLPAlert WHERE (DLPAlert.DateGenerated = DATE_ADD(CURRENT_DATE, -30)) > 0 AND
ROUND((COUNT DLPAlert WHERE (DLPAlert.Incident IS DEFINED AND DLPAlert.IncidentDate >= DATE_ADD(CURRENT_DATE, -30))) * 100 / COUNT DLPAlert WHERE (DLPAlert.DateGenerated >= DATE_ADD(CURRENT_DATE, -30)), 0) >
ROUND((COUNT DLPAlert WHERE (DLPAlert.Incident IS DEFINED AND DLPAlert.IncidentDate = DATE_ADD(CURRENT_DATE, -30))) * 100 / COUNT DLPAlert WHERE (DLPAlert.DateGenerated = DATE_ADD(CURRENT_DATE, -30)), 0)
THEN '<span class="trend-dlp-arrow">↑</span>'
ELSE '<span class="trend-dlp-arrow">↓</span>'>>
<span class="trend-dlp-growth-text">
<<IF COUNT DLPAlert WHERE (DLPAlert.DateGenerated >= DATE_ADD(CURRENT_DATE, -30)) > 0 THEN
ROUND((COUNT DLPAlert WHERE (DLPAlert.Incident IS DEFINED AND DLPAlert.IncidentDate >= DATE_ADD(CURRENT_DATE, -30))) * 100 / COUNT DLPAlert WHERE (DLPAlert.DateGenerated >= DATE_ADD(CURRENT_DATE, -30)), 0)
ELSE 0>>% increase in last 30 days
</span>
</div>
Is IF Statement Supported in AwareIM for HTML contents? What is the workaround to this approach.