Hi,
I have a table of data which I need to display the count of "Migration Stratus" in a bar chart. Here is the raw data:
Location
Number of Devices
Migration Status
When Planned
...
See more...
Hi,
I have a table of data which I need to display the count of "Migration Stratus" in a bar chart. Here is the raw data:
Location
Number of Devices
Migration Status
When Planned
Bangalore, India
10
Not Started
Not Known
Cork, IRE
4
Not Started
Not Known
Eldorado Du Sol, Brazil
3
Not Started
Not Known
Hopkinton, USA
4
Not Started
Not Known
Otemachi, Japan
3
Not Started
Not Known
Cyberjaya, Malaysia
4
Not Started
Not Known
Limerick, IRE
4
Not Started
Not Known
Austin, USA
6
Not Started
Not Known
Penang, Malaysia
5
Not Started
Not Known
Durham, USA
6
Not Started
Not Known
Singapore, Singapore
4
Not Started
Not Known
Santa Clara, USA
2
Not Started
Not Known
Sydney, Australia
2
In Progress
FY23 Q2
Xiamen, China
6
Not Started
Not Known
Here is my current output, where when I hoover over "In Progress" it shows 1 and over "Not Started", shows 13:
At the moment, my query is just counting the number of rows for a particular value in "Migration Status" and this value is what is seen when hoovering over each bar on bar chart:
| inputlookup Migration-Status-Symantec3.csv | fillnull value=null | eval dummy = 'Migration Status' | chart count over "Migration Status" by dummy
What I need is the SUMMATION of "Number of Devices" for a particular value in "Migration Status". How can this be achieved???? Many thanks as always