Forcing RCE to display rows or columns where all cells contain zeroes

[Huguette_Barrie]

Is there any way to force Revenue Cycle Explorer to display all values in a field, even when all cells contain 0's?

For example, in this report showing new leads collected in a week, one person (from North America) came in as "Forward to Friend" and one came from "Online Advertising."

Next week, however, if no one comes from "Forward to Friend," RCE will not show that line in the report at all, so "Online Advertising" will be the second line in that report instead of the third. These shifting lines complicate work our analytics team does with these reports.

Does anyone have a workaround to force all values to appear in the report every time, regardless of the cell contents? 

[Darshil_Shah1 · Accepted solution]

Interesting! I don't see an option in the RCE to include rows for values that have 0 leads (measure attribute) in them natively. You could load test leads to ensure that there's at least one person for each lead source value. However, if you're exporting this data in the CSV format, then it's relatively simple to adjust the rows/check and insert missing rows as a pre-processing step before injecting data to your analytics platform to ensure that rows are always in the same order. Almost all programming languages have extensive libraries for you to manipulate CSV data.

[Huguette_Barrie]

Thanks for the suggestion, Darshil! I've exported a few reports to CSV to share with the team so they can test with them.

[Darshil_Shah1]

Great and you're very welcome! 🙂