Profile Picture

Drilldown_Chart webpart

Posted By raju ganga 12 Years Ago
Author
Message
Robert Gervais
Posted 11 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 5, Visits: 1

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.



Nevron Support
Posted 11 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746

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



Robert Gervais
Posted 11 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 5, Visits: 1

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!



Nevron Support
Posted 11 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746
Hi Robert,
Have you used the REPLACE function?
Let us know if  you still meet any problems.

Best Regards,
Nevron Support Team



Robert Gervais
Posted 11 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 5, Visits: 1

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.



Robert Gervais
Posted 11 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 5, Visits: 1

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!



Nevron Support
Posted 11 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746

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



Robert Gervais
Posted 11 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 5, Visits: 1

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.



Nevron Support
Posted 11 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746

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



Bob Smith
Posted 11 Years Ago
View Quick Profile
Forum Guru

Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 69, Visits: 1

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.





Similar Topics


Reading This Topic