• John Angerami 16
  • NEWBIE
  • 20 Points
  • Member since 2016

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 9
    Questions
  • 2
    Replies
I am trying to create a Wave Dashboard that automatically is filtered based on the current user.

I have the following code as my 'start':
[
                    "OwnerId.Name",
                    [
                        "{{row(UserId.Name.selection, [0], [\"min\", \"max\"]).asObject()}}"
                    ],
                    ">=<="
                ],

But it doesn't seem to be working.
Any help would be grealty appreciated
Hey!
I am relatively new to Wave Analytics and I am trying to create a Dashboard for 'Industry' so that we are able to show Leads that have come in and what Industries they belong to.

I have created a list filter of all Industries but I can't get it to affect my comparative table.

I am trying to have a widget that is just a percent that will show of all the leads, how many belong to the Industry that we are filtering by.

Any assistance would be greatly appreciated.

Thanks!
I just recently acquired wave and have refreshed my Partial Copy Sandbox.

None of my datasets have come over and their is no data job.

I tried creating a new dataset in the sandbox and received this error:

Resource not found: /insights/internal_api/v1.0/esObject/workflow//json

How can I create a dataset for my sandbox?
I am trying to calculate Monthly Recurring Revenue based on an Opportunity.
MRR is its own Object that is connected to an Opportunity.
On the Opportunity I have three fields I think I need (Start Date, End Date, Term (in Months) ).
Goal is to have an MRR record created for each month from the Start to End Date.
So if the Start Date is 1/1/2016 and the End Date is 4/30/2016, I want four MRR records to be created:
January 2016, February 2016, March 2016, April 2016.

I think I can use a Visual Flow to accomplish this but need a few pointers
I am trying to create a Customizable Forecasting report and have the graph appear on a visualforce page.
There is a link on the top that says 'Run as Me' or 'Run as Role' which I need it to automatically be set as 'Me' for the user viewing the visualforce page.

My VF code is just pulling in the chart:
<analytics:reportChart reportId="00O20000007SNcO" size="medium"></analytics:reportChart> 

However, each user is seeing the chart as me, not as themselves.
How can I change this?
I have created a Customizable Forecasting: Forecast Summary Report and graph but it is run as me on the visualforce page.
There is a button on the top that says 'Run as Me' which I need to automatically be clicked when a user is using the visualforce page.

I think I need to adapt the following into my VF code:
Javascript:document.reportuid.value=”;document.report.rid.value=”;document.report.drill.value’user’;document.report.submit();

My VF code is just puling the chart:
            <analytics:reportChart reportId="00O20000007SNcO" size="medium"></analytics:reportChart> 
I was able to find code for a Guage report that I can put on a VisualForce Page but it is capturing Full Year and I need it to capture just Quarter.
Any suggestions?
Thanks!
 
public class GaugeChartController {
    public String userId {get;set;}
    
    public GaugeChartController(ApexPages.StandardController controller){
        userId=userinfo.getuserid(); 
    }
    
    public List<gaugeData> getData() {
          Integer TotalOpptys = 0;
          Integer TotalAmount = 0;
          Integer thisMonth = date.Today().month();

          AggregateResult ClosedWonOpptys = [select SUM(Amount) totalRevenue, CALENDAR_MONTH(CloseDate) theMonth, COUNT(Name) numOpps
                                   from Opportunity
                                   where OwnerId =: userID
                                   and StageName = 'Closed Won' 
                                   and CALENDAR_MONTH(CloseDate) =: thisMonth 
                                   GROUP BY CALENDAR_MONTH(CloseDate) LIMIT 1];
          
          List<gaugeData> data = new List<gaugeData>();
          data.add(new gaugeData(Integer.valueOf(ClosedWonOpptys.get('numOpps')) + ' Opptys', Integer.valueOf(ClosedWonOpptys.get('totalRevenue'))));
          return data;
     }

    public class gaugeData {
        public String name { get; set; }
        public Integer size { get; set; }

        public gaugeData(String name, Integer data) {
            this.name = name;
            this.size = data;
        }
    }



 
Hey!
I am trying to create a VP Dashboard that will have a Dropdown for Time Frame and update the reports for Qtr and Year based on button pressed.
(I decided just to have each button call a different report).
Here is what I have so far but can't seem to figure out how to have the OnClick.
I would want the first form to appear when the Rep presses 'Qtr' and the second form when the Rep presses 'Year'

 
<apex:page standardController="Opportunity" extensions="GaugeChartController">

<body>

<div class="dropdown">
<button onclick="myFunction()" class="dropbtn">Time Frame</button>
  <div id="myDropdown" class="dropdown-content">
    <a href="#quarter">Quarter</a>
    <a href="#Year">Year</a>

  </div>
</div>

<script>

function myFunction() {
    document.getElementById("myDropdown").classList.toggle("show");
}

window.onclick = function(event) {
  if (!event.target.matches('.dropbtn')) {

    var dropdowns = document.getElementsByClassName("dropdown-content");
    var i;
    for (i = 0; i < dropdowns.length; i++) {
      var openDropdown = dropdowns[i];
      if (openDropdown.classList.contains('show')) {
        openDropdown.classList.remove('show');
      }
    }
  }
}
</script>
</body>

<apex:form >
<apex:pageBlock >
    <script>
            myChart.on('beforeconfig', function(config) {
            config.axes[0].margin=-20; 
        });
    </script>
    <apex:pageBlockSection title="My Won Opportunities" columns="2" collapsible="true">
    <apex:chart name="Sales v Goal" height="300" width="400" animate="true" data="{!data}">
        <apex:axis type="Gauge" position="gauge" title="Closed Won Opportunities -Amount"  minimum="0" maximum="30000" steps="5"/>
        <apex:gaugeSeries dataField="size" donut="40" colorSet="#78c953,#ddd"/>
    </apex:chart>
        <apex:chart name="ARR v Goal" height="300" width="400" animate="true" data="{!data}">
        <apex:axis type="Gauge" position="gauge" title="Closed Won Opportunities - ARR"  minimum="0" maximum="25000" steps="5"/>
        <apex:gaugeSeries dataField="size" donut="40" colorSet="#78c953,#ddd"/>
    </apex:chart>
    </apex:pageBlockSection>
</apex:pageBlock>
</apex:form>

<apex:form >
      <apex:pageBlock title="My Opportunities"> 
           <apex:pageBlockSection title="My Open Opportunities" columns="2" collapsible="false">              
            <analytics:reportChart reportId="00O26000000PeMT" size="medium"></analytics:reportChart>
            <analytics:reportChart reportId="00O26000000PeMY" size="medium"></analytics:reportChart>
              </apex:pageBlockSection> 
         </apex:pageBlock> 
</apex:form>

 
I am trying to create an Apex Class/Process Flow that posts on Slack when an Opportunity is closed won.

The amount is not populating correctly and is coming as '10000' opposed to $10,000'.
 
public class Oppty {
        @InvocableVariable(label='Opportunity Name')
        public String opptyName;
        @InvocableVariable(label='Stage')
        public String stage;
        @InvocableVariable(label='Opportunity First Name')
        public String opptyFirstName;
        @InvocableVariable(label='Opportunity Last Name')
        public String opptyLastName;
        @InvocableVariable(label='Opportunity Amount')
        public Decimal opptyAmount;  
    }

 
I was able to find code for a Guage report that I can put on a VisualForce Page but it is capturing Full Year and I need it to capture just Quarter.
Any suggestions?
Thanks!
 
public class GaugeChartController {
    public String userId {get;set;}
    
    public GaugeChartController(ApexPages.StandardController controller){
        userId=userinfo.getuserid(); 
    }
    
    public List<gaugeData> getData() {
          Integer TotalOpptys = 0;
          Integer TotalAmount = 0;
          Integer thisMonth = date.Today().month();

          AggregateResult ClosedWonOpptys = [select SUM(Amount) totalRevenue, CALENDAR_MONTH(CloseDate) theMonth, COUNT(Name) numOpps
                                   from Opportunity
                                   where OwnerId =: userID
                                   and StageName = 'Closed Won' 
                                   and CALENDAR_MONTH(CloseDate) =: thisMonth 
                                   GROUP BY CALENDAR_MONTH(CloseDate) LIMIT 1];
          
          List<gaugeData> data = new List<gaugeData>();
          data.add(new gaugeData(Integer.valueOf(ClosedWonOpptys.get('numOpps')) + ' Opptys', Integer.valueOf(ClosedWonOpptys.get('totalRevenue'))));
          return data;
     }

    public class gaugeData {
        public String name { get; set; }
        public Integer size { get; set; }

        public gaugeData(String name, Integer data) {
            this.name = name;
            this.size = data;
        }
    }