Create a bar graph showing where bar is split by "logged By = LogicMonitor" and "Everything else"

[Steve Ivis]

I want to create a bar graph which shows all calls for a specific day, where the bar is split in 2. The first is Logged by Monitoring (logged by = Logicmonitor) and the second is "everything else".

The closest I have come is to use "other" but the fewest to show is 10, so that means showing logicmonitor plus 9 normal users. I want logic monitor on its own and everything else all grouped together.

I have requested additional options in the Channel field of "Monitoring", but that may be a while off, plus it wont fix the 

Historical data. Thanks in advance.

[Mark Manders · Accepted solution]

You can create a 'column' chart and work with two datasets on the same report. You select one as 'logged by = logicmonitor' and the other one as 'logged by != logicmonitor'. It will show you the two bars next to each other. 

You can't have a bar split by one/other, unless you create custom logic like a field that is set to true when it is the monitor. Then you can split it on true/false. But I can't imagine reporting on this is that important that you would be creating custom fields and logic for that.

[Steve Ivis]

Hi Mark,

Thanks very much for your reply. I will try that out tomorrow. In the longer term, I've asked for an extra channel so we'll be able to report daily on Walk-in, Phone, Portal and Monitoring generated calls. Its just we have a ServiceNow change freeze on until after the forthcoming release.

[Steve Ivis]

Hi Mark,

Sorry if i'm being slow here, but are you saying create 2 reports (one for LogicMonitor calls, and the other for non-Logicmonitor calls), that both output to a separate datasource, and then use another report that uses both datasources?  

[Steve Ivis]

Hi Mark,

Thanks very much. I persevered and took your advice. It works perfectly. I've never used multiple datasets before, so i've learned something new. Thankyou very much.