Replacing nulls within summaries

Kevin Rickert
Kevin Rickert Altair Community Member
edited August 20 in Community Q&A

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

image

image

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.

image

image

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

image

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?

Tagged:

Answers

  • CPorthouse
    CPorthouse
    Altair Employee
    edited August 20

    One possibility is to go into your settings

    image

    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"

    image

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

     

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

     

  • Kevin Rickert
    Kevin Rickert Altair Community Member
    edited August 20

    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?

Categories