topic Re: Createing Calculated Dimension based on dimension values in App Development

Createing Calculated Dimension based on dimension values

Gowtham — Mon, 04 Nov 2019 06:55:38 GMT

Hi All,

I have one dimension called 'Type' and it has 'E3' and 'not E3' as values. I need to create a filter and it should be like 'E3', 'not E3' and 'All'. when I click 'All' in the filter it will give the data for both 'E3' and 'not E3'

How to create a calculated dimension with 'All' as a third value. Can anyone help me with this?

Thanks in Advance

Re: Createing Calculated Dimension based on dimension values

StarinieriG — Mon, 04 Nov 2019 08:16:39 GMT

Hi,

try to create a new table like this with Type as key

NoConcatenate
LOAD * Inline [
Dimension,Type
E3,E3
not E3,not E3
All,E3
All,not E3
];

Re: Createing Calculated Dimension based on dimension values

Gowtham — Mon, 04 Nov 2019 09:08:26 GMT

Thank you,

It's working as expected...