How would I create a Scatter Plot (or some chart) where distinct products are listed on the Y-Axis and TimeOfSale is the X-Axis. I need a tick mark plotted for each Product for the appropriate TimeOfSale.
One way, would be to create a lookup table assigning a numberic value to each item. So that Jacket=1, Slacks=2, Shirt=3. Then use the lookup command to convert. This assumes that the item list is known.
Thanks Mike, I used your suggestion (via a slightly different approach. I used a join with | streamstats count as itemid). The revised table now has an itemid representing a numeric y-value. There is still one problem.
My search looks like this:
... | chart values(item_id) over _time by Product
While a 'line' Chart type plots reasonably, a 'scatter' does not. Is there anything peculiar with my data or search that breaks a scatter ?