I've looked around for answers on this, but unfortunately I've not found an answer to date. I have a list of data, but some of this is duplicate and as such I need to remove a whole row rather than just that value itself, ie:
Store Value 2 Value 3
Store 1 Device_1 Black
Store 1 Device_2 Black
Store 1 Device_3 ----
Store 1 Device_1 Black
What I would like to do is chart this so that I have:
Store Count of Value 2 (Unique) Count of Value 3
Store 1 3 2
When I use
... | chart dc(value 2), count (value 3) by store
It omits only the duplicate value in Value 2, but my count in value 3 is too high, ie:
Store Count of Value 2 (Unique) Count of Value 3
Store 1 3 3
Hi - Sorry, I think the "---" is actually empty in my data. So that part should be okay.
If I extend the values for two more line:
Store Value 2 Value 3
Store 1 Device_1 Black
Store 1 Device_2 Black
Store 1 Device_3
Store 1 Device_1 Black
Store 1 Device_1 Black
Store 1 Device_4 Black
If I exported the data to Excel, I would initially filter all of the results so that I only had unique values in Value 2:
Store Value 2 Value 3
Store 1 Device_1 Black
Store 1 Device_2 Black
Store 1 Device_3
Store 1 Device_4 Black
I would then run a pivot table which would show me the following:
Value 2 Value 3
Store 1 4 3
So essentially, I want to remove any duplicate "lines" based on Value 2.
I hope that makes more sense. Sorry though.
... View more