topic How to get a drilldown to work on $row$ with transpose command in dashboard XML? in Dashboards & Visualizations

How to get a drilldown to work on $row$ with transpose command in dashboard XML?

mrfredman — Thu, 30 Oct 2014 22:33:02 GMT

Hi,

I've got my dynamic drilldown setup and working properly so long as I don't include a transpose in the search string, but if a transpose is included the dynamic drilldown ceases to function.

It's setup as such in the dashboard xml:

 <drilldown target="New Window">
 <link>http://internal_link/foo/$row.id$</link>
        </drilldown>

I assume this is because after the transpose the referenced row ceases to exist. I had hoped that substituting $column.id$ would be a quick solution, but that doesn't seem to work.

Is there a way I can continue to reference the id after a transpose?

Re: How to get a drilldown to work on $row$ with transpose command in dashboard XML?

martin_mueller — Thu, 30 Oct 2014 23:24:55 GMT

Could you post your search and the rationale for using transpose as well as some sample data?

I'd hazard a guess that you can replace transpose with untable row column value | xyseries column row value, depending on what you're doing exactly of course. Then you could retain reasonable field names without the ugly column - row 1 - row 2 malarkey.

Re: How to get a drilldown to work on $row$ with transpose command in dashboard XML?

mrfredman — Fri, 31 Oct 2014 18:42:26 GMT

Switching the transpose to an untable did the trick. Didn't need to use xyseries at all.

Thanks.