About cherylheng9586

cherylheng9586 · ‎07-01-2021

I followed @niketn 's syntax to produce a panel of table cells. My syntax is as follow: <dashboard> <label>Test2</label> <row> <panel> <html> <style> #highlight table tbody{ display:flex; flex-wrap: wrap; } #highlight table tbody tr{ margin-right:10px; margin-bottom:10px; } #highlight table tbody tr td{ width: 180px; text-align: center; } </style> <div> <div>Clicked Value in Cell (click.value):$click.value$</div> <div>Clicked Cell Values (click.value2):$click.value2$</div> </div> </html> <table id="highlight"> <search> <query>index="omap_heng" | fields host reception Station | sort 0 +host | search reception = * | streamstats count by reception,host reset_on_change=true | eval new_counter=if(reception == 1,0, count) | table host new_counter Station | streamstats max(new_counter) as max_counter by host | sort 0 +host, -max_counter | streamstats first(max_counter) as max_counter by host | where new_counter=max_counter | table Station,max_counter | eval "Max Counter Info"=Station."###".max_counter | fields "Max Counter Info" | makemv "Max Counter Info" delim="###"</query> <earliest>0</earliest> <latest></latest> <sampleRatio>1</sampleRatio> </search> <option name="count">20</option> <option name="dataOverlayMode">none</option> <option name="drilldown">cell</option> <option name="percentagesRow">false</option> <option name="rowNumbers">false</option> <option name="totalsRow">false</option> <option name="wrap">true</option> <format type="color" field="Max Counter Info"> <colorPalette type="list">[#53A051,#006D9C,#F1813F,#DC4E41]</colorPalette> <scale type="threshold">0,6,11</scale> </format> <format type="number" field="Max Counter Info"> <option name="precision">0</option> </format> <drilldown> <set token="click.value">$click.value$</set> <set token="click.value2">$click.value2$</set> </drilldown> </table> </panel> </row> </dashboard> I would like to highlight each cells, based on a range on max_counter value (the circled value in my image below). Hence, if my max_counter is between 0 and 6, then green, if between 7 and 11, then orange and if above 11, red. My panel currently looks like this now: Pls help! thanks!

cherylheng9586 · ‎06-27-2021

thank you for your inputs!! they really resolved my issue. Is it possible to give each cell a background colour based on a range value? so for instance, if i have an error count of >15, the cell will be highlighted red, if it's between 10 and 15, it will be orange and so forth?

cherylheng9586 · ‎06-22-2021

Hello, I have a single value trellis panel which will show the maximum counts of errors for each car i have. These maximum error counts correspond to a location (called name on the table on the right to show as an example (encoded as numbers)). How should i create a dynamic hovering tool tip such that as my user hover their mouse over the values on the single value panel, a tooltip with the corresponding location will appear? In the image below, i would like the tooltip to contain the corresponding location "name: 8" when the user mouses over the 21 and 19 in the single value panel. Image below as an example. thank you!

cherylheng9586 · ‎06-17-2021

Hello! thank you for your syntax, it worked for me. however, now when i zoom in on panel1, the zoom in does not happen. how should i edit the syntax such that the zoom in would still occur? i attach an image of my timechart here. I will need the zoom in to still happen because my data is collected at the millisecond level, and if i cant see a zoom-ed in version, my chart just looks like a block. hahaah thank you so much nonetheless!!

cherylheng9586 · ‎05-31-2021

Hello, thank you for replying. as i have over 300,000 rows, i am unable to physically count where the changes occurs and hence i couldnt use | eval success_rate=mvindex(split("pass,pass,pass,fail,fail,pass,pass",","),row-1) Instead I was able to create this increment counter with this line and it worked well for me. | streamstats count by "success_rate" reset_on_change=true Just had to add in the "reset_on_change=true" for it to work the way i need it to (:

cherylheng9586 · ‎05-27-2021

I am currently using | streamstats count as index by success_rate, but it doesn't work. What i want: success_rate/Index pass/0 pass/1 pass/2 fail/0 fail/1 pass/0 pass/1 What i am getting: success_rate/Index pass/0 pass/1 pass/2 fail/0 fail/1 pass/3 pass/4 As can be seen above, when "pass" occurs again, the counter continues from the previous pass. pls help! thank you!!

cherylheng9586 · ‎05-23-2021

I used the multiple chart option to achieve the below visualisation. However i would like the customise the Y-axis for each chart to show the visualisation better. For instance, the Y axis max and min for the 1st and 2nd charts would be 2 and 0 and for the third chart would be 20 and 0. help would be greatly appreciated!! thank u!

Posts	7
Solutions	0
Karma Given	0
Karma Received	0
Member Since	‎05-23-2021

Online Status	Offline
Date Last Visited	‎07-02-2021 12:23 PM

How can I highlight table cells conditioned on a v...

dynamic hovering tooltip for single value trellis ...

How to create an increment counter that restarts w...

how to customise y axis for multiple chart series

How can I highlight table cells conditioned on a v...

Re: Issue with css, html, js Formatting Search Out...

dynamic hovering tooltip for single value trellis ...

Re: Is there a way to zoom in inside a panel and t...

Re: How to create an increment counter that restar...

How to create an increment counter that restarts w...

how to customise y axis for multiple chart series