CCPulse Hide Column is stat = 0?

[amarceau]

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?

[cavagnaro]

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?

[amarceau]

Here's and example of what I would like it to look like:

[b]With NO Hiding[/b]
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

[b]WITH Hiding[/b]
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.

       

[Adam G]

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][b]Object [/b][/i](Agent) - for example; if they are LoggedOut.

But to want to hide a [i][b][b]Statistic[/b][/b][/i], which is possibly a component of a larger Statistic Type ("TotalNumber") by the fact that all of it's associated [b][i]Objects [/i][/b](Queues?) 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

[amarceau]

Thanks for the feedback.  It was worth asking to see if anyone else has done this and figured it out