As you have discovered, Salesforce is weak at reporting on missing data.
You might try creating an opportunity with one zero value revenue item in each of the missing months. I suspect that such an opportunity might distort other opportunity reports. It can, of course, be filtered out, but users will need to be instructed to do this.
In order to report on ...
I managed to solve this for now, but it's far from perfect.
Basically, after I pulled the dashboard metadata from source org, I opened it and found the <componentType>Table</componentType> tag, and right under it I added this:
I was very happy to see, that in Spring 18 this issue seems to be resolved by Salesforce. There was no need to change anything on my end - it just works now on any Orgs I've checked so far - and looks awesome!
Thanks Salesforce for fixing this!
I think Report Chart type Component can fulfil your requirement. If you have created a report having a chart and stored in a shared folder can we used on the Lightning record pages, also, It will respect all the filters and grouping you have applied. Additionally, You can filter your report based on the current record.
The report chart will appear on your ...
EDIT: Note that this answer is only valid for non-lightning dashboards. The question turned out to be on a Lightning Experience dashboard. Nevertheless I'm leaving the answer here so it might help other people.
In the dashboard Component Editor (click on the little wrench on the top-right of the dashboard component), in the Formatting tab, you can set '...
It would appear this isn't possible using <analytics:reportChart>. However, depending on your goal here you may be able to achieve the same results through different means.
I set up a test report with a basic OR filter, when I do the describe for the report (/services/data/v37.0/analytics/reports/<reportId>) the filters and filter logic are ...
A resource is a type of invitee. A standard report exists to show events and invitees: Under Activity Reports select the Events with Invitees.
Now if you customize this report, you can add a field filter, and filter on the invitee type to show 'resources'.
You have to have created resource calendars of course to see them.
You can create a field Formula field where you can check whether it is an Current month Case, Last Month and All Cases.
Create a report with Case report type.
* Choose Matrix report type
* Drag and drop the fields you require in report.
* Drag newly created Formula field into Column.
* Create bar Chart and choose X axis as the formula field.
I hope this ...
The purple slice ("Other") represents values under a certain threshold (< 4%). There's an Idea to allow us to customize the threshold for those that would like more control. There currently is no fix without writing Visualforce code and including it as a custom component on your dashboard.
You need to create a permission set with only the 'Create and Customise Reports', 'Edit Reports', 'Run Reports' and 'Report Builder' permissions for the Community users as they have the Customer Community Plus licence.
The users will also need to be granted access to the folders that the relevant reports and dashboards are held in.
From the documentation
In the report, double-click on "Add Bucket Field", add two buckets (Dead and Alive), add the Dead status to the Dead bucket, and the remaining values to the Live bucket. After changing to a Summary or Matrix report, you can then group by this bucket. You can read more in the Using Bucket Fields (PDF) cheat sheet.
Report chart component allows filtering by the Id of the record page you are adding the chart to. If it is Case page, the report can only be filtered by Case Id, and that too provided the report type includes Case.
You can create a visualforce page with analytics:reportChart tag where you can add a filter. In the example below I am filtering by contact id ...
If you use the dynamic data selectors as described in below documentation link, the report and dashboard dates will move along with the actual dates.
Judging from your description you are fine. In order to be 100% sure, you'd need to include a screenshot (or wait until next week ;-) )
As far as I know it can't be done with SOQL.
You probably could try with Analytics API but it has some limitations.
The "old school" way would be to download all report types and report definitions to Eclipse IDE (or with any other tool of your choice). If you'd have > 5,000 reports the retrieval would have to be split into chunks - for example fetch few ...
Create a custom formula field on the opportunity object with the calculation of startdate__c - closedate. Then you can create a report based off this field to determine which opportunities have a start date that is less than the closed date.
I got this error today when I was uploading data via a CSV file. In our case, the CSV file had become corrupted. I had to open the original in Excel, perform a "save as" and then use the re-saved document for the upload. It worked in our case. Good luck to you....
If you use visualforce you cannot have breakpoints like in a standard gauge chart component. You can only set the min and the max via the vf page. When you set the max Salesforce automatically sets 10 evenly spaced out points that divides the max and the min. Then your needle or the data attribute is what fills the gauge to your amount.
So it looks ...
You can't use that component on a public site page because the guest user cannot have the Run Reports permission. You will have to create the chart on your own. Use something like the google charts or D3 libraries to help
I found a partial workaround to use require.js in my use case:
The reason behind the issue is not the entire require.js library, but specifically the define API. Aura (or something related to it) seems not to allow a global define like provided by require.js.
So if one (like me) is using require.js purely to load other JS synchronously (instead of simply ...