Ask Search:
Sridhar VynojuSridhar Vynoju 
"filters": [ [ "OneDate", "{{row(OneDate_1.selection, [0], [\"min\", \"max\"]).asDateRange(\"date('OneDate_Year', 'OneDate_Month', 'OneDate_Day')\")}}", "><" ] ]
 
{
    "label": "test2",
    "mobileDisabled": false,
    "state": {
        "steps": {
            "OneDate_1": {
                "type": "aggregateflex",
                "datasets": [
                    {
                        "name": "OneMeasureCaseData",
                        "url": "/services/data/v46.0/wave/datasets/0Fb1P000000bw6hSAA",
                        "id": "0Fb1P000000bw6hSAA"
                    }
                ],
                "query": {
                    "groups": [
                        "OneDate"
                    ],
                    "measures": [
                        [
                            "count",
                            "*"
                        ]
                    ]
                },
                "broadcastFacet": true,
                "receiveFacet": true,
                "isGlobal": false,
                "useGlobal": true,
                "selectMode": "single",
                "visualizationParameters": {
                    "options": {}
                }
            },
            "OneDate_Year_1": {
                "type": "aggregateflex",
                "query": {
                    "measures": [
                        [
                            "count",
                            "*"
                        ]
                    ],
                    "groups": [
                        "OneDate_Year"
                    ],
                    "filters": [
                        [
                            "OneDate",
                            "{{row(OneDate_1.selection, [0], [\"min\", \"max\"]).asDateRange(\"date('OneDate_Year', 'OneDate_Month', 'OneDate_Day')\")}}",
                            "><"
                        ]
                    ]
                },
                "visualizationParameters": {
                    "options": {},
                    "type": "chart",
                    "parameters": {
                        "visualizationType": "hbar",
                        "autoFitMode": "keepLabels",
                        "theme": "wave",
                        "title": {
                            "label": "",
                            "fontSize": 14,
                            "subtitleLabel": "",
                            "subtitleFontSize": 11,
                            "align": "center"
                        },
                        "showValues": true,
                        "axisMode": "multi",
                        "binValues": false,
                        "bins": {
                            "breakpoints": {
                                "low": 0,
                                "high": 100
                            },
                            "bands": {
                                "low": {
                                    "label": "",
                                    "color": "#B22222"
                                },
                                "medium": {
                                    "label": "",
                                    "color": "#ffa500"
                                },
                                "high": {
                                    "label": "",
                                    "color": "#008000"
                                }
                            }
                        },
                        "dimensionAxis": {
                            "showAxis": true,
                            "showTitle": true,
                            "title": "",
                            "customSize": "auto",
                            "icons": {
                                "useIcons": false,
                                "iconProps": {
                                    "column": "",
                                    "fit": "cover",
                                    "type": "round"
                                }
                            }
                        },
                        "measureAxis1": {
                            "sqrtScale": false,
                            "showAxis": true,
                            "customDomain": {
                                "showDomain": false
                            },
                            "showTitle": true,
                            "title": ""
                        },
                        "measureAxis2": {
                            "sqrtScale": false,
                            "showAxis": true,
                            "customDomain": {
                                "showDomain": false
                            },
                            "showTitle": true,
                            "title": ""
                        },
                        "legend": {
                            "show": true,
                            "showHeader": true,
                            "inside": false,
                            "descOrder": false,
                            "position": "right-top",
                            "customSize": "auto"
                        },
                        "tooltip": {
                            "customizeTooltip": false,
                            "showDimensions": true,
                            "dimensions": "",
                            "showMeasures": true,
                            "measures": "",
                            "showPercentage": true,
                            "showNullValues": true,
                            "showBinLabel": true
                        },
                        "trellis": {
                            "enable": false,
                            "showGridLines": true,
                            "flipLabels": false,
                            "type": "x",
                            "chartsPerLine": 4,
                            "size": [
                                100,
                                100
                            ]
                        },
                        "applyConditionalFormatting": true,
                        "showActionMenu": true,
                        "columnMap": {
                            "trellis": [],
                            "plots": [
                                "count"
                            ],
                            "dimensionAxis": [
                                "OneDate_Year"
                            ]
                        }
                    }
                },
                "datasets": [
                    {
                        "id": "0Fb1P000000bw79SAA",
                        "name": "OneMeasureClosedCaseData",
                        "label": "OneMeasureClosedCaseData",
                        "url": "/services/data/v46.0/wave/datasets/0Fb1P000000bw79SAA"
                    }
                ],
                "useGlobal": true,
                "isGlobal": false,
                "broadcastFacet": true,
                "receiveFacet": true,
                "selectMode": "single"
            }
        },
        "widgets": {
            "dateselector_1": {
                "type": "dateselector",
                "parameters": {
                    "defaultFiscalMode": false,
                    "calendarTypeSwitchingAllowed": true,
                    "absoluteModeEnabled": true,
                    "relativeModeEnabled": true,
                    "presetsEnabled": true,
                    "title": "OneDate",
                    "instant": false,
                    "showActionMenu": true,
                    "displayMode": "filter",
                    "filterStyle": {
                        "titleColor": "#54698D",
                        "valueColor": "#16325C"
                    },
                    "step": "OneDate_1"
                }
            },
            "chart_1": {
                "type": "chart",
                "parameters": {
                    "visualizationType": "hbar",
                    "autoFitMode": "keepLabels",
                    "theme": "wave",
                    "title": {
                        "label": "",
                        "fontSize": 14,
                        "subtitleLabel": "",
                        "subtitleFontSize": 11,
                        "align": "center"
                    },
                    "showValues": true,
                    "axisMode": "multi",
                    "binValues": false,
                    "bins": {
                        "breakpoints": {
                            "low": 0,
                            "high": 100
                        },
                        "bands": {
                            "low": {
                                "label": "",
                                "color": "#B22222"
                            },
                            "medium": {
                                "label": "",
                                "color": "#ffa500"
                            },
                            "high": {
                                "label": "",
                                "color": "#008000"
                            }
                        }
                    },
                    "dimensionAxis": {
                        "showAxis": true,
                        "showTitle": true,
                        "title": "",
                        "customSize": "auto",
                        "icons": {
                            "useIcons": false,
                            "iconProps": {
                                "column": "",
                                "fit": "cover",
                                "type": "round"
                            }
                        }
                    },
                    "measureAxis1": {
                        "sqrtScale": false,
                        "showAxis": true,
                        "customDomain": {
                            "showDomain": false
                        },
                        "showTitle": true,
                        "title": ""
                    },
                    "measureAxis2": {
                        "sqrtScale": false,
                        "showAxis": true,
                        "customDomain": {
                            "showDomain": false
                        },
                        "showTitle": true,
                        "title": ""
                    },
                    "legend": {
                        "show": true,
                        "showHeader": true,
                        "inside": false,
                        "descOrder": false,
                        "position": "right-top",
                        "customSize": "auto"
                    },
                    "tooltip": {
                        "customizeTooltip": false,
                        "showDimensions": true,
                        "dimensions": "",
                        "showMeasures": true,
                        "measures": "",
                        "showPercentage": true,
                        "showNullValues": true,
                        "showBinLabel": true
                    },
                    "trellis": {
                        "enable": false,
                        "showGridLines": true,
                        "flipLabels": false,
                        "type": "x",
                        "chartsPerLine": 4,
                        "size": [
                            100,
                            100
                        ]
                    },
                    "applyConditionalFormatting": true,
                    "showActionMenu": true,
                    "columnMap": {
                        "trellis": [],
                        "plots": [
                            "count"
                        ],
                        "dimensionAxis": [
                            "OneDate_Year"
                        ]
                    },
                    "step": "OneDate_Year_1"
                }
            }
        },
        "filters": [],
        "gridLayouts": [
            {
                "name": "Default",
                "numColumns": 12,
                "rowHeight": "normal",
                "version": 1,
                "pages": [
                    {
                        "label": "Untitled",
                        "name": "ec349400-d7b5-45cf-bb26-d777f45295c4",
                        "widgets": [
                            {
                                "row": 0,
                                "column": 0,
                                "rowspan": 1,
                                "colspan": 3,
                                "name": "dateselector_1",
                                "widgetStyle": {
                                    "backgroundColor": "#FFFFFF",
                                    "borderEdges": [
                                        "all"
                                    ],
                                    "borderColor": "#E6ECF2",
                                    "borderWidth": 1,
                                    "borderRadius": 4
                                }
                            },
                            {
                                "row": 1,
                                "column": 0,
                                "rowspan": 5,
                                "colspan": 7,
                                "name": "chart_1",
                                "widgetStyle": {}
                            }
                        ],
                        "navigationHidden": false
                    }
                ],
                "selectors": [],
                "style": {
                    "backgroundColor": "#F2F6FA",
                    "gutterColor": "#C5D3E0",
                    "cellSpacingX": 8,
                    "cellSpacingY": 8,
                    "fit": "original",
                    "alignmentX": "left",
                    "alignmentY": "top"
                }
            }
        ],
        "dataSourceLinks": [],
        "widgetStyle": {
            "backgroundColor": "#FFFFFF",
            "borderEdges": [],
            "borderColor": "#E6ECF2",
            "borderWidth": 1,
            "borderRadius": 0
        }
    },
    "datasets": [
        {
            "name": "OneMeasureClosedCaseData",
            "url": "/services/data/v46.0/wave/datasets/0Fb1P000000bw79SAA",
            "id": "0Fb1P000000bw79SAA"
        },
        {
            "name": "OneMeasureCaseData",
            "url": "/services/data/v46.0/wave/datasets/0Fb1P000000bw6hSAA",
            "id": "0Fb1P000000bw6hSAA"
        }
    ]
}

 
Best Answer chosen by Sridhar Vynoju
Akshay AhujaAkshay Ahuja
Hello Sridhar,

Can you try the following syntax for the Date filter:
"filters": 
[
    [ "OneDate", 
      "{{row(OneDate_1.selection, [], [\"min\",\"max\"]).asObject()}}", 
      ">=<=" 
    ]
]

Best Regards,
Akshay
Best Answer chosen by Rakhi Shrivastava
shahul mtshahul mt
Hey Rakhi,

Take the dataflow of that dataset ,edit it .Click the sfdcdigest node of the opportunity object where the object is extracted and in the  field option you can add more fields.after adding it click the  save button .When saving it a pop up menu will appear wether to proppgate or not.Choose the option to propogate .After that update the dataflow and run it.

if its find helpful mark this as best.else reply 
 
Aydin Can PolatkanAydin Can Polatkan 
Currently I can sort bar segments of a stacked column chart in asc/desc order or keep it unsorted. However I would like to sort them in a custom fashion like in the image. How to do it with custom SAQL or XMD?

Reorder Bar Segments
Best Answer chosen by Aydin Can Polatkan
Aydin Can PolatkanAydin Can Polatkan
Dear Akshay, thanks for your efforts and your answer.

Indeed I used a similar approach using the SAQL mode. However I also wanted to get rid of the numbers in the legend. Therefore I edited the XMD .json file as well.

Here is my complete answer to the question. (http://www.aydincanpolatkan.com/blog/2527)
Nicole PomponioNicole Pomponio 
I am building out our Einstein Bot in Partial and I cannot save Intents. Has anyone else had this issue? I can click to Edit and then type in the intent but on save nothing is saved
Best Answer chosen by Nicole Pomponio
Stephanie MurrayStephanie Murray
Sooooooo, feeling really dumb but I was clicking Save after entering in a customer input. I needed to hit ENTER after every input in order to get a list below. Posting in case this is root of anyone else's problem and they had a long week as well?

User-added image
Chrystele BenjaminChrystele Benjamin 
Hello,

I took a recorded course on dataflows and the instructor would zoom in or out seemlessly to show the whole dataflow or just a portion of it.

Anyone knows what the keyboard shortcut is to do that?
Best Answer chosen by Chrystele Benjamin
Amnon KruviAmnon Kruvi
CTRL +
CTRL -
And as a bonus: CTRL <Mouse Scrollwheel>
Thomas IvyThomas Ivy 
Hi I have Datasets and a Dashboard build in my Sandbox in the My Private App. How do I move them to another App, then push that App to production?
Best Answer chosen by Ed (salesforce.com) 
Amnon KruviAmnon Kruvi
If you open the dataset, there is a little edit icon next to the name of the app it's in (My Private App). Click that, and you are able to move it elsewhere:
User-added image
alex birgeralex birger 
Hi All,

I have a question on multiselection of values. In a dashboard, is there a way in a particular chart(bar chart of accounts and revenue as a measure for example) to select multiple bars(accounts) so that other related charts are filtered based on multiple accounts rather than one.
 
Best Answer chosen by alex birger
Akshay AhujaAkshay Ahuja
Hello Alex,

You can choose Selection Type = Multiple Selection in Step properties of bar chart. See below:

User-added image

Also, make sure broadcast selection as facets is checked. This would filter related charts based on selected values.

Hope this helps.

Best Regards,
Akshay
Aparna PuvvadaAparna Puvvada 
Hi All,

I have created a Static filter with custom values and created another compare table also,
and i am trying to filter the data in compare table with the Static filter.

for that i am trying to pass the binding code in Compare table level, but i am getting errors.

Please look in to the below and provide the solution for this.

Static filter code:

"Period_1": {
                "broadcastFacet": true,
                "groups": [],
                "label": "Period",
                "numbers": [],
                "selectMode": "single",
                "strings": [],
                "type": "staticflex",
                "values": [
                    {
                        "display": "This Month",
                        "value": [
                            [
                                [
                                    "month",
                                    0
                                ],
                                [
                                    "month",
                                    0
                                ]
                            ]
                        ],
                        "drange": "[\"current month\"..\"current month\"]"
                    },
                    {
                        "display": "This Quarter",
                        "value": [
                            [
                                [
                                    "quarter",
                                    0
                                ],
                                [
                                    "quarter",
                                    0
                                ]
                            ]
                        ],
                        "drange": "[\"current quarter\"..\"current quarter\"]"
                    }
                ]
            }
        },

Compare table code:

"MM_BUD_In_USD_1": {
                "broadcastFacet": true,
                "datasets": [
                    {
                        "id": "0Fbd0000000wz3qCAA",
                        "label": "Margin_Cube_BWP",
                        "name": "BWQ",
                        "url": "/services/data/v42.0/wave/datasets/0Fbd0000000wz3qCAA"
                    }
                ],
                "isGlobal": false,
                "query": {
                    "measures": [
                        [
                            "sum",
                            "MM_BUD_In_USD",
                            "A"
                        ]
                    ],
                    "columns": [
                        {
                            "query": {
                                "measures": [
                                    [
                                        "sum",
                                        "MM_BUD_In_USD"
                                    ]
                                ]
                            }
                        }
                    ],
                    "filters": [
                        [
                            "Period",
                            "{{column(Period_1.selection, [\"Period\"]).asObject()}}",
                            "in"
                        ]
                    ]
                },
                "receiveFacet": true,
                "selectMode": "single",
                "type": "aggregateflex",
                "useGlobal": true,
                "visualizationParameters": {
                    "options": {},
                    "parameters": {
                        "borderColor": "#e0e5ee",
                        "borderWidth": 1,
                        "cell": {
                            "backgroundColor": "#ffffff",
                            "fontColor": "#16325c",
                            "fontSize": 12
                        },

Error screen shot: 
"  This widget can't be displayed because there is a problem with its source step:
The binding 'column(Period_1.selection, ["Period"]).asObject()' contains an error: The column name 'Period' doesn't exist in the data. "
Best Answer chosen by Aparna Puvvada
Akshay AhujaAkshay Ahuja
Hello Aparna,

Could you make the following changes and see if it works:

1. For Static Step, remove 1 pair of square brackets for both 'This Month' and 'This Quarter' values.

"Period_1": {
                "broadcastFacet": true,
                "groups": [],
                "label": "Period",
                "numbers": [],
                "selectMode": "single",
                "strings": [],
                "type": "staticflex",
                "values": [
                    {
                        "display": "This Month",
                        "value": [
                                [
                                    "month",
                                    0
                                ],
                                [
                                    "month",
                                    0
                                ]
                        ],
                        "drange": "[\"current month\"..\"current month\"]"
                    },
                    {
                        "display": "This Quarter",
                        "value": [
                                [
                                    "quarter",
                                    0
                                ],
                                [
                                    "quarter",
                                    0
                                ]
                        ],
                        "drange": "[\"current quarter\"..\"current quarter\"]"
                    }
                ]
            }
        },

2. Change Syntax of Binding code to have value and >=<= as shown below:

"MM_BUD_In_USD_1": {
                "broadcastFacet": true,
                "datasets": [
                    {
                        "id": "0Fbd0000000wz3qCAA",
                        "label": "Margin_Cube_BWP",
                        "name": "BWQ",
                        "url": "/services/data/v42.0/wave/datasets/0Fbd0000000wz3qCAA"
                    }
                ],
                "isGlobal": false,
                "query": {
                    "measures": [
                        [
                            "sum",
                            "MM_BUD_In_USD",
                            "A"
                        ]
                    ],
                    "columns": [
                        {
                            "query": {
                                "measures": [
                                    [
                                        "sum",
                                        "MM_BUD_In_USD"
                                    ]
                                ]
                            }
                        }
                    ],
                    "filters": [
                        [
                            "Period",
                            "{{column(Period_1.selection, [\"value\"]).asObject()}}",
                            ">=<="
                        ]
                    ]
                },
                "receiveFacet": true,
                "selectMode": "single",
                "type": "aggregateflex",
                "useGlobal": true,
                "visualizationParameters": {
                    "options": {},
                    "parameters": {
                        "borderColor": "#e0e5ee",
                        "borderWidth": 1,
                        "cell": {
                            "backgroundColor": "#ffffff",
                            "fontColor": "#16325c",
                            "fontSize": 12
                        },

Note:
"Period" should be the column name you are using to filter the compare table.
Period_1 is step name
value is name given to values that will be used to filter by "Period"

Hope this helps.

Best Regards,
Akshay
madhav Arepallimadhav Arepalli 
I am trying to do a Co-Group on two different datasets and the comon field is OBS and i am trying use the following SAQL query: 

q = load "Upload_File_OBS_v1";
q = group q by ('OBS','Order_ID');
q = foreach q generate q.'OBS' as 'OBS', q.'Order_ID' as 'Order_ID', count(q) as count;
q = order q by ('OBS' asc, 'Order_ID' asc);

q1 = load "Upload_File_Invoice_v2";
q1 = group q1 by ('OBS','Invoice_ID');
q1 = foreach q1 generate 'OBS' as 'OBS','Invoice_ID' as 'Invoice_ID', sum('Invoice_Amount') as 'Invoice_Amount';
q1 = order q1 by ('Invoice_ID' asc, 'OBS' asc);
q1 = limit q1 2000;

q2 = cogroup q by 'OBS', q1 by 'OBS';
q2 = foreach q2 generate q1.'Order_ID' as 'Order_ID', q1.'Invoice_ID' as 'Invoice_ID' , sum(q1.'Invoice_Amount') as 'Invoice_Amount';

Error: 

Unkown IDTOKEN: ORDER_ID


Any help would be appreciated 


Thank you 
Madhav 
Best Answer chosen by madhav Arepalli
Allen CoveyAllen Covey
Your referencing the wrong stream for "ORDER_ID".

Order_ID is in the "q" stream.
Nicholas AbbottNicholas Abbott 
HI there,

Can anyone assist on how i can easily rank by top 30 by value in Einstein?

I can't see any function for this.. :(

thanks in advance :)
Best Answer chosen by Nicholas Abbott
Akshay AhujaAkshay Ahuja
Hello Nicholas,

When you open a dataset as a lens, you can click on the gear icon and add a limit. Please see below:

User-added image

Or you can also enter SAQL mode, and modify the query to limit it to 30 rows.

User-added image

q = load "SpringML_Opportunity";
q = group q by 'Name';
q = foreach q generate 'Name' as 'Name', sum('Amount') as 'sum_Amount';
q = order q by 'sum_Amount' desc;
q = limit q 30;

Hope this helps.

Best Regards,
Akshay Ahuja