Smart Reporting - Dynamic CASE WHEN
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
The same question
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
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
Replies have been locked on this page!