2 Replies Latest reply on Sep 25, 2013 3:32 PM by george floratos

I have events that span multiple days across many locations, trying to 'bin' the days to see how many events were 'active' on each day for the past year

george floratos Sep 25, 2013 1:31 PM

for example

Event name	event type	site	Event Start	event End
event a	event type 1	New York	Jan 1	Jan 4
event b	event type 2	New York	Jan 3	Jan 5
event c	event type 1	New York	Jan 2	Jan 6
event d	event type 3	New York	Jan 4	Jan 7
event e	event type 3	New York	Jan 5	Jan 7
event f	event type 2	New York	Jan 2	Jan 7
event g	event type 1	New York	Jan 1	Jan 7

My data spans the entire year, with some nulls, with thousands of events across many locations, but to simplify lets take 1 location

I want to a chart that will show that

Jan 1 had 2 events active

Jan 2 had 4 active events

Jan 3 had 4 active events

Jan 4 had 6

Jan 5 had 6

Jan 6 had 5

Jan 7 had 4

I cant seem to figure out how to 'bin' the active events into these slots by day, so that the x axis is a day and the y axis is the number of events that were active any particular day.

I have created a massive 'sparse matrix' in excel and placed a '1' in every date column for each row (event), and then uploaded them as measures per day to get a sum, and measure names as the x axis, but this is tedious and tableau crushes my CPU putting it together.

There has to be a better way?

1. Re: I have events that span multiple days across many locations, trying to 'bin' the days to see how many events were 'active' on each day for the past year

Jonathan Drummey Sep 25, 2013 1:45 PM (in response to george floratos)

I'm guessing that the "massive 'sparse matrix'" is being left as an Excel file and not a Tableau data extract? That can deal with much larger volumes of data.

In any case, to do this kind of analysis in Tableau you will need to pad out the data. There are a variety of ways to do it, I assembled a number of related posts in http://community.tableau.com/thread/121505?start=0&tstart=0.

Jonathan
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: I have events that span multiple days across many locations, trying to 'bin' the days to see how many events were 'active' on each day for the past year

george floratos Sep 25, 2013 3:32 PM (in response to Jonathan Drummey)

I essentially aggregate the data I am looking for from separate MySQL instances at each location into a single spreadsheet, and then I do import all the data into Tableau.

Not surprising this was a hot topic a the last conference.

Ill read thru all those posts and see where it takes me.

Thanks!
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

I have events that span multiple days across many locations, trying to 'bin' the days to see how many events were 'active' on each day for the past year

1. Re: I have events that span multiple days across many locations, trying to 'bin' the days to see how many events were 'active' on each day for the past year

2. Re: I have events that span multiple days across many locations, trying to 'bin' the days to see how many events were 'active' on each day for the past year

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account