I have data like image below, I want to show only data that has no parents , either in load script (extract information) or in chart.
Could you please help me how to extract this peace of information.
Exp: If(Len(Trim(Parent1&Parent2&Parent3&Parent4))>0, JOBNAME)
Thank you for your reply. I tried your expression it is giving me following result , not the desire result.
In my data , I have time as one column (job time) . I want to show all the jobs and its time ( as an expression) but only those jobs who has no parent.
Thank you Tresesco, I have applied your solution except changed '>' to '=' and used in the load script . It is giving me what I want.
If(Len(Trim(Parent1&Parent2&Parent3&Parent4))=0, JOBNAME) as singlejob,
Then try using the above expression as calculated dimension and the time field as expression.
Try like this.
Try with where clause in the end , like where IsNull(Parent1)
Hi Ashis Sau,
Did you able to get the solution?
I created calculated dimension and used this expression to get my result.
Retrieving data ...