SOLVED

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

Go to solution
Huguette_Barrie
Level 1

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

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


Number of leads example.jpgFor 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? 

1 ACCEPTED SOLUTION

Accepted Solutions
Darshil_Shah1
Level 10 - Community Advisor + Adobe Champion

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

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.

View solution in original post

3 REPLIES 3
Darshil_Shah1
Level 10 - Community Advisor + Adobe Champion

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

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
Level 1

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

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
Level 10 - Community Advisor + Adobe Champion

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

Great and you're very welcome! 🙂