Ask Search:
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
Marek SmerakMarek Smerak 
Data storage limints in Analytics cloud are set as number of data rows used. Also "Analytics license data storage limits are contractual, not technical. Licensee agrees to strictly monitor its total number of data rows". Does anyone know how to check how many rows are we currently using?
Best Answer chosen by Marek Smerak
Naveen DhanarajNaveen Dhanaraj
Hi Marek,
Is this what you want,This was suggested by peter,


User-added image

If not check with Experts Here,
https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F9300000009MBP&fId=0D53A00003Two2v&s1oid=00D300000000iTz&s1nid=0DB30000000072L&emkind=chatterCommentNotification&s1uid=0053000000CV5Vn&emtm=1521631332117&fromEmail=1&s1ext=0 (https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F9300000009MBP)
Katie MurphyKatie Murphy 
Hi - i am trying to leverage the Stage Duration field to analyze the time that opportunties stay in each stage. This field is available in Reports. However, it cannot be accessed via the Dataflow Builder. Anyone have any experience with this issue? Thanks
Best Answer chosen by Katie Murphy
Akshay AhujaAkshay Ahuja
Hello Katie,

To see Stage Duration in Einstein Analytics, you would have to extract Opportunity Field History object. Next you can use a Compute Expression in the dataflow or use a Compare table on the dashboard to calculate the number of days an Opportunity remained in a particular Stage.

"Extract_OpportunityFieldHistory": {
    "action": "sfdcDigest",
    "parameters": {
      "fields": [
        {
          "name": "CreatedById"
        },
        {
          "name": "CreatedDate"
        },
        {
          "name": "Field"
        },
        {
          "name": "Id"
        },
        {
          "name": "NewValue"
        },
        {
          "name": "OldValue"
        },
        {
          "name": "OpportunityId"
        }
      ],
      "object": "OpportunityFieldHistory"
    }
  },

The expression would basically group and sort by Opportunity Id and Created Date and then calculate the daysBetween two consecutive rows.

Best Regards,
Akshay
Douglas GreylingDouglas Greyling 
We've recently updated the stages on our Opportunity object. I'd like to be able to select some of the new stages we've implemented within a lens in Analytics. However when I select the opportunity stage, only the old stages appear and none of the newer ones are available.

How do I get these new fields to appear within the datasets I've created?
Best Answer chosen by Douglas Greyling
Akshay AhujaAkshay Ahuja
Hello Douglas,

You would need to run the dataflow that has created the datasets in Einstein Analytics. This would fetch the new Stage names from Salesforce CRM.

Also, the new stages will appear only if there are any opportunities in those stages.

To run the dataflow:

1. Verify the dataflow name that is used to create the Opportunity dataset. Click on Edit next to a dataset. 
Example: SpringML_Opportunity dataset is created using Default Salesforce Dataflow.

Run Dataflow 1

2. Go to Data Manager and Run the dataflow.

Run Dataflow 2

3. Once the dataflow completes successfully, the refreshed dataset should have the new Stage pick list values.

Best Regards,
Akshay