Hi,

this is gangaraju,
i just gone through documentation "Create interactive drill-down chart in SharePoint" which is provided by nevron.
but in the chart after clickiing on region sales i didn't get company wise sales. every time i am getting region wise sales only, please help me. i think so the problem is with in the parameter value.

Thanks & Regards
raju

Hello gangaraju,
Yes, you may have configured the Chart Web Part incorrectly or you may have problem with the parameters.
Take a look at the following online example, it demonstrates the drill-down action: Interactive Drill-Down

You can run the Chart Designer to explore the configuration. Take a look at the Pivot tab >> Action tab.

Best Regards,
Nevron Support Team

It seems that the KB article on creating drill down charts (http://support.nevron.com/KB/a203/create-interactive-drill-down-chart-in-sharepoint.aspx) uses an *entirely* different data set than the interactive drill down example that was linked below (http://spchartexamples.nevron.com/Interactive%20Dashboards/Interactive%20Drill-Down/default.aspx)

I've spent the better part of three hours comparing the chart I created using the KB article and the one in the interactive example:

There are no "city" values in the data set for the KB article example. Affecting all the configuration changes that can be seen in the linked example to the chart generated by the KB article causes it to fail.

Any chance either the KB article could be revised or the data set for the interactive drill down chart could be published?

Much appreciated!

Hi Bob,
Please note that the KB topic is simply an article describing the most simple case.
The online example that is provided is a more complex case with multiple drill-down levels (4 levels). The data set is similar, however in the online example there are two additional columns: City and Branch.

If this would be of assistance, we will update the KB topic to correspond with the provided example.

Best Regards,
Nevron Support Team

Hi Bob,
You can now review the updated KB topic at: http://support.nevron.com/KB/a203/create-interactive-drill-down-chart-in-sharepoint.aspx
You will also be able to download the full sample data.

Note that the KB topic now includes more complex expressions in order to perform the required multi-level drill-down.

Best Regards,
Nevron Support Team

Awesome! Thank you so much for the response. As soon as I get some time I will dig into it and let you know what I find. Greatly appreciate it.

All right, that worked like a champ! Let me make a note of some revisions to the KB Article that would make it easier to use:

Section 2.1:
Add the following line:

From Pivot >> Data Groupings >> Values add a new value

Change the following line:

We will be performing drill-down on the same page. For the Report field, use the following expression: =Params![SiteUrl].STR

To

We will be performing drill-down on the same page. For the Report field, use the following expression: =Params![SiteUrl].STR + "/SitePages/DrillDownPage.aspx

(You are redirected to the top of your site collection if you don't add the location of the ASPX page to the SiteURL parameter)

Section 2.2:
Change the following line:

The Action Type will be conditional using the following expression:
=IF(TONUM(Params!DrillLevel.STR) >= 3, "None", "JumpToReport")"

To

Using the button next to "Action Type" create a conditional action using the following expression:
=IF(TONUM(Params!DrillLevel.STR) >= 3, "None", "JumpToReport")

Sections 2.3, 6.1 & 6.2:

All of these sections have expressions that contain line breaks. I don't know if line breaks will cause errors within the charting software; I personally removed them.

Section 5.1:
Change the following line:

5.1. For the Chart >> Chart Areas >> Axes >> Primary X >> Title

To

5.1. For the Chart >> Chart Areas >> Axes >> Primary X >> Title - "Text" field

Also, I would bold "Primary X" as I accidentally used the Primary Y since it is the first value in the Axes list. My fault, I know.

Section 6.2:
Change the following line:


For the Report use: =Params![PageUrl].STR

To

=Params![SiteUrl].STR + "/SitePages/DrillDownPage.aspx

I might also include instructions on how to format the chart to look like the example, but that can be done by comparing the settings in the interactive drill down example to the chart that is being created.

Otherwise this is great! I may try to mock up a "simpler" example of my own that only has 1 layer of drill down.

Thanks a lot!

Hi Bob,

Instead of using =Params![WebUrl].STR you should use =Params![PageUrl].STR

We will update the KB topic shortly.

Best Regards,
Nevron Support Team

Thanks! Unfortunately the PageURL parameter puts "http://" in front of the URL string. Our site is secured and uses SSL to connect; the URL starts with "https://". So, in my case I can't actually use it!

Hi Bob,

Do you still have an issue with the PageURL parameter?

Let us know if this problem has been resolved.

Best Regards,
Nevron Support Team