Day|Hour|TipCount
_______________
Mon |23|14
Fri |20|12
Fri |16|11
Caution: I use office libre and gnumeric not microcrap products (they are very similar in function but may be different in some ways)
- Sort the lines by the number of the tips you want to sort by. top menu>Data>sort >descending
- Highlight the fields that you want to chart
- Press the chart icon in the top menu
- You can choose the chart type in the menu that appears.
- You need to set the axis and column orders that you want -- that is the hard part.
It's better to do this in MySQL and use HTML5 charting -- thanks for the good idea
I used to do this relating global customers logged in, global model count, and private session counts. I related the customer count to model activity with day of week and hour of day. The objective was similar however I charted all models globally -- (all models online as a group [talent pool]). It can be done manually . An automated query requires JASON and nosql and an interface middleware. We are using Kibana
https://www.elastic.co/products/kibana and hadoop