Ask Search:
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.
早紀 中神早紀 中神 
Hello.
I have a question about Einstein Discovery.

When I tried to play summary after creating story, there was the error occured :
"There was an error processing your request."

Do somebody know what it implied?

Since the system has not localized yet in Japan, there are less information. 
So I would be appriciate if you could answer.
Best Answer chosen by 早紀 中神
EdEd (salesforce.com) 
Hi,

In case you don't receive a response here, may I also suggest joining the Einstein Analytics group below to collaborate with the experts for best practice and advice.
https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F9300000009MBP

Thanks!
Xin ZhangXin Zhang 
Is it an expected behavior that we cannot choose and save an initial seletion when using "Global Filter"? I am able to save initial selection when using "List".
Best Answer chosen by Xin Zhang
Akshay AhujaAkshay Ahuja
Hello Xin,

So that's the difference with Global filters. You don't need to use Pick Initial selection option.
When you go to Edit mode, directly go to the required global filter and set the value (without going to pick initial selection option). Once you select a value, the dashboard will modify based on selection and then you save the dashboard.

You would set an inital value to a regular list filter using "Pick Initial Value". But that doesn't work for Gloabl filters.
Let me know if you have any questions.

Best Regards,
Akshay
Jeff MusgraveJeff Musgrave 
Hi All,
 
when I include absolute date ranges for the pipeline trending chart, I get the following error:  "Relative query string must have either 2 or 3 fields".  Anyone run into this before?  Any idea how to fix it?
 
thanks!
Best Answer chosen by Jeff Musgrave
Akshay AhujaAkshay Ahuja

Hello Jeff,

The value of the Date Range filter is being passed on to multiple steps as a selection binding which in turn is use to calculate dates like Start Valid From, Start Valid To, End Valid From, End Valid To, etc.

When you use Absolute Dates, the selection is not passed on in the correct format because of which you see the error. To fix the same, you would have to change the entire logic on the dashboard (not advisable).

Instead you could try using the Relative Date Filter option for Day/Week and set the required Absolute date.
For example:

Relative Dates

Best Regrads,
Akshay

Jeff MusgraveJeff Musgrave 
I know there is a sales stage analysis dashboard that comes with wave but I would still like to to be able to add some fields from opportunity history into wave.  I tried adding by using sfdcDigest but the fields I am looking for, such as duration, do not show up under opportunity history.
 
Does anyone know how to add opportunity history fields to an existing dataflow?
Best Answer chosen by Jeff Musgrave
Akshay AhujaAkshay Ahuja
Hello Jeff,

The "Duration" field is created from a compute Expression in the dataflow.
If you have Sales App dashboards enabled, you can refer to it's dataflow to find the compute Expression which creates the field Duration. The basic algorithm for it is:
  • Sort Opportunity History by ID & Created Date
  • Create 2 Date Fields using a Compute Relative node:
    • "Valid From" which is current() of Created Date
    • "Valid To" which is next() of Current Date
  • Create "Duration" uisng a Compute Expression node as date difference between Valid From and Valid To (if both are populated), or Valid From and now (if Valid To is null or set to a default value)
Hope this answers your question.

Best Regards,
Akshay

 
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)
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
Valeria ParraValeria Parra 
Hi there!
I'm new in Salesforce, just got my licence today and I'm trying to import my custumer's data from Excel to Salesforce, I followed every step but I got stuck because I can not find "Einstein Analytics Connector for Excel" at Microsoft Store, I just found "Salesforce Wave connector for excel"... What should I do? Is it the same?
Best Answer chosen by Valeria Parra
Akshay AhujaAkshay Ahuja
Hello Valeria,

Yes. That is the same one. It's called Salesforce Wave Connector for Excel. (Wave being the previous name of the product)

You can use this link: https://appsource.microsoft.com/en-us/product/office/WA104379394?tab=Overview

Also, I got the following message when I was using it on a Mac.

Excel Connector

But on Windows, it should work fine.

Best Regards,
Akshay
Best Answer chosen by sreelaxmireddy daggula
Mayank shahMayank shah
This will help you to understand in a better way.Salesforce Einstein is a platform to enable Artifical intelligence capabilities:
https://www.salesforce.com/products/einstein/overview/