Set Analysis issue

vlad_komarov — Fri, 31 Jul 2015 16:15:10 GMT

Hello,

My data contains some names and # of days since some event.

I need to create a table chart that displays names only if #days fits in specific range:

<6 months, 6-12 months, 1 - 2 years, etc.

I thought it should be pretty simple, using the expression:

//for < 6 months:

only({<[Name] = {"=min(Days) < $(v6MonthsRange)"}>}[Name])

// for > 8 years:

only(

[Name] = {"=min(Days) >= $(v8YearsRange)"}

[Name])

These two expressions above are working fine.

I have a problems with the same approach for 6-12 months, 1 - 2 years, etc expressions:

only(

[Name] = {"=min(Days) >= $(v1YearRange)"},

[Name] = {"=min(Days) < $(v2YearsRange)"}

[Name])

See the attachment app for details.

What I am missing here?

Regards,

Vladimir

Re: Set Analysis issue

swuehl — Fri, 31 Jul 2015 16:23:57 GMT

Try it like

only(

[Name] = {"=min(Days) >= $(v1YearRange) and min(Days) < $(v2YearsRange)"}

[Name])

vlad_komarov — Fri, 31 Jul 2015 16:54:40 GMT

Thanks!

Not super elegant solution (considering Set Analysis other complicated options), but it works!

Regards,

Vladimir