Forum Discussion

rdegr's avatar
rdegr
Icon for Helper I rankHelper I
8 years ago
Solved

in selector json what is the 't' attribute

"{"selector":"{\"data\":[\"{\\\"comp\\\":{\\\"k\\\":0,\\\"l\\\":{\\\"col\\\":{\\\"s\\\":{\\\"e\\\":\\\"qtEmergencyRecords\\\"},\\\"r\\\":\\\"Year\\\"}},\\\"r\\\":{\\\"const\\\":{\\\"t\\\":4,\\\"v\\\"...
  • jppp's avatar
    jppp
    8 years ago

    Hi rdegr,

     

    I had a similar request andwas able to solve it in the following was:

     

    1. I create an array of custom identities, in this case it uses the category as text, but that can be changed to SQExprBuilder.number if needed.

    let categoryIdentities = categories.map((category) => {
    let sqlExpr = powerbi["data"].SQExprBuilder.equal(dataView.metadata.columns[0].expr, powerbi["data"].SQExprBuilder.text(category));
    return powerbi["data"].createDataViewScopeIdentity(sqlExpr);
});

    # ref: https://github.com/liprec/powerbi-boxWhiskerChart/blob/89179879a7209b030245fd05c317eee2034db394/src/boxWhiskerChart.ts#L260

    2. When I loop thru the individual catagories (=i variable)I use the following code to create the correct SelectionId identifier:

    let selectionId = new SelectionId({ data: [ categoryIdentities[i] ] }, false);

# ref: https://github.com/liprec/powerbi-boxWhiskerChart/blob/89179879a7209b030245fd05c317eee2034db394/src/boxWhiskerChart.ts#L282

    I added links to my solution for more reference and hope this can also work for your visual.

     

    -JP

rdegr's avatar
rdegr
Icon for Helper I rankHelper I
8 years ago

When I manually build "selector" strings identical to the ones I get if I only have a single column added to the control, then I get 

 

Uncaught TypeError: e.hasIdentity is not a function

 

at

 

this.selectionManager.select(arr, false)

rdegr's avatar
rdegr
Icon for Helper I rankHelper I
8 years ago

Trying to build the whole selector object, but don't know what the classes are and still get the same error.

 

                    let cat = this.dataView.categorical.categories[index-1];

                    cat.values.forEach((val:any, valIndex:number) => {

                        if (!hash[val+'']) {
                            hash[val+''] = true;
                        
                            let optV:HTMLOptionElement = document.createElement("option");
                            optV.text = val;
                            optV.value = val;
            
                            this.dropdownByValues.options.add(optV);

                            // this.selectionIds[val+''] = this.host.createSelectionIdBuilder()
                            //     .withCategory(cat, valIndex)
                            //     .createSelectionId();

                            var expr:any = cat.source.expr;
                            var typ:any = cat.source.type;
                            var typVal = (typ.primitiveType == 1 ? "\"" + val + "\"" : val);
                            var dm:string = expr.source.entity + "." + expr.ref;

                            var obj:any = {
                                expr: {
                                    comparison: 0,
                                    kind: 13,
                                    left: { kind: 2, ref: expr.ref, source: expr.source },
                                    right: { kind:17, type: typ, value: typVal }
                                },
                                key: "{\"comp\":{\"k\":0,\"l\":{\"col\":{\"s\":{\"e\":\"" + expr.source.entity + "\"},\"r\":\"" + expr.ref + "\"}},\"r\":{\"const\":{\"t\":" + typ.primitiveType + ",\"v\":" + typVal + "}}}}",
                                kind: 1  
                            };

                            this.selectionIds[val+''] = {
                                highlight: false,
                                key: "{\"selector\":\"{\\\"data\\\":[\\\"{\\\\\\\"comp\\\\\\\":{\\\\\\\"k\\\\\\\":0,\\\\\\\"l\\\\\\\":{\\\\\\\"col\\\\\\\":{\\\\\\\"s\\\\\\\":{\\\\\\\"e\\\\\\\":\\\\\\\"" + expr.source.entity + "\\\\\\\"},\\\\\\\"r\\\\\\\":\\\\\\\"" + expr.ref + "\\\\\\\"}},\\\\\\\"r\\\\\\\":{\\\\\\\"const\\\\\\\":{\\\\\\\"t\\\\\\\":" + typ.primitiveType + ",\\\\\\\"v\\\\\\\":" + typVal + "}}}}\\\"]}\",\"highlight\":false}",
                                keyWithoutHighlight: "{\"selector\":\"{\\\"data\\\":[\\\"{\\\\\\\"comp\\\\\\\":{\\\\\\\"k\\\\\\\":0,\\\\\\\"l\\\\\\\":{\\\\\\\"col\\\\\\\":{\\\\\\\"s\\\\\\\":{\\\\\\\"e\\\\\\\":\\\\\\\"" + expr.source.entity + "\\\\\\\"},\\\\\\\"r\\\\\\\":\\\\\\\"" + expr.ref + "\\\\\\\"}},\\\\\\\"r\\\\\\\":{\\\\\\\"const\\\\\\\":{\\\\\\\"t\\\\\\\":" + typ.primitiveType + ",\\\\\\\"v\\\\\\\":" + typVal + "}}}}\\\"]}\"}",
                                selector: {
                                    data: [{
                                        obj
                                    }]
                                },
                                selectorsByColumn: {
                                    dataMap: {
                                    }
                                }
                            };

                            this.selectionIds[val+''].selectorsByColumn.dataMap[dm] = obj;
                        }
                    });