Anyone know of any way to hide a stat column in CCPulse if the statistic = zero?
Example:
I have a report which shows all the Termination Codes individually so that supervisors can see the count on each of the codes throughout the day. There are 30-40 Inbound Codes and 30-40 Outbound Codes. So total, about 80 termination codes. When the report loads, the majority show ‘0’. I would like to hide the ones that show zero and only show the ones that have a ‘1’ or higher.
Any ideas?
If you hide a column that matches that condition will hide also those that have a value different than zero…are you sure of what you are asking?
Here’s and example of what I would like it to look like:
With NO Hiding
Agent Name TermCode1 TermCode2 TermCode3 TermCode4 TermCode5
Agent1 0 0 0 0 0
Agent2 1 0 1 1 0
Agent3 0 0 0 0 0
Agent4 1 0 1 0 0
WITH Hiding
Agent Name TermCode1 TermCode3 TermCode4
Agent1 0 0 0
Agent2 1 1 1
Agent3 0 0 0
Agent4 1 1 0
So since TermCode2 & TermCode5 had all zero’s in the columns that column was hidden. As previously stated - we have 80+ term codes and the majority are used rarely if at all, so ideally I would like to hide them from the day to day realtime view.
I’m not sure that this can be done - I’ve not seen it done, anyway…
It is usual that you might want to hide an [i]Object /i - for example; if they are LoggedOut.
But to want to hide a Statistic, which is possibly a component of a larger Statistic Type (“TotalNumber”) by the fact that all of it’s associated [b]Objects /b contain ALL NULL values…?
I know that you can manually hide statistical columns and reshow them manually - but I haven’t seen this automated…
The only thing I can think of suggesting is that you look at how you have built up your “TermCode” (is that a Key-Value Pair?) Statistics - and try to find another way to display them/hide them, automatically…
TT
Thanks for the feedback. It was worth asking to see if anyone else has done this and figured it out 