How to Enable Filtering for Calendar Report

[Zhiming Dai]

Hi,

Our team has created a calendar report displaying scheduled maintenance from our maintenance table. Recently we would like to add a filter so that the calendar can display maintenance events for the only group members effected.

There are over a hundred of possible members, so adding all of them to the style table of maintenance table so that group members display as an option in Highlight Based On menu is not an good approach. And the group member field in maintenance table was defined as List instead of Reference (because multiple users may be selected in forms), so our research on filtering the calendar with interactive filters in a Dashboard came to a dead end. 

So, are there any good workarounds to the issues we have? Any help would be appreciated!  

Thank you!

[Maik Skoddow · Accepted solution]

Hi @Zhiming Dai 

meanwhile I remembered the answer of another community user regarding Interactive Filter for list field. Please read https://community.servicenow.com/community?id=community_question&sys_id=65473ab0db96ec50b3c099ead396...

I'm afraid I haven't had the time to try the given solution so far.

Kind regards
Maik

If my answer replied your question please mark appropriate response as correct so that the question will appear as resolved for other users who may have a similar question in the future.

[Zhiming Dai]

Hi @Maik Skoddow ,

This is really helpful info. Thank you! I'll try it out in the next few days.

Thank you,

Zhiming 

[Troy Dewant]

What software do you use for creating such calendars? It does not look like Google Calendar, which I don’t like, and I think it’s overloaded with various functions that I don’t need.  I was looking for good software for creating personal calendars. The best one I’ve found so far is on this february 2023 calendar website. It is simple and easy to use, and it will not take anyone too long to learn how to use it. You can even print the calendar right away. This software is more convenient than Word or Google Calendars for me.  But which one are you using? It looks good too.