By using this website, you agree to our Terms of Use (click here)
I have a DB Chart where the Chart Value is built off a GI Calculated Field (=CDec([INTran.TranCost]*[INTran.InvtMult])) with a Caption of "Ext Cost". When I drill down no results are displayed. I have found the issue to be with the dynamic filter being built for the DrillDown tab of the GI. It is adding "Ext Cost Is Not Null" to the filter. If I de-activate this part of the filter the desired results set shows.
Bug or am I doing something wrong?
Thanks,
Brett
I figured it out... One of the Axis I was using intran.finperiodid. Changing that to utilize createddatetime instead appears to have solved the drill-down issue.
Interesting. I've noticed a similar issue, but hadn't found a workaround for it. Thanks for sharing.
I am also facing this issue and still not found any solution.
I've noticed a few issues with Dashboard Widget drill down, most recently when a Switch formula is involved. The DRILLDOWN filter that got applied to the Generic Inquiry at time of drilldown returned different results than if I were to apply the filter to the column within the Generic Inquiry. I checked the SQL that gets run and it was different.
The main point here is that you have to be careful with drill down in Dashboard Widgets, just confirm that it's doing what you expect it to do.