Line charts auto-series: fails to compare key data column
Posted: Tue Oct 13, 2020 4:15 pm
Hello,
I have a CSV data source with the following header: 'Key', 'Timestamp', 'Value'.
I want to obtain a line chart with one line for each unique Key. Each line is a plot for (Timestamp, Value).
So I set 'Auto Series Key Data Column' to 'Key', 'Argument Data Column' to 'Timestamp' and 'Value Data Column' to 'Value'.
What happens is that some Keys are not compared properly. For example, "10.38.1" vs. "10.38.2" or "10.10.10" vs. "10.10.20"
Tested working Keys: "10.10.10" vs. "20.20.20", "10.1" vs. "10.2"
It appears that the letter after the second "." is not compared properly.
I attached a .mrt file which exemplifies the issue.
Originally the Keys were some IPs.
Thanks,
Darius
I have a CSV data source with the following header: 'Key', 'Timestamp', 'Value'.
I want to obtain a line chart with one line for each unique Key. Each line is a plot for (Timestamp, Value).
So I set 'Auto Series Key Data Column' to 'Key', 'Argument Data Column' to 'Timestamp' and 'Value Data Column' to 'Value'.
What happens is that some Keys are not compared properly. For example, "10.38.1" vs. "10.38.2" or "10.10.10" vs. "10.10.20"
Tested working Keys: "10.10.10" vs. "20.20.20", "10.1" vs. "10.2"
It appears that the letter after the second "." is not compared properly.
I attached a .mrt file which exemplifies the issue.
Originally the Keys were some IPs.
Thanks,
Darius