Robert,

My advice on drill down charts is to *not* configure them as they are laid out in the KB article. The conditional formatting on all of the fields creates incredibly complicated nested IF statements that are very difficult to expand upon and equally difficult to troubleshoot.

I advise instead that you use the "JumpToReport" functionality in the "Pivot>Data Groupings>Values>Action" tab. You can add parameters here and use them to filter the nevron chart web parts in the target page. In this way you do not have to configure each parameter with a conditional IF statement and it makes life a lot easier (in my opinion).

To the Nevron Staff: it might behoove you to create an "alternate" drill down KB article using the "Jump To URL" and "Jump To Report" functionality. I find them to be far less obfuscated and they were the recommended means of drill down told to us during training with your staff.

Robert,
If you have empty rows, they will be grouped – an empty group.
If needed, you can remove the empty records by adding a global (or category) filter. For example:
=ISEMPTY(Fields!Region)=FALSE

Take a look at the following KB topic: http://support.nevron.com/KB/a155/remove-empty-data-from-data-source-chart-sharepoint.aspx

Best Regards,
Nevron Support Team

Thanks for the tip - but it wasn't the Action I was missing. It was the Report...

Now I'm working on my grouping and filtering, does the data in the spreadsheet need to be contiguous in all columns? The way our data is reported leaves empty rows in the columns.

Hi Robert,
Probably you need to check if you have configured the Action for the Values Data Grouping.

Because it’s not clear what may be wrong, you can contact the Support Team requesting a web meeting: support@nevron.com

Best Regards,
Nevron Support Team

After getting the KB sample drill down chart working, I'm trying to get a drill down chart with our own data working. I've run into an issue that I haven't figured out.

I've gone through the example and modified each part to fit our data, but I do not get links from the bars in the graph to drill to the next level. In other words, when I hover the mouse pointer over the bars in the top level chart, I do not get the pointing-finger icon indicating this is a hyperlink. I click on it anyway and nothing happens.

Can you point me in the right direction?

Thanks!

I have used both of the following:

=Params![SiteUrl].STR + "/PIQA/Dashboard/default.aspx"
where the string is the path to the page with the drill down chart

=REPLACE(Params![PageUrl].STR, "http", "https")

They both work fine in our environment.
Thank you for your help.

Hi Robert,
Have you used the REPLACE function?
Let us know if  you still meet any problems.

Best Regards,
Nevron Support Team

Sorry, I don't have access to the server so I cannot tell you the version of the dll.

After I posted, I found the parameter DrillLevel was not being populated (I added it as part of the X-axis label). I noticed in  Pivot >> Data Groupings >> Values >> Action (from Section 2.2 in the KB article) that DrillLevel was not present. So I added it again; and it did not apply. So this morning I tried it again and it applied and it is working now, but I'm am using =Params![SiteUrl].STR + "/<path to page>/default.aspx" in the Report expression.

I'm going to try to modify to suit my data. If I have issues I'll post again.

Thanks!

Hello Robert,
Which is the version of the Nevron DLLs you currently work with?
You can check the DLL build version in the server where you installed Nevron. This issue should be fixed in a newer version.

Anyways, if you are still experiencing the problem, you should be able to workaround it by using an expression with the REPLACE function. For example:
=REPLACE(Params![PageUrl].STR, "http", "https")

Best Regards,
Nevron Support Team

I'm having the same issue as Bob.

I've uploaded the KB .xlsx file, modified the chart per the drill down KB article and it does not work because when I click on any bar the URL loaded is HTTP when I'm in an HTTPS site. I'm going to try Bob's suggested fix and see if I can make it work.