I want to build a graph that will show the change in number of actions over time. Something like a line graph with dates on the bottom, and the totals for 'FirstAction' and 'SecondAction' plotted for each day.
So:
day 1 would show 'FirstAction' == '8', and 'SecondAction' == '1'
day 2 would show 'FirstAction' == '7', and 'SecondAction' == '8'
This seems like it would be easy, but using the lens results in unexpected graphs.
I was trying to obfuscate the real data in my example. When I was asked for a screen shot, I added the above data... more or less... and tried to reproduce the problem so that I could take a screenshot.
Turns out that what I mostly needed was: #1: for the vertical axis: Each 'action' should use the function "sum" #2: for the horizontal axis: Choose 'date histogram', and for the timestamp, choose 'customize time interval' to '1 days'.
Simple stuff really... but I was tripping over some overly complicated filtering, and missing the time interval option.
That said, your response was very enlightening. Ill put that in my back pocket for when I need it. Thank you.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.