I have data like this-
I need to represent this in bar chart-where x-axis(month) and y-axis(Total_value),
total_value is calculated as (Category_no/Total_no)*100 for each month
I have to represent this in bar chart,the problem is like i have more than one value for each month based on category_name-is there any way how I can combine these values of TOTAL_VALUE and show that under its respective Month
say for example-incase of JAN month-I need to get something like-((41+90)/(41+594))*100=Total_value
(This total value has to be shown under JAN month).
is there any way to do this ?
You can use the "stats" command to aggregate your data. For example:
<your_search>
| stats sum(CATEGORY_NO) as CATEGORY_NO sum(TOTAL_NO) as TOTAL_NO by MON
| eval TOTAL_VALUE=CATEGORY_NO/TOTAL_NO
You can use the "stats" command to aggregate your data. For example:
<your_search>
| stats sum(CATEGORY_NO) as CATEGORY_NO sum(TOTAL_NO) as TOTAL_NO by MON
| eval TOTAL_VALUE=CATEGORY_NO/TOTAL_NO