About psangli

psangli · ‎07-12-2017

I am using the line <option name="charting.fieldColors">{"SUCCESS": 0x00FF00, "FAIL":0xFF0000}</option> with no problems, however when I use <option name="charting.fieldColors">{"OK": 0x00FF00}</option> in a seperate graph it has problem, because the values that are not "OK" are is grouped into others(). If I put other value from 0.01 to 0 in XML, it fixes it, however I want the other to be there. How can I have other and have the OK field be green?

psangli · ‎07-06-2017

That works! Thanks!

psangli · ‎07-06-2017

sourcetype="h1" | stats count as countbydb by database, user |sort by countbydb |stats list(countbydb), values(database) by user is what I am using. It does not affect the user column. I tried placing the sort by countbydb at the end, but that does not work either.

psangli · ‎07-06-2017

I believe the sort -count part is wrong. It sorts the number of databases, but does not move the name along with it. The names stay in the same order. How would I go about fixing that?

psangli · ‎07-06-2017

sourcetype="h1" user = "user1" database = bdp In the search, bdp appears 10 times. But in the table, it only appears once.

psangli · ‎07-06-2017

I want to see how many times a user has accessed a database in a given time period. I used sourcetype= h1 | stats count by database, user | sort -count|stats list(count), values(database) by user However, after running a search for specific users, the numbers that come up from the above line, do not match up with the number of search results I find by searching for specific users. Is there a reason for the discrepancy ?

psangli · ‎06-29-2017

For example Name Code Pool Name1 100 p1 57 p32 63 p43 230 p27 Name2 120 p2 77 p33 83 p44 250 p28 should become Name Code Pool Name1 230 p27 100 p1 63 p43 57 p32 Name2 250 p28 120 p2 83 p44 77 p33

Posts	7
Solutions	0
Karma Given	1
Karma Received	1
Member Since	‎06-29-2017

Online Status	Offline
Date Last Visited	‎06-05-2020 02:03 AM

Pie chart colors mess up when other field is prese...

Why is there a discrepancy when grouping by a var...

How do you sort columns within a column?

Pie chart colors mess up when other field is prese...

Re: Why is there a discrepancy when grouping by a...

Re: Why is there a discrepancy when grouping by a...

Re: Why is there a discrepancy when grouping by a...

Re: Why is there a discrepancy when grouping by a...

Why is there a discrepancy when grouping by a var...

How do you sort columns within a column?

Join the Conversation