• Ravi Mehta
  • NEWBIE
  • 10 Points
  • Member since 2018

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 6
    Questions
  • 3
    Replies
I have a static toggle created on Wave Dashboard. Based on its selection I need to change the Group By column of a Compare Table. Though the data is being aggregated correctly, while changing the toggle selection the Summary Column gets disappear.

Below is the Static Toggle JSON:
"Filter_Type_1": {
                "broadcastFacet": true,
                "groups": [],
                "label": "Filter Type",
                "numbers": [],
                "selectMode": "singlerequired",
                "start": {
                    "display": [
                        "BC"
                    ]
                },
                "strings": [],
                "type": "staticflex",
                "values": [
                    {
                        "display": "BC",
                        "group": [
                            "TBLABCD.NO_ZNE"
                        ]
                    },
                    {
                        "display": "Sales",
                        "group": [
                            "TBLABCD.CD_SLS"
                        ]
                    },
                    {
                        "display": "Service",
                        "group": [
                            "TBLABCD.CD_SRVC"
                        ]
                    }
                ]
            },

Below is JSON of Compare Table:
"TBLABCD_N_ZONE_1": {
                "broadcastFacet": true,
                "datasets": [
                    {
                        "id": "0Fbq0000000E4iACAS",
                        "label": "ABC_Utilization",
                        "name": "ABC_Recipe",
                        "url": "/services/data/v42.0/wave/datasets/0Fbq0000000E4iACAS"
                    }
                ],
                "isGlobal": false,
                "label": "Summary Table",
                "query": {
                    "measures": [
                        [
                            "unique",
                            "CD_DLR",
                            "A"
                        ],
                        [
                            "unique",
                            "CD_DLR",
                            "B"
                        ],
                        [
                            "unique",
                            "CD_DLR",
                            "C"
                        ],
                        [
                            "unique",
                            "IJ_LAST_8",
                            "D"
                        ],
                        [
                            "sum",
                            "QR_CLM_COUNT",
                            "E"
                        ],
                        [
                            "sum",
                            "QR_CLM_COUNT",
                            "F"
                        ],
                        [
                            "sum",
                            "QR_CLM_COUNT",
                            "G"
                        ],
                        [
                            "sum",
                            "AB_CLM",
                            "H"
                        ],
                        [
                            "sum",
                            "AB_CLM",
                            "I"
                        ],
                        [
                            "unique",
                            "IJ_LAST_8",
                            "J"
                        ],
                        [
                            "unique",
                            "IJ_LAST_8",
                            "K"
                        ],
                        [
                            "sum",
                            "QR_RNTL_DAYS",
                            "L"
                        ],
                        [
                            "sum",
                            "QR_RNTL_DAYS",
                            "M"
                        ],
                        [
                            "sum",
                            "QR_OPRTNTY_DAYS",
                            "N"
                        ],
                        [
                            "sum",
                            "QR_OPRTNTY_DAYS",
                            "O"
                        ]
                    ],
                    "columns": [
                        {
                            "query": {
                                "measures": [
                                    [
                                        "unique",
                                        "CD_DLR"
                                    ]
                                ],
                                "groups": "{{cell(Filter_Type_1.selection, 0, \"group\").asObject()}}"
                            },
                            "header": "Dealer Count"
                        },
                        {
                            "query": {
                                "measures": [
                                    [
                                        "unique",
                                        "CD_DLR"
                                    ]
                                ],
                                "groups": "{{cell(Filter_Type_1.selection, 0, \"group\").asObject()}}",
                                "filters": [
                                    [
                                        "CD_VIN_TYP",
                                        [
                                            "C"
                                        ],
                                        "in"
                                    ]
                                ]
                            },
                            "header": "ABC Dealer Count"
                        },
                        {
                            "query": {
                                "measures": [
                                    [
                                        "unique",
                                        "CD_DLR"
                                    ]
                                ],
                                "groups": "{{cell(Filter_Type_1.selection, 0, \"group\").asObject()}}",
                                "formula": "B/A"
                            },
                            "format": "percentage",
                            "header": "% ABC Dealers"
                        },
                        {
                            "query": {
                                "measures": [
                                    [
                                        "unique",
                                        "IJ_LAST_8"
                                    ]
                                ],
                                "groups": "{{cell(Filter_Type_1.selection, 0, \"group\").asObject()}}",
                                "filters": [
                                    [
                                        "CD_VIN_TYP",
                                        [
                                            "C"
                                        ],
                                        "in"
                                    ]
                                ]
                            },
                            "header": "ABC Unit Count"
                        },
                        {
                            "query": {
                                "measures": [
                                    [
                                        "sum",
                                        "QR_CLM_COUNT"
                                    ]
                                ],
                                "groups": "{{cell(Filter_Type_1.selection, 0, \"group\").asObject()}}"
                            },
                            "header": "# of Loaner/Rental Paid Claims"
                        },
                        {
                            "query": {
                                "measures": [
                                    [
                                        "sum",
                                        "QR_CLM_COUNT"
                                    ]
                                ],
                                "groups": "{{cell(Filter_Type_1.selection, 0, \"group\").asObject()}}",
                                "filters": [
                                    [
                                        "CD_VIN_TYP",
                                        [
                                            "C"
                                        ],
                                        "in"
                                    ]
                                ]
                            },
                            "header": "ABC Paid Claims"
                        },
                        {
                            "query": {
                                "measures": [
                                    [
                                        "sum",
                                        "QR_CLM_COUNT"
                                    ]
                                ],
                                "groups": "{{cell(Filter_Type_1.selection, 0, \"group\").asObject()}}",
                                "formula": "F/E"
                            },
                            "format": "percentage",
                            "header": "% of ABC Claims"
                        },
                        {
                            "query": {
                                "measures": [
                                    [
                                        "sum",
                                        "AB_CLM"
                                    ]
                                ],
                                "groups": "{{cell(Filter_Type_1.selection, 0, \"group\").asObject()}}"
                            },
                            "header": "Loaner/Rental Claim Cost"
                        },
                        {
                            "query": {
                                "measures": [
                                    [
                                        "sum",
                                        "AB_CLM"
                                    ]
                                ],
                                "groups": "{{cell(Filter_Type_1.selection, 0, \"group\").asObject()}}",
                                "filters": [
                                    [
                                        "CD_VIN_TYP",
                                        [
                                            "C"
                                        ],
                                        "in"
                                    ]
                                ]
                            },
                            "header": "ABC Claim Cost"
                        },
                        {
                            "query": {
                                "measures": [
                                    [
                                        "unique",
                                        "IJ_LAST_8"
                                    ]
                                ],
                                "groups": "{{cell(Filter_Type_1.selection, 0, \"group\").asObject()}}",
                                "filters": [
                                    [
                                        "QR_CLM_COUNT",
                                        [
                                            [
                                                0
                                            ]
                                        ],
                                        "=="
                                    ]
                                ]
                            },
                            "header": "# of ABC Units with NO Claims"
                        },
                        {
                            "query": {
                                "measures": [
                                    [
                                        "unique",
                                        "IJ_LAST_8"
                                    ]
                                ],
                                "groups": "{{cell(Filter_Type_1.selection, 0, \"group\").asObject()}}",
                                "formula": "J/D"
                            },
                            "format": "percentage",
                            "header": "% of ABC Units Not Used"
                        },
                        {
                            "query": {
                                "measures": [
                                    [
                                        "sum",
                                        "QR_RNTL_DAYS"
                                    ]
                                ],
                                "groups": "{{cell(Filter_Type_1.selection, 0, \"group\").asObject()}}"
                            },
                            "header": "Total All Claim (Days)"
                        },
                        {
                            "query": {
                                "measures": [
                                    [
                                        "sum",
                                        "QR_RNTL_DAYS"
                                    ]
                                ],
                                "groups": "{{cell(Filter_Type_1.selection, 0, \"group\").asObject()}}",
                                "filters": [
                                    [
                                        "CD_VIN_TYP",
                                        [
                                            "C"
                                        ],
                                        "in"
                                    ]
                                ]
                            },
                            "header": "Total ABC Claims (Days)"
                        },
                        {
                            "query": {
                                "measures": [
                                    [
                                        "sum",
                                        "QR_OPRTNTY_DAYS"
                                    ]
                                ],
                                "groups": "{{cell(Filter_Type_1.selection, 0, \"group\").asObject()}}",
                                "filters": [
                                    [
                                        "CD_VIN_TYP",
                                        [
                                            "C"
                                        ],
                                        "in"
                                    ]
                                ]
                            },
                            "header": "Total ABC Opportunity (Days)"
                        },
                        {
                            "query": {
                                "measures": [
                                    [
                                        "sum",
                                        "QR_OPRTNTY_DAYS"
                                    ]
                                ],
                                "groups": "{{cell(Filter_Type_1.selection, 0, \"group\").asObject()}}",
                                "formula": "M/N"
                            },
                            "format": "percentage",
                            "header": "ABC Utilization (Days)"
                        }
                    ],
                    "groups": "{{cell(Filter_Type_1.selection, 0, \"group\").asObject()}}"
                },
                "receiveFacet": true,
                "selectMode": "single",
                "type": "aggregateflex",
                "useGlobal": true,
                "visualizationParameters": {
                    "options": {
                        "totals": true
                    },
                    "visualizationType": "comparisontable"
                }
            },

Could someone please help me find the root cause for this issue? Let me know in case you need more details.
I am trying to find out how can we merge "First Name", and "Last Name", dimension fields to single dimesion field called "Full Name". Due to huge data I would want to avoid reloading the dataset with merged fields thriough Excel formula.

Please suggest if dimension concatenation can be done in Einstein Analytics.
Hi There,

I need to setup a Quick Action on a custom object, which should ask user for an Amount to be Deposited/Credited, and accordingly Current Balance should get updated. Could you please help me setup such scenario?
Let me know in case you need any additional information for it.
Is it possible to create custom Page Layout which can show Einstein Analytics Dashboard (with Time-based filter at least), and have it applied to an Object, while accessed by specific set of users?
Which all accesses/Licenses would be required in such scenario?
As of now clicking on "Set Limit", opens up a field to enter number, and shows warning saying count greater than 2000 can affect the performance.
User-added image

So just wondering if there is any default value set, if nothing specified explicitely.
 
Module Name: Analytics Dashboard Building Basics
Chapter: Add Key Matrics to Evaluate Your Business Unit
Challenge: Add 3rd Number widget to "Sales Performance" dashboard under app "My Private App", label step with "Lost Opp Amount", and title the widget with "Lost Opportunities".

My concern here is, even after doing everything as asked in the challenge, the "Check challenge" button is showing error as "Challenge Not yet complete... here's what's wrong: 
Could not find a dashboard with the label 'Sales Performance' and the name 'Sales_Performance'. Please follow the requirements and ensure everything is setup correctly". I have posted screenshots below, to refer the same.

Not sure how to clear this challenge now. Kindly suggest.
Sales Dashboard exists in My Private App, as required in challenge

Sales Dashboard has the 3rd widget as required in challenge

Still the Check Challenge fails, saying it is unable to find the Sales Dashboard
Hi There,

I need to setup a Quick Action on a custom object, which should ask user for an Amount to be Deposited/Credited, and accordingly Current Balance should get updated. Could you please help me setup such scenario?
Let me know in case you need any additional information for it.
Is it possible to create custom Page Layout which can show Einstein Analytics Dashboard (with Time-based filter at least), and have it applied to an Object, while accessed by specific set of users?
Which all accesses/Licenses would be required in such scenario?
Module Name: Analytics Dashboard Building Basics
Chapter: Add Key Matrics to Evaluate Your Business Unit
Challenge: Add 3rd Number widget to "Sales Performance" dashboard under app "My Private App", label step with "Lost Opp Amount", and title the widget with "Lost Opportunities".

My concern here is, even after doing everything as asked in the challenge, the "Check challenge" button is showing error as "Challenge Not yet complete... here's what's wrong: 
Could not find a dashboard with the label 'Sales Performance' and the name 'Sales_Performance'. Please follow the requirements and ensure everything is setup correctly". I have posted screenshots below, to refer the same.

Not sure how to clear this challenge now. Kindly suggest.
Sales Dashboard exists in My Private App, as required in challenge

Sales Dashboard has the 3rd widget as required in challenge

Still the Check Challenge fails, saying it is unable to find the Sales Dashboard