topic Re: Set analysis not working in App Development

Set analysis not working

ritumishra01 — Fri, 15 Nov 2024 21:30:26 GMT

=if(not isnull(prj_number) and len(prj_number)>1,prj_Status,
if(((not IsNull(dmnd_number)) and len(dmnd_number)>1) or (isnull(prj_number) and (len(prj_number)<1)),dmnd_status,
if(not isnull (idea_status),idea_status)))

while i am giving this as measure i could see prj_status and dmnd_status but i could not see idea status its showing null

Re: Set analysis not working

joaopaulo_delco — Wed, 09 Aug 2023 14:29:47 GMT

Hi @ritumishra01

I recommend you do it on load script creating a new dimension for this purpose.

Re: Set analysis not working

ritumishra01 — Wed, 09 Aug 2023 16:17:42 GMT

ually these three fields are coming from three different table and if i join these tables it is giving me error .not sure what approach can be used here