How to show 0 for NULL aggregation

[uditchandna]

For Chart Widgets in SAP Analytics cloud, if there are no rows to aggregate they show "-" . But what we want is to show 0 here

For Table widgets, it show null rows, how do we get to show 0 here as well

Any suggestion

eg:- Let's say I am looking at count of all Sales guys in UK region and let's say there are none, aggregation should show 0 , but it shows "-"

How do we show 0 in SAC widget

[uditchandna]

Hi venkateswaran.k

Let me share with the example .I believe you misunderstood the question. (This is SuccessFactors data connected to SAC)

Let's say This is the data we have

Now this is the SAC widget we created - Numeric Point on Measure Count 2

Count 2 Formula - Count (User Id) [Counts all the User Id]

With No Filter -> Result = 3

Now I apply 2 filters Employment Status = Suspended AND Gender = Female; which results in no rows to be aggregated. Now result we want is 0 , what we are getting is "-"

Screenshot from our system below

[venkateswaran_k]

uditchandna

I put my comment in answer.