Drill Down List

Dashboard Designer SharePoint 2013/2016, Office 365 versions
1

I have just come across your product and I like it very much. But I need to be able to drill down to list data without using code. I will have a bunch of people using this app and they won’t be technically savvy. is there another options that doesn’t use code?

2

Hi,
Dashboard Designer is a really flexible tool because of its advanced features. A lot of cases can be implemented only programmatically. We published a lot of examples at our website: http://spchart.com/, so even if you do not have programming skills, you can implement all these cases by copying and pasting the snippets.

3

Hello,

My company has purchased your product and I’ve been trying to do the copy paste adjustments of your code for several hours and have had no success. I’ve used the code below as I have multiple views and it is still not working based on the instructions, Can you please assist?

Our Assigned To is AssignedStaff
Our Request is RequestStatus
View ID in this instance is {999488AF-8BAA-4DFD-958A-0C5237E59B8B}

var handlers = {};
handlers.preRender = function (config, logger) {
logger.debug('Configuration: ', config);

var filtrationApplied = false;

config.plotAreaClick = function (e) {
    if (!filtrationApplied) {
        window.location.hash = '';
    }

    filtrationApplied = false;
}

config.seriesClick = function (e) {
    if (ctx && ctx.clvp) {
        var filter =
          'FilterField1=AssignedStaff-FilterValue1=' + e.dataItem.AssignedStaff + '-' +
          'FilterField2=RequestStatus-FilterValue2=' + e.dataItem.RequestStatus;

        window.location.hash = 'InplviewHash='{999488AF-8BAA-4DFD-958A-0C5237E59B8B}' +
        ctx.clvp.wpid + '=' + encodeURIComponent(filter);

        filtrationApplied = true;
    }
}

return true;

}

4

You have at least one syntax error in your code, here:

window.location.hash = 'InplviewHash='{999488AF-8BAA-4DFD-958A-0C5237E59B8B}' +

You need to remove the quote before the curly bracket. Why don you use ctx.clvp.wpid variable like we did in our sample:
http://www.spchart.com/documentation/link-chart-to-list

5

Hi Dmitry,

Thanks for the quick response! I copied the code provided on the site and altered accordingly, and I’ve tried removing that quote and it still does not work.

Also this variable ctx.clvp.wpid you are referencing I am not sure how to alter based on what you said. Can you provide more information?

Lu

6

Hi Lu,
If it is possible, could you provide temporary access to the site and the direct link to the page where you’ve published the chart? Drop the credentials to support@spchart.com. Thank you.

7

I put in a ticket yesterday my case is #447. Thank you for your help.

Lu

8

Could not find the credentials in the ticket. Is it possible to provide temporary access to the site? Drop the credentials to support@spchart.com.