topic Re: set Analysis help in App Development

set Analysis help

arusanah — Thu, 20 Sep 2018 18:12:58 GMT

Can anybody help find error in below expression .I tried but guess I need extra pair of eyes to look .

trying to create a calculated dimension but it error's out .

=only({<[%KEY]={'Ariel'},DATE={>=EndMonth12<=END_DT},Domain1=,Domain2=,Domain3=,Domain4=,Domain5=,Metric=>}MonthYear)

End Month & END DT are fields in my data set.

Help is much appreciated!

vamsee — Thu, 20 Sep 2018 18:17:35 GMT

Try

=only({<[%KEY]={'Ariel'},

DATE

={">$(=Max(EndMonth12)) <=$(=Max(END_DT))"},

Domain1=,Domain2=,Domain3=,Domain4=,Domain5=,Metric=>}MonthYear)

arusanah — Thu, 20 Sep 2018 18:30:09 GMT

nope still give invalid dimension

vamsee — Thu, 20 Sep 2018 18:57:49 GMT

I don't see anything wrong in the expression.

Make sure your Max(EndMonth12), Max(END_DT), DATE are in same format.