Chaturbate CSV to chart?
 

Hello everyone. I've been broadcasting for a few months now. As with any job, some days are better than others. Chaturbate lets me download an excel spreadsheet that contains the date and time of each tip, and whether it is a normal tip or a private show.

I'm trying to figure out a way to put all of this information to use so I can tell what my successful days and times are. I have figured out how to individually select the information I want graphed, but I'm looking for a way that I can just type in some dates, press enter, and the graph is made. For example, at a quick glance, I would like to be able to tell what my good days and times were for the month, such as Tuesday evenings are great, but Friday evenings are not. I am an excel amateur, so this is above my head. Anyone know how to do this or has anyone already done this?

Thanks!

Amber(Princess)

close flash first .

Here u go.
How to Graph a CSV File in Excel | eHow

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)

1. Sort the lines by the number of the tips you want to sort by. top menu>Data>sort >descending
   
2. Highlight the fields that you want to chart
3. Press the chart icon in the top menu
   
4. You can choose the chart type in the menu that appears.
   
5. 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 :thumbsup

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

Hi Amber,

I'm not sure how to do that in a spreadsheet.

But I did just add you to @Twiturbate here:

@AmberPrincess4u on Twiturbate :thumbsup

include @Twiturbate or @AmberPrincess4u on Twiturbate in your tweets and I will retweet u across my twitter network :winkwink: