Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try it like
only(
{<
[Name] = {"=min(Days) >= $(v1YearRange) and min(Days) < $(v2YearsRange)"}
>}
[Name])
Try it like
only(
{<
[Name] = {"=min(Days) >= $(v1YearRange) and min(Days) < $(v2YearsRange)"}
>}
[Name])
Thanks!
Not super elegant solution (considering Set Analysis other complicated options), but it works!
Regards,
Vladimir