Calculated field in Sub-query

Hi Asaf,

Thanks for reaching out to support with your issue.

Just wanted to make sure I understand your situation:

You have a calculated field in a report subquery -

The goal would be to use this calculated field in your main query, but the field you have created is not present here -

Is that correctly detailing your experiences in this case?

Thanks,

Eric

Yes, my point is that when using subquery u can not use calculated field more than once

From: Support Queue <support@Yellowfin.bi>

Sent: Tuesday, March 19, 2019 8:49 PM

To: Asaf Hanina <asafha@tfm.ltd>

Subject: Re: Calculated field in Sub-query [#12907]

Hi Asaf,

Just to confirm, I tested creating and adding multiple calculated fields from within my subquery, this worked as expected.

However, these calculated fields did not show up in the list for my master query, or any additional subqueries I created afterwards.

To clarify your reply, your "point is that when using subquery u can not use calculated field in other queries?"

Thanks,

Eric

Hey Eric,

yes

From: Support Queue <support@Yellowfin.bi>

Sent: Wednesday, March 20, 2019 7:34 PM

To: Asaf Hanina <asafha@tfm.ltd>

Subject: Re: Calculated field in Sub-query [#12907]

Thanks for confirming, Asaf. I wanted to make my report succinct for developers.

One possible alternative "fix" for this behavior: I did find a way to get a calculated field to show up throughout all my report queries. This was done by adding the calculated field at the View level, which makes the calculation a metric that is usable in both the master and sub query:

Would this be a possible solution in your environment? Also, could you confirm for me that you'd like to create a developer task to address the issue as we've identified here?

I already using this solution, but it’s not cover 100% of the cases

From: Support Queue <support@Yellowfin.bi>

Sent: Thursday, March 21, 2019 5:49 PM

To: Asaf Hanina <asafha@tfm.ltd>

Subject: Re: Calculated field in Sub-query [#12907]

Hi Asaf,

I've gone ahead and created an enhancement request with our developers for this added functionality. Updates to the task will be provided here as they are available. I've in turn marked this ticket as Idea Logged; feel welcome to reply to this thread with related inquiries.

Thanks,

Eric

Hi Asaf,

It looks like you can now reference calculated fields in sub-queries in the master query in latest 8 and 9:

8.0.8:

9.3.1:

Please upgrade and give it another try and let us know how goes.

Regards,

Mike

Hey Mike,

We are not working with Yellowfin for long

Thanks anyway

From: Yellowfin Support <support@yellowfin.bi>

Sent: Monday, December 7, 2020 4:57 PM

To: Asaf Hanina <asafha@finovation.com>

Subject: New Comment in "Calculated field in Sub-query"

Hi Asaf,

Thanks for the update here. Since this is now working in newer versions, I'll go ahead and mark this Idea as Completed at this time.

Thanks,

Eric