Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
got a line chart with Dimension = Year
I have the following expression
If
(
Year=Max(Year) or QUARTER_YEAR = max(QUARTER_YEAR) or MonthYear=max(MonthYear),
RangeSum(Above(total COUNT(DISTINCT{
1
<
Year=$::Year
,MonthYear=$::MonthYear
,Month=$::Month
,QUARTER_YEAR=$::QUARTER_YEAR
,Quarter=$::Quarter
,RECORD_TYPE={'MAINSTREAM'}
>
} FIX_ID),0,RowNo(TOTAL)))
)
everything is fine but isn't this expression supposed to ignore any selection made on hte fields except for year, month, and the ones mentioned above?
why when I select a field called Client I only see results below but I need the above chart to show as above
please advise as I see the years related to the selected client
See if this helps:
If(Only({1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>}Year)=Max({1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>}Year)
or
Only({1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>} QUARTER_YEAR) = Max({1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>} QUARTER_YEAR)
or
Only({1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>} MonthYear) = Max({1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>}MonthYear),
RangeSum(Above(total COUNT(DISTINCT{1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>}FIX_ID),0,RowNo(TOTAL))))
See if this helps:
If(Only({1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>}Year)=Max({1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>}Year)
or
Only({1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>} QUARTER_YEAR) = Max({1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>} QUARTER_YEAR)
or
Only({1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>} MonthYear) = Max({1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>}MonthYear),
RangeSum(Above(total COUNT(DISTINCT{1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>}FIX_ID),0,RowNo(TOTAL))))
Are you using alternate states?
You don't have filter overrides in all places
Year=Max(Year) or QUARTER_YEAR = max(QUARTER_YEAR) or MonthYear=max(MonthYear),
should be
Year=Max({1}Year) or QUARTER_YEAR = max((1)QUARTER_YEAR) or MonthYear=max({1}MonthYear),
or even
Year=Max({1<RECORD_TYPE={'MAINSTREAM'}>}Year)....
ah I wonder how I missed this
thank you
No problem
I am glad we were able to help.
Best,
Sunny