Smart Reporting - Dynamic CASE WHEN

Stefan shared this question 2 months ago
Answered

Hello,


Is it possible to use

SUM (CASE WHEN ( ... ) ) clause where in CASE WHEN part of the clause I could use User Prompt?

E.g.

SUM (CASE WHEN (closed_date between DateFrom AND DateTo) ) THEN 1 ELSE 0 END as Resolved )

Where DateFrom and DateTo would be given by User

Kind regards,

Stefan

Comments (3)

photo
2

Hi Stefan,

this is easily possible by using Yellowfin's powerful and flexible Parameter feature. However, I notice that you are from ComTrade who signed a strategic partnership with BMC in 2012, so if you are actually dealing with BMC's AR data source then this may or may not be possible due to BMC's bespoke AR JDBC driver in which case I would recommend that you go to BMC support for help with this requirement.

regards,

David

photo
1

Thank you for a quick replay and helpful remark. :)

photo
1

you're welcome, I hope it works out for you (either with Yellowfin's Parameter feature or with BMC support)

regards,

David

photo