White Label Storage

I have a report showing # of inbound calls and pickup rate each day of the previous week broken down by Talk number. The goal of the report is to flag any out of the ordinary things like if we had zero calls for the whole week on one of the numbers or if we had calls but none of them are picked up. 

It seems that Zendesk will not show rows where all values in that row are null (for example no calls for one of the talk numbers for the whole week, thus null pickup rate). I would need to see this row to flag that something is wrong. Without showing the row, this report is now doing what it was built to do. 

I have tried to use this solution, but it will only add zeros in spaces where there was null, only if at least one of the values in that row is non-zero or non-null. Meaning, it will not make rows show up where they didn't before. 

Zendesk support told me to write here for help.

I would like to request that the ability be added for filtering tickets based on which of our phone numbers a user texts, just like you can filter with the “Received at” function for emails. This ability should also be added for calls as we are currently using the workaround mentioned in this comment https://support.zendesk.com/hc/en-us/community/posts/5238772442394/comments/6114744930842

Hi Widson Reis , thank you for your workaround of creating tags based on ticket comment “Call to: …” This has solved an issue I was having. I am now trying to understand how I can use this for inbound text messages. I don't see anywhere in the ticket information which phone number the user texted. Do you have a solve for this? Thank you.