Hi guys,
I have data that reports page views per hour, per type of page (home page, search page, product page). I can draw a chart that displays stacked bars per hour with counts of page views for each of the page type.
Using this data, I can filter to get results only for a specific domain (host), so for example I can get the page view stats per hour, per page for host X. I can do the same then for host Y by changing the filtering.
# _time Home Search Details
1 4/2/13 12:00:00.000 AM 8 15 27
2 4/2/13 1:00:00.000 AM 11 23 34
3 4/2/13 2:00:00.000 AM 15 31 43
4 4/2/13 3:00:00.000 AM 5 10 12
The issue I'm having is when I want to display the data from host X and host Y on the same chart to be able to see them side by side. This would imply that data from host X is on a stacked bar, while that from host Y is on a different one.
The tabular data is like this (prefixed with X and Y for the hosts):
# _time X:Home X:Search X:Details Y:Home Y:Search Y:Details
1 4/2/13 12:00:00.000 AM 8 15 27 6 13 20
2 4/2/13 1:00:00.000 AM 11 23 34 13 18 27
3 4/2/13 2:00:00.000 AM 15 31 43 17 42 61
4 4/2/13 3:00:00.000 AM 5 10 12 2 5 8
Is this possible? Do you have any suggestions on how it can be done?
Thank you.
... View more