Replacing nulls within summaries

Good afternoon!

I'm currently running into an issue with workspaces created after the switch from older versions of Monarch DataPrep Studio. When we moved to Monarch 2023, it seems that null values in analyses are no longer zeroed out. I'm looking to see if theres a better way to achieve this like we used to.

Its probably easier to explain with pictures..

Here is an older dash made in an older version of DataWatch Monarch DataPrep Studio

If you notice, even for disciplines that do not have visits, it returns a zero.

However, looking at a newer workspace built in Monarch 2023, I'm seeing different behavior.

To get around this, I'm exporting the summary and re-importing it into Monarch to replace the nulls with 0s,

Is there an easier way to achieve this in the summary itself rather than having to export something, refresh the data in Monarch, and then re-export the corrected version?

Find more posts tagged with

English

Monarch

v2023.0

Accepted answers

All comments

CPorthouse

One possibility is to go into your settings

either Application Default or Current Workspace. Application Default would be handled more like a global setting and will affect all of your new workspaces, where Current will only be in place for this workspace. Whichever you decide to use, make sure to select the "Apply to current Workspace" checkbox before clicking OK.

Once you open up the settings, select "Display" in the list on the left, and scroll down on the right until you see "Display nulls as text"

Select the checkbox and enter "0" in the "Display null values as:"

Check the "Apply to current Workspace" and then "OK"

Kevin Rickert

Chris,

Thanks for the response. Taking a look at that, that replaces every instance of a null value with a zero throughout the entire workspace which I don't want to do, since I use null values for other items throughout the workspace.. I really just want to limit it to this particular summary. Is there a way to do this?