Return values as well as null values

Answered

Comments

7 comments

  • Avatar
    Monika Yadav

    Hi Mary,
    You can add a calculation to show you NULL instead of the blank. I am attaching an example of the logic as well as the result set.

     

    This way if the service code name is blank it will show you NULL otherwise it will display the service code name itself.

    Hope this answers your question.

    0
    Comment actions Permalink
  • Avatar
    Mary McMullen

    Thank you. I do need David (or someone) to help me reconfigure the report he built for us to include the following: 

    Client Group Name

    Client Last Name

    Client First Name

    Return all service names when present, or a null value if client has no active services. 

    I cannot figure out how to modify the report he created me to get the additional data fields required. All we have is client numbers and service names. Nothing else. Cannot use report until we have the full data required. 

    0
    Comment actions Permalink
  • Avatar
    Mary McMullen

    Hi Monika, 

    I was just able to work on this report again. I used your IF statement above as a calculation, but the report is not returning any null values. I know that the agencies that are currently training to prepare for go live do not have services created for every single client. I need to have this report return every active client, and whether or not active services exist. If a client does not have any active services yet, I need for their name to appear on this list, but show the service section as either a BLANK, or NULL, or a 0, or something that quickly draws my attention to the fact that they don't have services set up yet. Report is in the SERVICE CHECK dashboard. If someone could walk me through what I have done wrong and how to fix vs fixing it for me, it will help me learn for future reports. 

    0
    Comment actions Permalink
  • Avatar
    Monika Yadav

    Hello Mary,
    I would love to help you on this. can you please share the report name(if already exists) or I can create a new report based on what exactly you need.  
    Sending you an email.

    Thanks,
    Monika

    0
    Comment actions Permalink
  • Avatar
    Mary McMullen

    Hi Monika, 

    The report is in the Service Check dashboard, screenshot is below. All of the data points are there, I just can't figure out why the formula you gave me doesn't allow me to see all clients, even if they have NO active services. The main point of this report is to help us during our pre-go-live configuration process, to ensure each client in the system has at least 2 active services. We want to be able to point out the names of clients that have NO active services, but still show those who do. I hope that makes sense! 

    0
    Comment actions Permalink
  • Avatar
    Monika Yadav

    Mary,
    You are not seeing clients with no active services because the service explore is primary which means service explore holds only clients that have a service attached to them. If you want to see the clients with no service, make clients explore primary, sort the result set and use the formula to show you a word instead of being blank. 

    I have created a report for you. Service check dashboard -> Modified Service check.
    You can hide the field that you dont want in visualization.

    Let me know if it helps!

    Monika

     

    0
    Comment actions Permalink
  • Avatar
    Monika Yadav

    Hi Mary,

    You are not seeing clients with no active services because the service explore is primary which means service explore holds only clients that have a service attached to them. If you want to see the clients with no service, make clients explore primary, sort the result set, and use the formula to show you a word instead of being blank. 

    I have created a report for you. Service check dashboard -> Modified Service check.

    You can hide the field that you don’t want in visualization.

    Let me know if it helps!

    Thanks,
    Monika

    0
    Comment actions Permalink

Please sign in to leave a comment.