Set Analysis in Chart Dimension

[infosense_devel]

Can we use Set Analysis in Chart's Dimension?

e.g. =({<REC_TYPE={'BudgetRec', 'InvoiceDateRec'}>} BILL_TO_CUST_ACCOUNT_NUMBER)

[sunny_talwar]

Try this:

If(Match(REC_TYPE, 'BudgetRec', 'InvoiceDateRec'), BILL_TO_CUST_ACCOUNT_NUMBER)

[sunny_talwar · Accepted solution]

Or this:

Aggr(Only({1<REC_TYPE = {'BudgetRec', 'InvoiceDateRec'}>} BILL_TO_CUST_ACCOUNT_NUMBER), BILL_TO_CUST_ACCOUNT_NUMBER)

[#4]

Hi,

I would create a flag field in the back-end script and use set-analysis in the expression in the object in question.

Regards,

Pravesh

[tvsr111]

Hi Sunny,   Hope you are doing good

I need a help with Set Analysis on character (Dimension nature) Attributes

* Set Analysis does work on Measures when using SUM() & COUNT() functions

Measures:

Amount=sum({<[StartDate]={"<=$(varInputDate)"}, [EndDate]={">=$(varInputDate)"}>} OrderAmount)

QtyCount=count(distinct {<[StartDate]={"<=$(varInputDate)"}, [EndDate]={">=$(varInputDate)"}>} OrderAmount)

* But Set Analysis on Character (Dimension) attributes not working

Dimensions:
CustomerName= aggr(only({<[StartDate]={"<=$(varInputDate)"}, [EndDate]={">=$(varInputDate)"}>} CustName), CustName)
StoreLocation= aggr(only({<[StartDate]={"<=$(varInputDate)"}, [EndDate]={">=$(varInputDate)"}>} StoreLoc), StoreLoc)
OrderDate= aggr(only({<[StartDate]={"<=$(varInputDate)"}, [EndDate]={">=$(varInputDate)"}>} OrderDate), OrderDate)

We have a specific scenario where we need to apply this set analysis on Dimension columns also along with Measures.
we will use these on charts and table visualizations tooo

the expressions shown are only sample to explain the issue