Hi peeps, I need to create a report that shows a % of how many opportunities moved from stage to stage 

This was created in excel and would like to create it in salesforce. Basically the way it was calculated was using a simple =SUMIFS(oppys amount,sales qualified stage,"x")/SUMIFS(oppys amount,unqualified stage,"x") formula.

Please help me understand if this is possible to re-create in salesforce or not. My VP of sales is counting on me. 

I'm stuck on step #2 of Einstein Analytics and Discovery Insights Specialist superbadge.  I'm getting this warning while checking the challenge:

The step "Churn Tenure' is in compact form, so the filter values need to be specifed as a minimum and maximum
The static step that feeds has the following the value:
 

"Tenure_Length": {
                "broadcastFacet": false,
                "label": "Tenure Length",
                "selectMode": "single",
                "type": "staticflex",
                "values": [
                    {
                        "display": "High Risk",
                        "value": "1 to 12 months",
                        "min": 1,
                        "max": 12
                    },
                    ...
                ]
            }

I'm using selection binding for min and max values.  The dashboard is correctly filtering:


Any ideas? 
I've tried a non-compact form step where I inject a saql fragment into the query, as well as where I inject min/max values using a range filter serialization...All these efforts end in the same challenge failure message.

Any help/suggesitions are welcome!

Hi peeps, I need to create a report that shows a % of how many opportunities moved from stage to stage 

This was created in excel and would like to create it in salesforce. Basically the way it was calculated was using a simple =SUMIFS(oppys amount,sales qualified stage,"x")/SUMIFS(oppys amount,unqualified stage,"x") formula.

Please help me understand if this is possible to re-create in salesforce or not. My VP of sales is counting on me. 

I have built the reports and dashboards as outlined in the requirements, but I'm getting the following error "Challenge Not yet complete... here's what's wrong: Couldn't find a component with the title 'My Top Accounts'."  


However, I have the component on the dashboard as you can see below.

What am I missing?

HI

 

Salesforce Community

I am new to Apex & trigger

I have created two custom objects Member & Member2, and same fields for both the object, now i want to insert the values of member fields into Member2 fields, such as Firstname and lastname,

Help me to get code for this