Different Text Boxes to reflect different selections

[Anonymous]

I have 6 text boxes, and each have a different expression in them, i want it so that that expression is displayed constantly and does not change in all the boxes.

Here is an example of the 6 boxes which I would like 6 different numbers to display,

Here is an example of the expressions:

=count(if([Severity] = 'Severe' and [Urgency] = 'High', ([Age] >= '7 Days'),'0'))

=count(if([Severity] = 'Moderate' and [Urgency] = 'Medium', ([Age] >= '60 Days'),'0'))

I believe i need to use something along the lines of:

count(aggr(only(if([Severity] = 'Severe' and [Urgency] = 'High', ([Age] >= '7 Days')),'0')))

[sunny_talwar]

Try set analysis

=Count({<[Severity] = {'Severe'}, [Urgency] = {'High'}, [Vulnerability Age] = {">=7"}>}  '0')

=Count({<[Severity] = {'Moderate'}, [Urgency] = {'Medium'}, [Vulnerability Age] = {">=60"}>}  '0')

[Anonymous]

I think this is what I need. However that didn't work. It outputted 1 instead of 12.  I want it to count the amount of records which has the severity of severe and urgency of high but only if they have an age of either equal to or above 7 days, if not then 0.

[sunny_talwar]

Would you be able to share a list box for [Vulnerability Age]

[Anonymous]

[sunny_talwar]

Oh, so it is text field.. do you have a value like this >= 7 Days?

[Anonymous]

I do not

[sunny_talwar]

So what are you trying to do with >= 7?

[Anonymous]

I am trying to count every record greater or equal to 7 days, e.g. 8 Days, 9 Days etc

[Mark_Little]

Hi,

i would stick with set analysis that Sunny has supplied, but look at formating the your age field to a number.

If formated the same i.e. 1 day so number space day or days., use something like

NUM(SUBFEILD(AGE,' ' ,1))          AS AgeNo.

This would be in the load script.

Then just update the Setanlysis to look at the number field.

Mark