Questions tagged [matrix]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
38 views

Parentgroupval formula for bucked values in a matrix report

I have a matrix report using parentgroupval in a percent field and bucketed values as rows. The formula is as follows: This is incorrect. What I need is to show for each status, the % of that ...
0
votes
0answers
504 views

Matrix report formula on row sub grand total

I have build the following matrix report, which is grouped in columns by a bucket field of my stages and by current and previous month for the closed date. This report is also grouped in rows by a ...
0
votes
1answer
59 views

Matrix Report - formula

I'm trying to add a formula to the matrix report in order to count the number of products in an opportunity. Its not working. I'm getting the following error: "Error: Invalid custom summary formula ...
3
votes
1answer
463 views

Declare Matrix-like variable in apex with NXN dimensions

I'm creating a class where I have come to the conclusion that the most efficient method to proceed is with an array variable that works as a matrix. I'm not sure how many columns or rows I will need ...
0
votes
1answer
20 views

Account List by Rep Matrix Report

How can I create a report in SFDC where I can see the target accounts assigned by reps at a glance (in a matrix format), like this:
0
votes
1answer
41 views

Formula for assigning a value to all working days between 2 dates

I am logging Sickness in salesforce and have a start and end date. For reporting purposes i need to be able to assign a 1 to each of the working days between these 2 dates. Then when i report i can ...
1
vote
1answer
470 views

Matrix table on Visual Force page , struck with Apex:Repeat

I am trying to create a Matrix table something like below I have a problem in looping the apex repeat. I have a MAP defined like MAP<Priority,MAP<Status,integer>> , I am unable to iterate ...
0
votes
1answer
962 views

How to remove Grand Total columns from Matrix Report in salesforce?

I have a Matrix Report and i want to remove the Grand Total Column and row in the table.Below is the Image of the report.
1
vote
0answers
54 views

Display Matrix Report with two level grouping on a Visual Force Page [closed]

I want to display matrix report having two level row grouping and two level column grouping on a visualforce page using Reports Analytics API. I have fetched the report metadata. Want to display the ...
1
vote
2answers
594 views

How to display zero values in matrix report for grand total

I have a matrix report where salesforce is ignoring the grand total for 0 values. How can I display the 0 values in grand total.Currently the report is grouped by created date. Please help!]1
1
vote
0answers
93 views

Matrix report sorting logic

I have a matrix report with some grouping fields, and some other fields. I can set the 'order by' on grouping fields, but I cannot do this on the other non-grouping columns. I'm wondering if there is ...
1
vote
1answer
158 views

Daily matrix report without data

Is it possible to create a matrix report without having records for one of the columns? For example: I have a matrix report with columns grouped daily for a custom date field; I have records for day ...
6
votes
1answer
923 views

How to decode fact map for matrix report using Analytics API?

Trying to pull out a List of IDs from a matrix type report. I think I understand Tabular and Summary type reports but I am lost on Matrix type. Here is my code: private List<Reports....
4
votes
3answers
312 views

How to construct mileage expense formula without hard coding the mileage rate into the expense field

I have created a "mileage expense" formula field which calculated the "miles" field by the mileage reimbursement rate - $.56 - hard coded into the formula. Mileage reimbursement rates change at least ...
3
votes
2answers
4k views

Create a Matrix Table in Visualforce

I was wondering how I can create a matrix table showing the months across the top (x-axis) and the product name on the y-axis with the sum of the quantity (sum of the products purchased for each month)...
1
vote
2answers
1k views

Question about Matrix report - How to group by two dates(date range)

Hi I am not well versed with SF reports and wanted some help with a matrix report that I am trying to put together. Lets say I have a custom object to store records that have a start date and end ...