When working with large datasets, being able to highlight unique data at-a-glance can be valuable as you can visually group rows that share identical values for a specific column.
Right click a value in the results grid, and choose Explore results –> Color by value – and the rows will be colored based on the selected column.
Using the “Color by value” again on the same column will cancel coloring, using it on a different column – will re-color the rows based on a different column.
Crosshair support for charts ysplit=panels
As you may recall from last month’s update, we added support for the ysplit property when using the render operator for barchart, columnchart, timechart, linechart and areachart.
We are now also supporting crosshairs, i.e., vertical lines that move along the mouse pointer. Using crosshair makes graphs more readable and may also be used in place of tooltips:
Data mapping Transformations
Some of the data format mappings (Parquet, JSON and AVRO) support simple and useful ingest-time transformations such as - converting DateTime from Unix seconds, transforming JSON property bag array to a valid JSON document or adding source artifact location.
As part of the ingestion flow, you can create mapping transformations on the table column by selecting the relevant transformation.
These transformations are super helpful for quick transformations. Where the scenario requires more complex processing at ingest time, use Update policy, which allows defining lightweight processing using KQL expression.