Why is drill-in not working in my Analytics report?

Question

Why do I sometimes see the error No data available when you perform a drill-in in an Explore report?

Answer

By default, drill-in does not work on any custom attribute value of null. If you drill in on a null value, or a combination of values that includes at least one null value, you see the error.

To resolve this, update the NULL handling logic on your report. Under Result Manipulation > SQL options, change the Replace NULL by setting to NULL.

For more information, see Using drill-in to refine your report.