Set Analysis Issue with Calculation

[#1]

I have a calculation that needs filtered using set analysis when its displayed in a table box. The calculation is created in the Load Script:

A-B = 'Days Old'

How can I setup the set analysis syntax correctly in the table box expression?

This is not working:

{$<[Group] = {"Int", "Stone"}>}[Days Old]

[sunny_talwar]

table box doesn't allow for expressions. Are you talking about a straight table expression?

Best,

Sunny

[ankitaag]

Kindly write the full expression

[#4]

Yes I'm talking about a straight table

[#5]

I included the expression. Its simply the field pulled into the expression. perhaps this isn't the correct way to do this.

{$<[Group] = {"Int", "Stone"}>}[Days Old]

[sunny_talwar]

May be a Sum/Count/Min/Max({$<[Group] = {"Int", "Stone"}>}[Days Old])

[Anonymous · Accepted solution]

Set analysis works only in aggregation expressions, e.g. sum(), count(), max(), etc.  In your case it is probably
avg({$<[Group] = {'Int', 'Stone'}>}[Days Old])
or
only({$<[Group] = {'Int', 'Stone'}>}[Days Old])

But this is just my guess.
And, as sunindia pointed out, you can't do it in a table box.