Data Visualisation Advice: Representing a Range of Numbers in a list: used or unused

[splunkernator]

Hi Forum,

I want to chart a list - say for example  {1..100} 

and represent this in a mosaic type visual presentation., if a number has been used, or not.

So I would probably look to introduce a second dimension, 1 = used , 0 = unused.

Punch card looks interesting - anyone done anything similar - maybe ip addressing or something else?  my use case is charting ldap attributes (I generate the data with a script so I can control the shape of it)

Want to get everyone away from spreadsheets....

[ITWhisperer]

It depends on what you are trying to visualise in your data.

What insights would a chart help you find?

For example, a simple column chart with x-axis as your number and y-axis as used/unused might be sufficient. Depending whether you are more interested in use or not you might assign the values the other way around. Also, if you mainly have use and are looking for the occasional gap, you might want unused to show up as a spike rather than a dip.

[splunkernator]

I do agree with you and that was a first practical choice I was thinking of.

There is a risk I may be over engineering an answer, but the goal would be to  get a simple view of "where the gaps are".  

I find the more elaborate visualisations particularly helpful as they allow me to take dry technical topics and present to non technical people, who often control budgets, and I can automate the creation of data and feed into existing automated workflows, alerting, ticketing and so on; which for me results in the approach running itself so I can move on to something else.  This is really the my goal in practice.

Really appreciate the quick feedback - starting simple sound very sensible!

[bowesmana]

There are a number of viz that may help.

The Itsy Bitsy App for Splunk - https://splunkbase.splunk.com/app/5256 is an example app that shows some interesting simple XML/CSS techniques.

Also, not sure if Treemap would work for your use case

https://splunkbase.splunk.com/app/3118

[splunkernator]

wow - I like that - looks perfect thank you for the ideas 😀