I'm programming an HTML SPA which consumes data from Salesforce. I'm a web developer by trade, and this is my first experience working with the Salesforce API. Another company are doing the report development.
Much of the data is in the form of reports, queried through the new analytics REST API. The reports are mostly in either tabular or matrix format.
We've run into an issue where if a vertical or horizontal grouping returns no results, the entire grouping disappears, meaning we can't build a dynamic UI and have it feature meaningful 0 values.
For example in one report we have a row for each month, and four columns of data. If all four values are zero, the entire month is omitted from the report, instead of correctly displaying the zeros. (This example is easy to fix, because the months in a year don't change; other examples have categories which we can't as easily hard-code).
I am assured by the SF developers that this is just how it works, and absolutely cannot be remedied. I don't have any reason to doubt them but wanted to check before implementing a lot of brittle code in the UI to handle the issue.
Does anyone know of a way to get the Analytics API reports to return rows/columns (groupings) of zero values?
(Cross posted from Stackoverflow, in the hope of getting an answer).