Questions tagged [matrix]
The matrix tag has no usage guidance.
18
questions
0
votes
0
answers
27
views
How do I make a cross tab report where the intersection is a text field value?
I am using Salesforce to track milestone completion for PhD students. I would like to make a crosstab report that shows the student names down the left, milestone names across the columns, and then ...
- 1
1
vote
1
answer
786
views
Show Me "All Opportunities" randomly filters the data by Role
I am experiencing some major frustration with a matrix report. I have a report that shows opportunities grouped by Closed date and then by a Custom grouping value
I would like the report show include ...
- 158
0
votes
0
answers
60
views
Range Calculation Matrix Not working
I have created a matrix based on the documentation link2
adding a screen shot here but it doesn't work when i try to call it from integration procedure
Any suggestions on what i am doing wrong ?
0
votes
1
answer
531
views
Fill a Vlocity matrix with data using Apex
I have a use case where i want to create and fill a matrix version from Apex.
This matrix is a versioned matrix like: https://docs.vlocity.com/en/Ways-to-Create-a-Standard-Calculation-Matrix.html
Is ...
- 431
0
votes
0
answers
2k
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 ...
- 1,945
0
votes
1
answer
213
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 ...
user48169
3
votes
1
answer
2k
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
1
answer
56
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
1
answer
67
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 ...
0
votes
1
answer
2k
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.
- 5
1
vote
0
answers
75
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
2
answers
1k
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
- 607
1
vote
0
answers
124
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 ...
- 2,346
1
vote
1
answer
234
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 ...
- 504
6
votes
1
answer
1k
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....
- 1,623
4
votes
3
answers
431
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
2
answers
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
2
answers
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 ...
- 3,782