topic Multiple values for a dimension in Water Cooler

Multiple values for a dimension

Fri, 19 Apr 2013 20:09:18 GMT

I like to show in a chart duplicate values for the dimension. Take the following example to help clarify.

I have a column called WUC and another column called REM_TYPE and a third coumn called ALERTS

In my data I have

WUC	REM_TYPE	ALERTS
A	S	23
A	N	21
B	S	5

I want my chart to NOT display distinct for WUC. I basically want to be able to filter by all REM_TYPE, but instead I'm getting dashs indicating null.

Any help would be appreciated.

Re: Multiple values for a dimension

kaushiknsolanki — Sat, 20 Apr 2013 17:26:44 GMT

Hi,

Purdon me I am unable to understand your requirement.

Kindly tell us what output you are looking for.

Regards,

Kaushik Solanki

Re: Multiple values for a dimension

Mon, 22 Apr 2013 13:05:01 GMT

When I add WUC as a dimension and REM_TYPE and ALERTS as expressions, I get a dash in the REM_TYPE and ALERTS Column for WUC 'A'. I want the output to look like the table I have posted with.

Re: Multiple values for a dimension

Mon, 22 Apr 2013 15:14:31 GMT

I solved this by simply adding two dimensions, WUC and REM_TYPE. And description as an expression.