Missing Date Drilldown

Hi all

This is an issue with a workaround.

I built a new Stacked Vertical Barchart using a date column on the x-axis, and was not getting date drilldowns. Publishing did not improve it.

I had another visual where the drilldown was working, so as an experiment, I created a copy of the working one, and that also did not have the drilldown capability.

I exported a bundle for the dashboard and found that the only significant difference between the working and not-working visuals was that the working ones had an array attribute “drillDownFilters” in the XML that was missing in the ones that didn’t work:

“columnHierarchies”: [
{
“dateTimeHierarchy”: {
“hierarchyId”: “…”,
“drillDownFilters”:
}
}
]

I deleted the analysis using the CLI to make sure it was completely removed and reloaded the bundle. Voila! The offending drilldowns are now working.

I re-exported the bundle and found that the “drillDownFilters” element is now present!

It’s a bit of a PITA to have to go through these steps to make the drilldowns work, so if anyone can guess as to what I would need to do to get them working via the gui, I’m all ears!

Thx.

For XML, read JSON.
:blush:

Hi @Jeremy_Likezero,
Thank you for the detailed breakdown of the situation. I’ll mark as solution and archive so that it stays in the history for others’ to view.