Set analysis on a dimension used for color coding

[mkliqvia]

Hi all,

I have following data in my app, with both fields not related to each other:

In the app, we have a filter on 'Customer status', which is always on value ACTV.

I have a bar chart which shows data on the 'Activity Type' (stacked bar chart with color coding in function of the 'Activity Type').

- When Customer status = ACTV is not selected, the colors for each 'Activity Type' work correctly.
- but when Customer status = ACTV is selected (default), the colors are not shown. So I try to find a way to make that dimension ignore the filter on Customer status.

I have tried multiple solutions to have the Color by Dimension ignore the filter on [Customer status], but they don't seem to work:

- aggr(only({<[Customer status]=>} [Activity Type]),[Activity Type])
- concat({<[Customer status]=>} distinct [Activity Type], ',')
- aggr(concat({<[Customer status]=>} distinct [Activity Type],','),[Activity Type])

Do you have any idea what other possible solutions I could try?

For info, with color coding set to 'Single Color', I can see the activity types stacks, but cannot color each of them (see image). While when no selection is made on the ACTV value, the colors are rendered well (one for each activity type). 

[mkliqvia]

That's where I used your suggested code:

only({<[Customer status]=>} [Activity Type])

[sunny_talwar]

I meant the chart Measure

[mkliqvia]

Yes the chart measure ignores the Customer_Status field as well.

[sunny_talwar]

I am not sure what might be going on. Would you be able to share a sample to show the issue?

[mkliqvia]

Unfortunately, I cannot share the app. But how can we make the set analysis ignore the NULL values ? These fields come from two separate tables where the keys don't match, therefore creates these NULL values.