topic Re: Complicated output - Help required in App Development

Complicated output - Help required

jpjust — Thu, 13 Jan 2022 17:09:41 GMT

Hi All,

If some one can help me would be much appreciated.

Here is my raw output below from the script.

From the above, I am looking for an output like the below as single record (Basically the highlighted ones from above)

I want to achieve this by writing expression on the front end rather than on the load script.

I tried expressions such as Max etc., but did not work.

Thanks for taking time to look into this.

Re: Complicated output - Help required

MarcoWedel — Thu, 13 Jan 2022 20:05:47 GMT

Please post some sample values as text and specify the logic that defines the expected result.

thanks

Re: Complicated output - Help required

jpjust — Thu, 13 Jan 2022 21:19:53 GMT

Hi Marco,

Thank you for the initiative to help here.

I have attached the sample qvf itself to make it clear. This is based off an monitoring app and I am trying to bring a bit more info from Analysis script.

Please look at the Analysis sheet and I filtered out for App Names.

Following is the output I expect for TEST and TEST(w)

Basically, the Max Analyzed Date for the App Name should get aligned with AppName that don't have (1)

The app list are those published today. For that I use an expression like this - =Aggr(Only({<[App Publish Date] = {'$(=Date(Today(),'YYYY-MM-DD'))'}>}[AppName]),[AppName])

Desired output

Please let me know if this is some thing doable.

Thanks very much!!