I have a need to create a new metric based of Application Performance. The purpose is to get a percent of time a site was impacted by some sort of performance issue. My plan is to use 2 custom metrics. The first would get a count of how many times a sites application performance dropped below 80%. The second metric would multiply that by 5 (5 minutes) and then divide by 1440 minutes to get percentage impacted during one day.
I have these metrics defined but they do not show in the DMI.
CVENT.ClientView.calculatedColumn.1.name=Site Impact Violation
CVENT.ClientView.calculatedColumn.1.description=Number of times application performance is below 80%
CVENT.ClientView.calculatedColumn.1.expression=case when [appPerf] < 80 then [SiteImpact] = [SiteImpact] + 1 else [SiteImpact] = [SiteImpact] end
CVENT.ClientView.calculatedColumn.2.name=Site Impact Time
CVENT.ClientView.calculatedColumn.2.description=Percent impact performance time
CVENT.ClientView.calculatedColumn.2.expression=([SiteImpact] * 5)/1440
The dmi_dataview-*.properties is named correctly and I do not see anything in the logs except for this:
DMIProperties Property calculatedColumnForbiddenCols=CliCnt,AffUserNet,AffUserNetCPerc,AffUserAvl,NotAffUserNet,NotAffUserAvl,CliCntC,CliIpCnt,GrCnt set to CVENT.Tier
Any ideas on what I'm doing wrong here or any other ideas on how to create that metric?