Are there alternative ways to format display when there are "no results"?

Question

I'm wanting to see if there is an elegant way to display elements where there are no results in the context of other data.  For example, I've got a Projects dashboard I built with several performance tiles, and when I apply a filter that returns no values, instead of the value reading 0 it looks like this:

The ideal would be to set the performance tile, Committed, with a result of 0.

Rich Merkel · Answer

Hi - one other method, if you want to display zero as the result, even if there are no open commitments.

Create complex query, and in formula set that value to zero.  In second use the measure

use formula for total committed cost in 1st analysis

IFNULL("- Commitment Cost Measures"."Total Committed Cost",0)

in 2nd query, use 0 as the formula

that should always produce a zero as the result if no open commitments exist.

I'm attaching the xml (You can copy/paste into advanced secion/xml/apply xml)

Note i've added a filter on both analysis to to prompt for project status, looking at original screenshot.

Hope this helps, you can do same for budget/actual in case no budget/actual exists on project using same method.

analysisxml.txt

Rich Merkel · Answer

Hi,

For analysis, click on the xyz (can do from criteria tab).  In window below select display custom message and enter message as necessary.

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/26768/are-there-alternative-ways-to-format-display-when-there-are-no-results

Hi @RyanPE,

Is your analysis (used for the tiles) having only Measures?

Use IFNULL function to convert the null to 0. here's an example:

IFNULL("Worker Assignment"."Head Count",0)

Need to make sure the analysis only hold the measure, if there's any attribute / dimension columns present, it might not work. Here's an example.

I did a report with Tiles and misspelt the name but it is still bringing the 0 as output.

The moment I add another dimension entry in the same report, it does not work.

Hope this help.

Thank you.