Explore Drillthrough

Hi @Carl Cassar

I have found it pretty tricky at times to ensure that the drillthrough results match up to the query results. As I understand things, drillthrough doesn't take metric level filters into consideration. For example, I assume you're using the "Public comments" metric, and the formula for that metric is:

IF ([Comment present] = TRUE AND [Comment public] = TRUE) THEN [Update ID] ENDIF

So, this metric is essentially "Updates" but with a filter that a comment is a) present and b) public. However, drillthrough would only see "Updates".

So, you'd need to add a filter to the query itself. I would try adding the "Comment public" filter and selecting "True", like this.

Hope this helps.

Thanks so much Hannah for this,

I have another question, why does in the engagement chat data set report, ticket id works but then in drill through when you click on ticket id it does not show anything 

Hey @Carl Cassar

I don't use the Chat dataset myself but I think I know what you mean. Many times I've tried to add an attribute to drillthrough but then it appears blank. This article explains why.

"Only attributes or metrics that are selected to include in your query itself will show up in drillthroughs. This means if any of the attributes selected in the drillthrough are not already included in your query (as a row, column or filter), they cannot be shown in the drillthrough results."

Even so, I haven't always found that to be the case. Sometimes I add an attribute to a drillthrough that I don't have as a row, column, or filter, and it does pull through. It seems to be a bit of trial and error. 😬