Display Simple Metric(Count) based on condition

[Rambo2292468]

Hi,

I have a simple count metrics but I need to display the metric value based on some condition like:


if
count <2 then display 'NA' or 'blank' whatever can be
achieved easily.
Else

Count

I know how to do using Applysimple or Case statement. I would like to knwo is there any other way to display metric value based on codnition?

Thanks
Rambo

 

[nlim]

one way is to divide your metric by the threshold metric.

eg. create a threshold metric M2 defined by something like

case count<2 then 0, else 1

then divide your original metric by M2. When threshold is triggered, you should get a divide-by-zero which gives you a null.

 

[Rambo2292468]

This helped ...thanks Nlim nice solution!!

Thanks once again
Rambo