Missing Data Input Rule

#1

I have a data label with a count of a measure.
if there is at least 1 or more then everything is good.
When there is none, I am not getting zero I get “No Data” .
I have tried many combinations of the ‘Missing Data Input Rule" thinking well “No Data” is equivalent to “NULL” but I still get "No Data’.
Then I check the “Disable No Data Indicator” but it still shows, so I can not put a label under it to be seen when the No Data is hidden.

Any ideas on a work around?

Update no the “Disable No Data Indicator” is working all of the sudden. and now it is not again…

image
seams I have all three conditions. the closest to what I want is the Q4 “Jeopardy:” with no number, would like to see a zero there.
All of them are set up the same way but acting different.

I have by pass data cache enabled.

#2

Did you check the folowing on the properties of the count measure (see image below):

image
image.png778×689 22.6 KB

It did work for me.

Hope this helps

#3

image

Yes

Also I realized why Jeopardy is showing, that is actual text not the link back to the row value.
The row value on that one was too long so I replaced it with a shorter Text version.
But still that should be the same on the other two as well.

#4

You should choose on the “Missing Data Input Rule” the option “Full Nulls”

#5

Did that too and still no Zero. I tried every combination.

As far as the Disable No data Indicator, When I changed it on the metric set it didnt update the one on the dashboard.
Looks like what I might have to do is blank = zero and not use the Row value and just put text (on 60 data labels).

#6

I don’t know your particular case. I have a data cube that selects the data from a table and a metric set on this data cube then on the metric set I created a count measure for this. If I delete all the data from the table, I get a “0” on the data label. I’m using version 6.

#7

This is a defect ’ Prevent Full Nulls from displaying properly when a missing data input rule is set up.’ that has been fixed in Dundas BI v6.0.1 rev 3. Please upgrade to version 6.0.1.1003 and let me know if it solves the issue.

#8

I am on ver 6.0.1.1002 Looks like I need to upgrade

#9

Not that anyone cares but i’m on 6.0.1.1000 and i work here. I should probably upgrade too as i was reproducing the same issue as i was following along looking for a solution for you. :slight_smile:

@Inactive-Member-11588809 - thanks for pointing out the fix.

#10

I exported the project to our dev server then upgraded dev to 1003.
image
still no number.

let me try somethings… nope, i just tried full null source nulls, combo with Zero, None, Empty.
same thing.

Yes I was on my dev, didn’t accidentally switch back to production., and just re verified it upgraded to 1003

#11

This might help
image

Q4 status is a Dimension that I need to filter to one status to get the count of how many I have in that status.
Goal rank is a Measure but I am not wanting the sum of it just a count.
This gives me the total number of how many Completed I have.
Each Quarter is a column that for each row you can put 1 of 4 statuses, or leave blank (No Entry).
Am I just approaching this wrong? I try to use the Q4 Status for a count and all i get is 1, and I cannot filter it to what status I am counting.

#12

I figured out what is wrong. Dundas is doing everything right.
Long story of why, but I had to make just one table for the time being of all this data.
I wanted to have reference tables from the start but that was not possible at this time, again long story why.
So what is happening in my case:
I made a table with fake data (it had all the status in it) and set up all the states to the different possible statuses.
Well no that I switch Data Cubes to the live version and there is no table that has a list for Dundas to read all the possible statuses, it doing what it should and looking in the table for the different statues that are present.
Well there are none (No entry) so I have not properly told Dundas that there is a possibility of other statuses.

I figure this out when I tried to use small multiples to solve the problem and then it hit me.

Why have i made a horrible table with no reference tables to fix my issue?
I am using a simple tool to have the users update their data, that can only do an update to one table, no joins.
The place for me to put a proper solution (in house web site) is not ready yet. once it is ready and they have time to make this part I can change up to a better DB schema.

This is a lesson in bad data in bad dashboard out.
Thank you all for the help.

1 Like