Set analysis to exclude one dimension not working

swapneel22 — Sat, 16 Nov 2024 18:02:30 GMT

I have a few columns as below

Data Store: ABC, XYZ, '' (Blank)

Location: India, US, '' (Blank)

Refresh Frequency: Planned, Daily (Both values are associated to the above Location)

What I require: to be able to to show Refresh Frequency (text object single text value), by selecting Location. and Excluding Data Store column.

It works fine without the data store column which recently came into picture.

My code: aggr(only({1<Data Store=>}Refresh Frequency), Refresh Frequency)

This works, but as soon as I select anything in the Data Store, the output becomes blank

Is there some issue in Excluding the column ?

Request your guidance

Thanks,

Swapneel

Re: Set analysis to exclude one dimension not working

sunny_talwar — Tue, 29 Sep 2020 17:05:44 GMT

Which object are you using to display this? -> Aggr(Only({1<Data Store>} [Refresh Frequency]), [Refresh Frequency])