Time Card Reporting

[mjou]

Hi,

I'm trying to create a Report on the time_worked table and trying to figure out a way to filter the graph by task.Company.Name so i can show the amount of time worked per customer/month

Is there a way to do this? Can't seem to figure it out

Data: Table = Time Worked
Type: Column

[Maik Skoddow · Accepted solution]

Hi @mjou 

this is my configuration and it seems to return what you are expecting:

Maik

[Maik Skoddow · Accepted solution]

Hi @mjou 

this is my configuration and it seems to return what you are expecting:

Maik

[mjou]

Hi,

Thanks this works for me aswell.

I was also wonderin if there is a way to use a interactive filter to jump between all companies/one company at a time on this chart

[Maik Skoddow · Accepted solution]

Hi @mjou 

yes, this is possible and you will need a dashboard for this.

Refer to my page https://www.servicenow.com/community/platform-analytics-articles/platform-dashboards-amp-interactive... for resources accordingly.

Maik

[mjou]

Hi,

Thanks alot! I was not aware of the functionality of a reference filter, one of the videos from your page helped me on that.

Cheers!