Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
×
Are you a member of the Splunk Community?
Sign in or Register with your Splunk account to get your questions answered, access valuable resources and connect with experts!
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Find Answers
- :
- About ihaveasplunkacc
ihaveasplunkacc
Loves-to-Learn Lots
Member since:
02-15-2020
06-01-2021
Community Statistics
| Posts | 8 |
| Solutions | 0 |
| Karma Given | 0 |
| Karma Received | 0 |
| Member Since | 02-15-2020 |
Activity Feed
- Posted Re: Can you add lines to a bubble chart? on Dashboards & Visualizations. 05-29-2021 04:52 AM
- Tagged Can you add lines to a bubble chart? on Dashboards & Visualizations. 05-27-2021 08:53 PM
- Tagged Can you add lines to a bubble chart? on Dashboards & Visualizations. 05-27-2021 08:53 PM
- Tagged Can you add lines to a bubble chart? on Dashboards & Visualizations. 05-27-2021 08:53 PM
- Posted Can you add lines to a bubble chart? on Dashboards & Visualizations. 05-27-2021 12:11 PM
- Posted Re: Table with with a column that contains positive and negative values. I want to sum the total of all values and have the results as a Total, but it ignores the negative values. What am I doing wrong? on Splunk Search. 02-21-2020 04:21 PM
- Posted Re: Table with with a column that contains positive and negative values. I want to sum the total of all values and have the results as a Total, but it ignores the negative values. What am I doing wrong? on Splunk Search. 02-21-2020 03:48 PM
- Posted Table with with a column that contains positive and negative values. I want to sum the total of all values and have the results as a Total, but it ignores the negative values. What am I doing wrong? on Splunk Search. 02-21-2020 03:07 PM
- Tagged Table with with a column that contains positive and negative values. I want to sum the total of all values and have the results as a Total, but it ignores the negative values. What am I doing wrong? on Splunk Search. 02-21-2020 03:07 PM
- Tagged Table with with a column that contains positive and negative values. I want to sum the total of all values and have the results as a Total, but it ignores the negative values. What am I doing wrong? on Splunk Search. 02-21-2020 03:07 PM
- Tagged Table with with a column that contains positive and negative values. I want to sum the total of all values and have the results as a Total, but it ignores the negative values. What am I doing wrong? on Splunk Search. 02-21-2020 03:07 PM
- Tagged Table with with a column that contains positive and negative values. I want to sum the total of all values and have the results as a Total, but it ignores the negative values. What am I doing wrong? on Splunk Search. 02-21-2020 03:07 PM
- Tagged Table with with a column that contains positive and negative values. I want to sum the total of all values and have the results as a Total, but it ignores the negative values. What am I doing wrong? on Splunk Search. 02-21-2020 03:07 PM
- Posted Re: How do you add all the values in a column to get the total and then divide the total by the number of rows in the column? on Splunk Search. 02-15-2020 04:12 PM
- Posted Re: How do you add all the values in a column to get the total and then divide the total by the number of rows in the column? on Splunk Search. 02-15-2020 03:45 PM
- Posted How do you add all the values in a column to get the total and then divide the total by the number of rows in the column? on Splunk Search. 02-15-2020 02:43 PM
- Tagged How do you add all the values in a column to get the total and then divide the total by the number of rows in the column? on Splunk Search. 02-15-2020 02:43 PM
- Tagged How do you add all the values in a column to get the total and then divide the total by the number of rows in the column? on Splunk Search. 02-15-2020 02:43 PM
- Tagged How do you add all the values in a column to get the total and then divide the total by the number of rows in the column? on Splunk Search. 02-15-2020 02:43 PM
Topics I've Started
| Subject | Karma | Author | Latest Post |
|---|---|---|---|
| 0 | |||
| 0 | |||
| 0 |
05-29-2021
04:52 AM
I have read this community post, but it does not work for me in this scenario or I don't understand it completely. The lines generated in the chart are relative to or a percentage of the chart layout for placement. They don't actually get placed based on the values of the chart. 20% from the left or 80px mark does not work. I need lines at a specific x value or y value. https://community.splunk.com/t5/Splunk-Search/How-to-add-division-line-on-the-scatter-chart/m-p/417114?fbclid=IwAR0KyY6rZ7WTbisCwGi_NgeAywIUFH2F3rfyvpUmifKO2gMb8Bn0DUAoOb8
... View more
05-27-2021
12:11 PM
How do I add a horizontal and vertical line to a bubble chart at the 0 mark on the x y axis? Similar to the ones that I drew in this picture. I saw some articles that show how to do it in a timeline, but they don't seem to work in a bubble chart.
... View more
Labels
- Labels:
-
chart
02-21-2020
04:21 PM
Wow, your sample proved thing correct. Thank you. The problem was with the negative numbers in my sample. They actually had the $ before the value in the field. I thought it was showing up because of table formatting that I had done in my dashboard. I stripped the $ sign out and then the math worked. Your answer is correct and really helped. Thank you! Have a great weekend.
... View more
02-21-2020
03:48 PM
I just realized the sample data I posted had slight formatting error, but the problem is still the same. The samples below have the correct values.
Results in Excel with the output that I am looking for
Account Estimated Gain_Loss
Total 3200
ACCOUNT1 1000
ACCOUNT2 2000
ACCOUNT3 500
ACCOUNT4 -300
Results in Splunk with incorrect total
Account Estimated Gain_Loss
Total 3500
ACCOUNT1 1000
ACCOUNT2 2000
ACCOUNT3 500
ACCOUNT4 -300
... View more
02-21-2020
03:07 PM
| table Account "Estimated Gain_Loss"
| addcoltotals labelfield="Account" label="Totals"
| sort -"Estimated Gain_Loss"
... View more
02-15-2020
04:12 PM
My bad. You were absolutely correct.
Thank you
... View more
02-15-2020
03:45 PM
Thank you, but that is not exactly what I am looking for.
Field=percentage with a value=.25
and the second value in the field
Field=percentage with a value=.50
If I add them I get a total of .75, but I want to divide that total by the number of values added to make it. In this case it would be .75/2=.375
So if I I have a column of percentages, I want to add them all up and then divide the total by the number of values that made the sum.
... View more
02-15-2020
02:43 PM
The column to the right has a total of the percentage increase, but I would like to take that total and divide it by the number of rows that made the total.
source="im_positions*.csv" sourcetype="stock-Positions:csv"
| dedup Symbol
| rename "Market Value" as mv
| rename "Estimated Gain_Loss" as egl
| rex field=mv mode=sed "s/,//"
| rex field=egl mode=sed "s/,//"
| rex field=Price mode=sed "s/,//"
| replace $* with * in Price
| replace $* with * in egl
| replace N/A with 0 in egl
| replace $* with * in mv
| replace .000 with * in Quantity
| eval originalprice = (mv - egl)/Quantity
| eval eglneg=egl
| replace - with * in eglneg
| replace $* with * in eglneg
| replace N/A with 0 in eglneg
| eval originalpriceneg = (mv)+(eglneg)
| eval originalprice=if(isnull(originalprice), originalpriceneg, originalprice)
| eval Percent = round(((Price - originalprice)/originalprice*100),0)
| table Symbol Description Quantity originalprice Price egl mv Percent
| rename originalprice as "Purchased Price"
| rename Price as "Current Price"
| rename mv as "Market Value"
| rename Percent as "Percentage Increase"
| rename egl as "Estimated Gain_Loss"
| rename Quantity as "# of Shares"
| addcoltotals
| sort -"Estimated Gain_Loss"
... View more
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
06-01-2021
12:38 PM
|
