Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
×
Join the Conversation
Without signing in, you're just watching from the sidelines. Sign in or Register to connect, share, and be part of the Splunk Community.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Find Answers
- :
- About Federico92
Federico92
Path Finder
Member since:
05-18-2021
07-04-2025
Community Statistics
| Posts | 28 |
| Solutions | 2 |
| Karma Given | 5 |
| Karma Received | 2 |
| Member Since | 05-18-2021 |
Activity Feed
- Posted Dashboard studio Table Colors on Dashboards & Visualizations. 07-04-2025 07:56 AM
- Posted Re: Display only overlay values in a bar chart Splunk 9.3.x on Dashboards & Visualizations. 02-04-2025 01:05 AM
- Karma Re: Display only overlay values in a bar chart Splunk 9.3.x for ITWhisperer. 02-04-2025 01:03 AM
- Posted Re: Display only overlay values in a bar chart Splunk 9.3.x on Dashboards & Visualizations. 02-04-2025 12:08 AM
- Posted Display only overlay values in a bar chart Splunk 9.3.x on Dashboards & Visualizations. 02-03-2025 07:35 AM
- Posted Re: Metrics Index on All Apps and Add-ons. 05-06-2022 12:52 AM
- Posted How to set up Metrics Index for dashboard? on All Apps and Add-ons. 05-04-2022 05:03 AM
- Karma Why do I get the previously inserted value when using JavaScript to read an input value? for andrewtrobec. 11-23-2021 11:31 PM
- Karma How do I add a listener to an HTML button that was added to a Splunk table viz using JavaScript? for andrewtrobec. 11-08-2021 02:28 AM
- Got Karma for Save Editable Table into a lookup with Javascript. 11-04-2021 09:19 AM
- Posted Save Editable Table into a lookup with Javascript on All Apps and Add-ons. 11-04-2021 08:44 AM
- Karma Re: Modal with Custom View for kamlesh_vaghela. 07-04-2021 11:03 PM
- Posted Re: Modal with Custom View on Dashboards & Visualizations. 06-30-2021 08:30 AM
- Posted Modal with Custom View on Dashboards & Visualizations. 06-30-2021 12:35 AM
- Posted Re: Modal Drill down on Dashboards & Visualizations. 06-22-2021 08:32 AM
- Posted Re: Modal Drill down on Dashboards & Visualizations. 06-22-2021 06:31 AM
- Posted Re: Modal Drill down on Dashboards & Visualizations. 06-22-2021 06:31 AM
- Posted Re: Modal Drill down on Dashboards & Visualizations. 06-21-2021 09:30 AM
- Posted Re: Modal Drill down on Dashboards & Visualizations. 06-16-2021 11:31 PM
- Posted Re: Modal Drill down on Dashboards & Visualizations. 06-16-2021 11:15 PM
Topics I've Started
| Subject | Karma | Author | Latest Post |
|---|---|---|---|
| 0 | |||
| 0 | |||
| 0 | |||
| 1 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 |
07-04-2025
07:56 AM
Hi all, I want to create a table in which row colours change based on row value. In attachment source code { "type": "splunk.table", "options": { "fontWeight": "bold", "headerVisibility": "none", "rowColors": { "mode": "categorical", "categoricalColors": { "ce": "#4E79A7", "edit": "#F28E2B", "service_overview": "#E15759", "e2e_ritm": "#76B7B2", "e2e_task": "#59A14F", "monitor": "#EDC948", "sla__time_to_first_response": "#B07AA1", "sla__time_to_resolution": "#FF9DA7" }, "field": "file" }, "columnFormat": { "placeholder": { "data": "> table | seriesByName(\"placeholder\") | formatByType(placeholderColumnFormatEditorConfig)" }, "file": { "data": "> table | seriesByName(\"file\") | formatByType(fileColumnFormatEditorConfig)" } } }, "dataSources": { "primary": "ds_b4QqXqtO" }, "title": "Legend", "context": { "placeholderColumnFormatEditorConfig": { "string": { "unitPosition": "after" } }, "fileColumnFormatEditorConfig": { "string": { "unitPosition": "after" } } }, "containerOptions": {}, "showProgressBar": false, "showLastUpdated": false } The code seems to be correct but it doesn't work. I want to know what is wrong and especially if the function i want is supported. Thanks in advance
... View more
Labels
- Labels:
-
Dashboard Studio
02-04-2025
01:05 AM
Yeah it works sorry i need to active the showDataLabels in the charting options. Thanks a lot
... View more
02-04-2025
12:08 AM
Now the overlay line and the "Total" value in the legend are hidden. Overlay values to display are not visible yet
... View more
02-03-2025
07:35 AM
Hi everyone. I need to modify this bar chart In order to hide the overlay lay and display the overlay values. Also need to remove "Total" value from the legend. This is my CSS configurations that doesn't works: <row> <panel depends="$css$"> <title>CSS</title> <html> <style/> <!-- hide numbers on the chart --> #hide_number_distribution .highcharts-data-label text tspan { visibility:hidden; } <!-- show numbers for "Total" --> #hide_number_distribution .highcharts-series-0 .highcharts-data-label text tspan { visibility:visible !important; } <!-- hide line for "Total" --> #hide_number_distribution .highcharts-series-0.highcharts-line-series path { visibility:hidden !important; } <!-- hide "Total" from the legend --> #hide_number_distribution .highcharts-legend-item .highcharts-line-series .highcharts-color-undefined .highcharts-series-0 { visibility:hidden !important; } </style> </html> </panel> </row> The id "hide_number_distribution" is on the panel (not on the chart) and the dataLabels option for the chart is: <option name="charting.chart.showDataLabels">none</option> Can anyone help me to understand why this not works and fix it? Thanks in advance
... View more
Labels
- Labels:
-
CSS
05-06-2022
12:52 AM
I need to calculate some metrics for dashboarding (es count of records), but the calculation should be responsive to some dashboard filters For example, I had stored in metrics index the record count that have value=100 If I change the value of one filter in the dashboard, this value should be 10 I need some suggestion on how make this requirement with metrics index
... View more
05-04-2022
05:03 AM
Hi all! I need to store more than 500.000 events in an event index and apply aggregation logic that produces metrics to display on a dashboard. I want to use a metrics index to store these metrics so I can improve the performance of the dashboard. The dashboard will have some filters that could generate n! different combinations (one combination per set of filter values).
My concern is that in order to be able to guarantee acceptable response times I will need to generate a metric for every possible combination of the filters, and that just seems excessive.
Is this the only way to achieve what I am looking for?
... View more
Labels
- Labels:
-
dashboard
-
development
-
search
11-04-2021
08:44 AM
1 Karma
Hi All I need to save this editable table with its values into a KV Store. I want to click on a submit button and store it into a KV Values on text field are editable, it means that i could write any value and save it to the lookup. This is my XML and JS script XML <form script="dinamicTable.js"> <init> <set token="read_table">*</set> <unset token="edit_table"></unset> </init> <label>Data Entry Test Clone</label> <fieldset submitButton="false"> <input type="dropdown" token="tok_crq_id"> <label>CRQ ID</label> <fieldForLabel>number</fieldForLabel> <fieldForValue>number</fieldForValue> <search> <query>index=data_entry | stats count by number</query> </search> </input> <input type="checkbox" token="tok_operation"> <label>Operation</label> <choice value="*">Add</choice> <change> <condition label="Add"> <unset token="read_table"></unset> <set token="edit_table">*</set> </condition> <condition> <unset token="edit_table"></unset> <set token="read_table">*</set> </condition> </change> <delimiter> </delimiter> </input> </fieldset> <row depends="$read_table$"> <panel> <table id="tableVizualization"> <search id="number_of_events"> <query>index=data_entry | rex field=impacted_systems mode=sed "s/\|yes\|no//g" | table number impacted_systems | makemv delim=" " impacted_systems | where number="$tok_crq_id$" | mvexpand impacted_systems | eval "Feedback"= " " | table impacted_systems Feedback | rename impacted_systems as "Impacted Systems"</query> <finalized> <set token="tok_job_sid">$job.sid$</set> </finalized> <earliest>0</earliest> <latest>now</latest> <sampleRatio>1</sampleRatio> </search> <option name="count">20</option> <option name="dataOverlayMode">none</option> <option name="drilldown">none</option> <option name="percentagesRow">false</option> <option name="refresh.display">progressbar</option> <option name="rowNumbers">false</option> <option name="totalsRow">false</option> <option name="wrap">true</option> </table> </panel> </row> <row depends="$edit_table$"> <panel> <title></title> <table> <search> <query>| loadjob $tok_job_sid$ | append [ | makeresults | eval "Impacted Systems" = "New system" | table "Impacted Systems" Feedback ]</query> <earliest>0</earliest> <latest>now</latest> <sampleRatio>1</sampleRatio> </search> <option name="count">20</option> <option name="dataOverlayMode">none</option> <option name="drilldown">none</option> <option name="percentagesRow">false</option> <option name="refresh.display">progressbar</option> <option name="rowNumbers">false</option> <option name="totalsRow">false</option> <option name="wrap">true</option> </table> </panel> </row> </form> dinamicTable.js require([ 'underscore', 'jquery', 'splunkjs/mvc', 'splunkjs/mvc/tableview', 'splunkjs/mvc/simplexml/ready!' ], function(_, $, mvc, TableView) { var CustomRangeRenderer = TableView.BaseCellRenderer.extend({ canRender: function(cell) { // Enable this custom cell renderer for Person field console.log(cell) return _(["Impacted Systems"]).contains(cell.field) || _(["Feedback"]).contains(cell.field) || _(["Action"]).contains(cell.field); }, render: function($td, $tr, cell) { // Add a class to the cell based on the returned value var strCellValue = cell.value; console.log($td) if (cell.field === "Impacted Systems") { var strHtmlInput="<input type='text' class='table-text-box' value='"+strCellValue+"'></input>"; //Add TextBox With Specific Style $td.append(strHtmlInput); } if (cell.field === "Feedback") { var strHtmlInput="<select><option value=\"No\">No</option><option value=\"Yes\">Yes</option></select>"; //Add TextBox With Specific Style $td.append(strHtmlInput); } if (cell.field === "Action") { var strHtmlInput="<input type='button' class='btn btn-primary'></input>" }); } } }); mvc.Components.get('tableVizualization').getVisualization(function(tableView) { // Add custom cell renderer, the table will re-render automatically. tableView.addCellRenderer(new CustomRangeRenderer()); }); }); Anyone could please help me? Thanks!
... View more
Labels
- Labels:
-
dashboard
-
development
06-30-2021
08:30 AM
Dashboard XML <form hideFilters="true" script="loadLabels.js,multiselectAllRemove.js, ticketModalTest.js" theme="light"> <init> <!-- https://colorbrewer2.org/#type=qualitative&scheme=Paired&n=12 --> <set token="qualitativePaired">[0xa6cee3,0x1f78b4,0xb2df8a,0x33a02c,0xfb9a99,0xe31a1c,0xfdbf6f,0xff7f00,0xcab2d6,0x6a3d9a,0xffff99,0xb15928]</set> <set token="red_green">[0xe31a1c,0x33a02c]</set> <set token="green_red">[0x33a02c,0xe31a1c]</set> <set token="form.tok_weeks">-7w@w1</set> <set token="form.tok_stats">max</set> </init> <label>Execution Statistics Clone</label> <search id="base_execution_statistics"> <query> index=optimus_execution_statistics_idx | stats latest(script_name) as script_name latest(execution_status) as execution_status latest(execution_started) as execution_started latest(execution_ended) as execution_ended latest(category_name) as category_name latest(execution_host) as execution_host by _time execution_id </query> <earliest>-30d@d</earliest> <latest>now</latest> <sampleRatio>1</sampleRatio> </search> <fieldset submitButton="false" autoRun="true"></fieldset> <row depends="$ghost_boo$"> <panel> <html> <style> #modalVizualization { display: flex; !important; } #modalVizualization4 { display: flex; !important; } #nousage .ccat-default_category { fill: rgb(66, 150, 58) !important; stroke: rgb(66, 150, 58) !important; } #usage .ccat-default_category { fill: rgb(173, 47, 47) !important; stroke: rgb(173, 47, 47) !important; } #compare .ccat-Free { fill: rgb(66, 150, 58) !important; stroke: rgb(66, 150, 58) !important; } #compare .ccat-Used { fill: rgb(173, 47, 47) !important; stroke: rgb(173, 47, 47) !important; } #table1 h3.dashboard-element-title { color:white !important; } </style> </html> </panel> </row> <row> <panel> <title>Execution Statistics Filters</title> <input type="dropdown" token="tok_time_range"> <label>Time Range</label> <choice value="-2d@d">2 Days</choice> <choice value="-7d@d">7 Days</choice> <choice value="-30d@d">30 Days</choice> <initialValue>-2d@d</initialValue> <default>-2d@d</default> <change> <condition> <unset token="tok_overlap_time"></unset> </condition> </change> </input> </panel> </row> <row> <panel> <title>Usage Trend</title> <input type="dropdown" token="tok_choice"> <label>Metric</label> <choice value="Active VMs">Active VMs</choice> <choice value="License Usage">License Usage</choice> <default>Active VMs</default> <initialValue>Active VMs</initialValue> <change> <condition> <unset token="tok_overlap_time"></unset> </condition> </change> </input> <chart id="ticket_modal_1"> <search base="base_execution_statistics"> <query>| where _time >= relative_time(now(), "$tok_time_range$") | stats values(execution_ended) as execution_ended values(eval(execution_id."|".execution_host."|".execution_started."|".execution_ended)) as fullid by _time execution_started execution_id execution_host | streamstats time_window=1h values(eval(execution_id."|".execution_host."|".execution_started."|".execution_ended)) as prev_fullid | mvexpand prev_fullid | rex field=prev_fullid "(?<prev_execution_id>.*)\|(?<prev_execution_host>.*)\|(?<prev_execution_started>.*)\|(?<prev_execution_ended>.*)" | fields - fullid prev_fullid | table execution_started execution_ended execution_id execution_host _time * | where strptime(prev_execution_ended,"%Y-%m-%d %H:%M:%S") >= _time | eval overlap = case(execution_id=prev_execution_id,0,execution_started=prev_execution_ended AND execution_host=prev_execution_host,0,execution_started >= prev_execution_started AND execution_started <= prev_execution_ended,1,1=1,0) | stats sum(overlap) as overlap values(execution_host) as execution_host by execution_id _time | timechart span=10m max(overlap) as "Max Overlap" dc(execution_id) as "Active Scripts" dc(execution_host) as "Active VMs" | eval "License Usage" = if(isnull('Max Overlap'),0,'Max Overlap' + 1) | eval "Limit" = `number_of_licenses` | eval "Limit Reached" = if('$tok_choice$'>='Limit','$tok_choice$',null) | fields _time "$tok_choice$" "Limit Reached" | where _time >= relative_time(now(), "$tok_time_range$")</query> </search> <option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option> <option name="charting.axisLabelsX.majorLabelStyle.rotation">0</option> <option name="charting.axisLabelsY.majorUnit">1</option> <option name="charting.axisTitleX.visibility">collapsed</option> <option name="charting.axisTitleY.visibility">collapsed</option> <option name="charting.axisTitleY2.visibility">visible</option> <option name="charting.axisX.abbreviation">none</option> <option name="charting.axisX.scale">linear</option> <option name="charting.axisY.abbreviation">none</option> <option name="charting.axisY.scale">linear</option> <option name="charting.axisY2.abbreviation">none</option> <option name="charting.axisY2.enabled">0</option> <option name="charting.axisY2.scale">inherit</option> <option name="charting.chart">line</option> <option name="charting.chart.bubbleMaximumSize">50</option> <option name="charting.chart.bubbleMinimumSize">10</option> <option name="charting.chart.bubbleSizeBy">area</option> <option name="charting.chart.nullValueMode">gaps</option> <option name="charting.chart.showDataLabels">none</option> <option name="charting.chart.sliceCollapsingThreshold">0.01</option> <option name="charting.chart.stackMode">default</option> <option name="charting.chart.style">shiny</option> <option name="charting.drilldown">all</option> <option name="charting.layout.splitSeries">0</option> <option name="charting.layout.splitSeries.allowIndependentYRanges">0</option> <option name="charting.legend.labelStyle.overflowMode">ellipsisEnd</option> <option name="charting.legend.mode">standard</option> <option name="charting.legend.placement">bottom</option> <option name="charting.lineWidth">2</option> <option name="charting.seriesColors">$green_red$</option> <option name="height">250</option> <option name="refresh.display">progressbar</option> <option name="trellis.enabled">0</option> <option name="trellis.scales.shared">1</option> <option name="trellis.size">medium</option> <drilldown> <condition></condition> </drilldown> </chart> </panel> </row> </form> SplunkBase App https://splunkbase.splunk.com/app/4370/
... View more
06-30-2021
12:35 AM
Hi everyone. I need an help to insert in a Modal View one splunk visualization contained in Event Timeline App. I wrote this code with splunk dev help ticketModalTest.js require([ 'underscore', 'backbone', '../app/Optimus/components/ModalViewTest', 'splunkjs/mvc', 'splunkjs/mvc/searchmanager', 'splunkjs/mvc/simplexml/ready!' ], function(_, Backbone, ModalView, mvc, SearchManager) { var ticket_modal_1 = mvc.Components.get('ticket_modal_1'); var tokens = mvc.Components.getInstance("submitted"); var detailSearch7 = new SearchManager({ id: "detailSearch7", earliest_time: "0", latest_time: "now", preview: true, cache: false, search: "index=optimus_execution_statistics_idx | stats latest(script_name) as script_name latest(execution_status) as execution_status latest(execution_started) as execution_started latest(execution_ended) as execution_ended latest(category_name) as category_name latest(execution_host) as execution_host by _time execution_id | where _time = $tok_snapshot_earliest$ | eval execution_started_unix = strptime(execution_started, \"%Y-%m-%d %H:%M:%S\")| sort limit=0 - execution_started| where _time >= relative_time(now(), \"-2d@d\")| stats values(execution_ended) as execution_ended values(eval(execution_id.\"|\".execution_host.\"|\".execution_started.\"|\".execution_ended)) as fullid by execution_started execution_id execution_host _time script_name execution_status| streamstats max(execution_ended) as execution_ended by execution_id | sort 0 _time| streamstats time_window=1h values(eval(execution_id.\"|\".execution_host.\"|\".execution_started.\"|\".execution_ended.\"|\".script_name)) as prev_fullid| mvexpand prev_fullid| rex field=prev_fullid \"(?<prev_execution_id>.*)\\|(?<prev_execution_host>.*)\\|(?<prev_execution_started>.*)\|(?<prev_execution_ended>.*)\\|(?<prev_script_name>.*)\"| fields - fullid prev_fullid| table execution_started execution_ended execution_id execution_host *| eval overlap = if(execution_started >= prev_execution_started AND execution_started <= prev_execution_ended, 1, 0)| eval cat = prev_execution_id| eval execution_started_unix = strptime(execution_started, \"%Y-%m-%d %H:%M:%S\")| eval execution_ended_unix = strptime(execution_ended, \"%Y-%m-%d %H:%M:%S\")| eval end=if(execution_status=\"In Progress\",now(),execution_ended_unix)| eval exclude=if(execution_started_unix = (relative_time(now(),\"@d\")-1) AND execution_ended_unix=(execution_started_unix-1) AND execution_status=\"Closed\",1,0)| eval start = execution_started_unix| eval color = case(execution_status=\"Closed\" and exclude=\"0\",\"#4FA484\", execution_status=\"Error\",\"#AF575A\", execution_status=\"Restarted\",\"#EC9960\", execution_status=\"In Progress\",\"#006d9c\")| eval group = if(len(substr(prev_execution_host, 8, len(prev_execution_host))) = 1, \"FCACLIP0\" + substr(prev_execution_host, 8, len(prev_execution_host)), \"FCACLIP\" + substr(prev_execution_host, 8, len(prev_execution_host)))| strcat cat \"|\" prev_script_name cat| eval label=cat | sort group| eval tooltip=cat | eval label=null|dedup tooltip | table label start end group color tooltip" },{tokens: true, tokenNamespace: "submitted"}); ticket_modal_1.on("click", function(e) { e.preventDefault(); if(e.data['click.name'] === '_time') { var tok_snapshot_earliest= e.data['click.value']; tokens.set('tok_snapshot_earliest',tok_snapshot_earliest); var _title = tok_snapshot_earliest +"Panels" var modal = new ModalView({ title: _title, search7: detailSearch7 }); modal.show(); } }); }); ModalViewTest.js define([ 'underscore', 'backbone', 'jquery', 'splunkjs/mvc', 'splunkjs/mvc/searchmanager', 'splunkjs/mvc/simplexml/element/table', 'splunkjs/mvc/visualizationregistry' ], function(_, Backbone, $, mvc, SearchManager, TableElement, VisualizationRegistry) { var modalTemplate = "<div id=\"pivotModal2\" class=\"modal\">" + "<div class=\"modal-header\"><h3><%- title %></h3><button class=\"close\">Close</button></div>" + "<div class=\"modal-body\"></div>" + "<div class=\"modal-footer\"></div>" + "</div>" + "<div class=\"modal-backdrop\"></div>"; var ModalView = Backbone.View.extend({ defaults: { title: 'Not set' }, initialize: function(options) { this.options = options; this.options = _.extend({}, this.defaults, this.options); this.childViews = []; console.log('Hello from the modal window: ', this.options.title); this.template = _.template(modalTemplate); }, events: { 'click .close': 'close', 'click .modal-backdrop': 'close' }, render: function() { var data = { title : this.options.title }; this.$el.html(this.template(data)); return this; }, show: function() { $(document.body).append(this.render().el); $(this.el).find('.modal-body').append('<div id="modalVizualizationTest"></div>'); $(this.el).find('.modal').css({ width:'90%', height:'80%', position: 'fixed', right: '0', left: '0', 'margin-right': 'auto', 'margin-left': 'auto', height: '80vh', 'overflow-y': 'auto', }); var customViz = VisualizationRegistry.getVisualizer('event-timeline-viz','event-timeline-viz'); var search7 = mvc.Components.get(this.options.search7.id); var myViz = new customViz({ id: "myViz", managerid: search7.name, drilldown: "none", el: $('modalVizualizationTest'), showPager: false, "link.openSearch.visible": "false", "link.exportResults.visible": "false", "link.inspectSearch.visible": "false", "refresh.link.visible": "false", "showLastUpdated": false }).render(); this.childViews.push(myViz); search7.startSearch(); }, close: function() { this.unbind(); this.remove(); _.each(this.childViews, function(childView) { childView.unbind(); childView.remove(); }); } }); return ModalView; }); Any suggestion about why this code doesn't work? Thanks
... View more
Labels
- Labels:
-
chart
-
drilldown
-
javascript
-
panel
06-22-2021
06:31 AM
ModalView4.js define([ 'underscore', 'backbone', 'jquery', 'splunkjs/mvc', 'splunkjs/mvc/searchmanager', 'splunkjs/mvc/simplexml/element/table', 'splunkjs/mvc/simplexml/element/chart', ], function(_, Backbone, $, mvc, SearchManager, TableElement) { var modalTemplate2 = "<div id=\"pivotModal2\" class=\"modal\">" + "<div class=\"modal-header\"><h3><%- title %></h3><button class=\"close\">Close</button></div>" + "<div class=\"modal-body\"></div>" + "<div class=\"modal-footer\"></div>" + "</div>" + "<div class=\"modal-backdrop\"></div>"; var ModalView4 = Backbone.View.extend({ defaults: { title: 'Not set' }, initialize: function(options) { this.options = options; this.options = _.extend({}, this.defaults, this.options); this.childViews = []; console.log('Hello from the modal window: ', this.options.title); this.template = _.template(modalTemplate2); }, events: { 'click .close': 'close', 'click .modal-backdrop': 'close' }, render: function() { var data = { title : this.options.title }; this.$el.html(this.template(data)); return this; }, show: function() { $(document.body).append(this.render().el); $(this.el).find('.modal-body').append('<div id="modalVizualization2"/>'); $(this.el).find('.modal').css({ width:'40%', height:'50%', position: 'absolute', top: '50%', left: '60%', transform: 'translateX(-50%) translateY(-50%)', 'margin-left': '0', 'max-height':'100%', }); var search1 = mvc.Components.get(this.options.search.id); var detailTable2 = new TableElement({ id: "detailTable2", managerid: search1.name, pageSize: '10', data: "events", drilldown: "none", el: $('#modalVizualization2') }).render(); this.childViews.push(detailTable2); search1.startSearch(); }, close: function() { this.unbind(); this.remove(); _.each(this.childViews, function(childView) { childView.unbind(); childView.remove(); }); } }); return ModalView4; });
... View more
06-22-2021
06:31 AM
Dashboard <dashboard script="app3.js" theme="dark"> <label>Modal Test 2</label> <row> <panel> <chart id="master"> <search> <query>index=_internal sourcetype!="splunkd" | timechart span=6h count by sourcetype</query> <earliest>-24h@h</earliest> <latest>now</latest> <sampleRatio>1</sampleRatio> </search> <option name="charting.chart">column</option> <option name="charting.drilldown">all</option> <option name="refresh.display">progressbar</option> <drilldown> <condition> </condition> </drilldown> </chart> </panel> </row> </dashboard> app3.js require([ 'underscore', '../app/modal_playground/components/ModalView3', 'splunkjs/mvc', 'splunkjs/mvc/searchmanager', 'splunkjs/mvc/simplexml/ready!' ], function(_, ModalView3, mvc, SearchManager) { var master = mvc.Components.get('master'); var tokens = mvc.Components.getInstance("submitted"); var detailSearch = new SearchManager({ id: "detailSearch", earliest_time: "-24h@h", latest_time: "now", preview: true, cache: false, search: "index=_internal sourcetype=$sourcetype$ | timechart count" }, { tokens: true, tokenNamespace: "submitted" }); master.on("click", function(e) { e.preventDefault(); console.log("E", e) if (e.data['click.name'] === "_time") { var _title = e.data['click.name2']; tokens.set('sourcetype', _title); var modal3 = new ModalView3({ title: _title, search: detailSearch }); modal3.show(); } }); }); ModalView3.js define([ 'underscore', 'backbone', 'jquery', 'splunkjs/mvc', 'splunkjs/mvc/searchmanager', '../app/modal_playground/components/ModalView4, 'splunkjs/mvc/simplexml/element/table', 'splunkjs/mvc/simplexml/element/chart', ], function master(_, Backbone, $, mvc, SearchManager, TableElement, ModalView4) { var modalTemplate = "<div id=\"pivotModal\" class=\"modal\">" + "<div class=\"modal-header\"><h3><%- title %></h3><button class=\"close\">Close</button></div>" + "<div class=\"modal-body\"></div>" + "<div class=\"modal-footer\"></div>" + "</div>" + "<div class=\"modal-backdrop\"></div>"; var ModalView3 = Backbone.View.extend({ defaults: { title: 'Not set' }, initialize: function(options) { this.options = options; this.options = _.extend({}, this.defaults, this.options); this.childViews = []; console.log('Hello from the modal window: ', this.options.title); this.template = _.template(modalTemplate); }, events: { 'click .close': 'close', 'click .modal-backdrop': 'close' }, render: function() { var data = { title : this.options.title }; this.$el.html(this.template(data)); return this; }, show: function() { $(document.body).append(this.render().el); $(this.el).find('.modal-body').append('<div id="modalVizualization"/>'); $(this.el).find('.modal').css({ width:'40%', height:'50%', position: 'absolute', top: '50%', left: '20%', transform: 'translateX(-20%) translateY(-50%)', 'margin-left': '0', 'max-height':'100%', }); var search = mvc.Components.get(this.options.search.id); var detailTable = new TableElement({ id: "detailTable", managerid: search.name, pageSize: '10', data: "events", drilldown: "row", el: $('#modalVizualization') }).render(); var detailTable = mvc.Components.get('pivotModal'); var tokens1 = mvc.Components.getInstance("submitted") var drilldownSearch = SearchManager({ id="drilldownSearch", preview = false, cache = false, search: "|makeresults |eval string=\"This is drilldown for time; \".$_time$" },{ tokens1: true, tokenNamespace: "submitted"}); detailTable.on("click:row", function(e) { e.preventDefault(); if (e.data['click.name'] === "_time") { var _title = "Drilldown Example"; tokens1.set('_time', 'click.value'); var modal4 = new ModalView4({ title: _title, search: drilldownSearch }); modal4.show(); }; }) this.childViews.push(detailTable); search.startSearch(); }, close: function() { this.unbind(); this.remove(); _.each(this.childViews, function(childView) { childView.unbind(); childView.remove(); }); } }); return ModalView3; });
... View more
06-21-2021
09:30 AM
Thanks for the answer KV, but unfortunately it seems not to work! 😔
... View more
06-16-2021
06:22 AM
Hi everyone I have this dashboard with this simple xml code <dashboard script="app3.js" theme="dark"> <label>Modal Test 2</label> <row> <panel> <chart id="master"> <search> <query>index=_internal sourcetype!="splunkd" | timechart span=6h count by sourcetype</query> <earliest>-24h@h</earliest> <latest>now</latest> <sampleRatio>1</sampleRatio> </search> <option name="charting.chart">column</option> <option name="charting.drilldown">all</option> <option name="refresh.display">progressbar</option> <drilldown> <condition> </condition> </drilldown> </chart> </panel> </row> </dashboard> When I click on chart, it shows a modal popup like this one: I'm triying to show a second modal by drilldown this modal. The following is the splunkjs script I wrote app3.js ModalView3.js ModalView4.js But it doesn't work! Any suggestions?
... View more
Labels
- Labels:
-
drilldown
-
javascript
-
simple XML
06-07-2021
05:17 AM
<search id="base"> <query>| loadjob savedsearch="tkt_aide_orchestrator:ticket_aide:ticket_aide_master" | fillnull value=`get_null_value` |search $tok_permissions$ | search $tok_company$ $tok_contract$ $tok_contact_type$ $tok_service$ $tok_element$ $tok_category$ $tok_subcategory$ $tok_type$ $tok_queue$</query> </search> <fieldset submitButton="false"> <input type="multiselect" token="tok_company" depends="$tok_show_all$" id="input1"> <label>$lbl_company$</label> <choice value="*">All</choice> <default>*</default> <initialValue>*</initialValue> <fieldForLabel>$lbl_company$</fieldForLabel> <search> <query>| loadjob savedsearch="tkt_aide_orchestrator:ticket_aide:ticket_aide_master" | fillnull value=`get_null_value` company |search $tok_permissions$ | stats count by company | fields company |rename company as $lbl_company$</query> <earliest>0</earliest> <latest></latest> </search> <change> <unset token="form.tok_snapshot"></unset> <unset token="form.tok_trend_overlay"></unset> <unset token="form.tok_open_dimension"></unset> <unset token="tok_l11_show_backlog_table"></unset> <unset token="tok_show_trend_table"></unset> <unset token="tok_export"></unset> </change> <prefix>(</prefix> <suffix>)</suffix> <valuePrefix>company="</valuePrefix> <valueSuffix>"</valueSuffix> <delimiter> OR </delimiter> <fieldForValue>$lbl_company$</fieldForValue> </input> <input type="multiselect" token="tok_contract" depends="$tok_show_all$"> <label>$lbl_contract$</label> <choice value="*">All</choice> <default>*</default> <initialValue>*</initialValue> <fieldForLabel>$lbl_contract$</fieldForLabel> <search> <query>| loadjob savedsearch="tkt_aide_orchestrator:ticket_aide:ticket_aide_master" | fillnull value=`get_null_value` contract |search $tok_permissions$ | stats count by contract | fields contract | rename contract as "$lbl_contract$"</query> <earliest>0</earliest> <latest></latest> </search> <change> <unset token="form.tok_snapshot"></unset> <unset token="form.tok_trend_overlay"></unset> <unset token="form.tok_open_dimension"></unset> <unset token="tok_l11_show_backlog_table"></unset> <unset token="tok_show_trend_table"></unset> <unset token="tok_export"></unset> </change> <prefix>(</prefix> <suffix>)</suffix> <valuePrefix>contract="</valuePrefix> <valueSuffix>"</valueSuffix> <delimiter> OR </delimiter> <fieldForValue>$lbl_contract$</fieldForValue> </input> <input type="multiselect" token="tok_contact_type" depends="$tok_show_all$"> <choice value="*">All</choice> <label>$lbl_contact_type$</label> <default>*</default> <initialValue>*</initialValue> <fieldForLabel>$lbl_contact_type$</fieldForLabel> <fieldForValue>$lbl_contact_type$</fieldForValue> <search> <query>| loadjob savedsearch="tkt_aide_orchestrator:ticket_aide:ticket_aide_master" | fillnull value=`get_null_value` contact_type |search $tok_permissions$ | stats count by contact_type | fields contact_type | rename contact_type as "$lbl_contact_type$"</query> <earliest>0</earliest> <latest></latest> </search> <change> <unset token="form.tok_snapshot"></unset> <unset token="form.tok_trend_overlay"></unset> <unset token="form.tok_open_dimension"></unset> <unset token="tok_show_backlog_table"></unset> <unset token="tok_show_trend_table"></unset> <unset token="tok_export"></unset> <unset token="tok_show_table"></unset> <unset token="tok_table_state_filter"></unset> </change> <prefix>(</prefix> <suffix>)</suffix> <valuePrefix>contact_type="</valuePrefix> <valueSuffix>"</valueSuffix> <delimiter> OR </delimiter> </input> <input type="multiselect" token="tok_service" depends="$tok_show_all$"> <label>$lbl_service$</label> <choice value="*">All</choice> <default>*</default> <initialValue>*</initialValue> <fieldForLabel>$lbl_service$</fieldForLabel> <fieldForValue>$lbl_service$</fieldForValue> <search> <query>| loadjob savedsearch="tkt_aide_orchestrator:ticket_aide:ticket_aide_master" | fillnull value=`get_null_value` service |search $tok_permissions$ | stats count by service | fields service | rename service as "$lbl_service$"</query> <earliest>0</earliest> <latest></latest> </search> <change> <unset token="tok_export"></unset> <unset token="tok_l11_show_backlog_table"></unset> </change> <prefix>(</prefix> <suffix>)</suffix> <valuePrefix>service="</valuePrefix> <valueSuffix>"</valueSuffix> <delimiter> OR </delimiter> </input> <input type="multiselect" token="tok_element" depends="$tok_show_all$"> <label>$lbl_element$</label> <choice value="*">All</choice> <default>*</default> <initialValue>*</initialValue> <fieldForLabel>$lbl_element$</fieldForLabel> <fieldForValue>$lbl_element$</fieldForValue> <search> <query>| loadjob savedsearch="tkt_aide_orchestrator:ticket_aide:ticket_aide_master" | fillnull value=`get_null_value` element |search $tok_permissions$ | stats count by element | fields element | rename element as "$lbl_element$"</query> <earliest>0</earliest> <latest></latest> </search> <change> <unset token="tok_export"></unset> <unset token="tok_l11_show_backlog_table"></unset> </change> <prefix>(</prefix> <suffix>)</suffix> <valuePrefix>element="</valuePrefix> <valueSuffix>"</valueSuffix> <delimiter> OR </delimiter> </input> <input type="multiselect" token="tok_category" depends="$tok_show_all$"> <label>$lbl_category$</label> <choice value="*">All</choice> <default>*</default> <initialValue>*</initialValue> <fieldForLabel>$lbl_category$</fieldForLabel> <fieldForValue>$lbl_category$</fieldForValue> <search> <query>| loadjob savedsearch="tkt_aide_orchestrator:ticket_aide:ticket_aide_master" | fillnull value=`get_null_value`category |search $tok_permissions$ | stats count by category | fields category | rename category as "$lbl_category$"</query> <earliest>0</earliest> <latest></latest> </search> <change> <unset token="tok_export"></unset> <unset token="tok_l11_show_backlog_table"></unset> </change> <prefix>(</prefix> <suffix>)</suffix> <valuePrefix>category="</valuePrefix> <valueSuffix>"</valueSuffix> <delimiter> OR </delimiter> </input> <input type="multiselect" token="tok_subcategory" depends="$tok_show_all$"> <label>$lbl_subcategory$</label> <choice value="*">All</choice> <default>*</default> <initialValue>*</initialValue> <fieldForLabel>$lbl_subcategory$</fieldForLabel> <fieldForValue>$lbl_subcategory$</fieldForValue> <search> <query>| loadjob savedsearch="tkt_aide_orchestrator:ticket_aide:ticket_aide_master" | fillnull value=`get_null_value` subcategory |search $tok_permissions$ | stats count by subcategory | fields subcategory | rename subcategory as "$lbl_subcategory$"</query> <earliest>0</earliest> <latest></latest> </search> <change> <unset token="tok_export"></unset> <unset token="tok_l11_show_backlog_table"></unset> </change> <prefix>(</prefix> <suffix>)</suffix> <valuePrefix>subcategory="</valuePrefix> <valueSuffix>"</valueSuffix> <delimiter> OR </delimiter> </input> <input type="multiselect" token="tok_type" depends="$tok_show_all$"> <label>$lbl_type$</label> <choice value="*">All</choice> <default>*</default> <initialValue>*</initialValue> <fieldForLabel>$lbl_type$</fieldForLabel> <fieldForValue>$lbl_type$</fieldForValue> <search> <query>| loadjob savedsearch="tkt_aide_orchestrator:ticket_aide:ticket_aide_master" | fillnull value=`get_null_value` type |search $tok_permissions$ | stats count by type | fields type | rename type as "$lbl_type$"</query> <earliest>0</earliest> <latest></latest> </search> <change> <unset token="tok_export"></unset> <unset token="tok_l11_show_backlog_table"></unset> </change> <prefix>(</prefix> <suffix>)</suffix> <valuePrefix>type="</valuePrefix> <valueSuffix>"</valueSuffix> <delimiter> OR </delimiter> </input> <input type="multiselect" token="tok_queue" depends="$tok_show_all$"> <label>$lbl_queue$</label> <choice value="*">All</choice> <default>*</default> <initialValue>*</initialValue> <fieldForLabel>$lbl_queue$</fieldForLabel> <fieldForValue>$lbl_queue$</fieldForValue> <search> <query>| loadjob savedsearch="tkt_aide_orchestrator:ticket_aide:ticket_aide_master" | fillnull value=`get_null_value` queue |search $tok_permissions$ | stats count by queue | fields queue | rename queue as "$lbl_queue$"</query> <earliest>0</earliest> <latest></latest> </search> <change> <unset token="tok_export"></unset> <unset token="tok_l11_show_backlog_table"></unset> </change> <prefix>(</prefix> <suffix>)</suffix> <valuePrefix>queue="</valuePrefix> <valueSuffix>"</valueSuffix> <delimiter> OR </delimiter> </input> </fieldset> <row> <panel depends="$tok_show_all$"> <single> <search base="base"> <query>| search state_group="Open" OR state_group="Pending" | stats count</query> </search> <option name="drilldown">all</option> <option name="rangeColors">["0x53a051","0x0877a6","0xf8be34","0xf1813f","0xdc4e41"]</option> <option name="underLabel">Tickets in Backlog</option> <drilldown> <condition match="tok_l1_show_backlog == "*""> <unset token="tok_l1_show_backlog"></unset> <unset token="tok_l11_show_backlog_table"></unset> </condition> <condition> <set token="tok_l1_show_backlog">*</set> <set token="form.tok_trend_overlay">backlog</set> <set token="form.tok_snapshot">-30d@d</set> <unset token="tok_l11_show_backlog_table"></unset> <unset token="tok_l1_show_aging"></unset> </condition> </drilldown> </single> </panel> </row> <row depends="$tok_l1_show_backlog$"> <panel depends="$tok_show_all$" id="master"> <input type="dropdown" token="tok_snapshot"> <label>Snapshots</label> <choice value="@w1">Week to date</choice> <choice value="-7d@d">Last 7 days</choice> <choice value="-30d@d">Last 30 days</choice> <choice value="-90d@d">Last 90 days</choice> <choice value="@mon">Month to date</choice> <choice value="-6mon@mon">Last 6 months</choice> <choice value="-12mon@mon">Last 12 months</choice> <choice value="@y">Year to date</choice> <choice value="-y@y">2 Years to date</choice> <choice value="-20y@y">All data</choice> <change> <condition value="@w1"> <set token="tok_snapshot_span">d</set> <unset token="tok_l11_show_backlog_table"></unset> </condition> <condition value="-7d@d"> <set token="tok_snapshot_span">d</set> <unset token="tok_l11_show_backlog_table"></unset> </condition> <condition value="-30d@d"> <set token="tok_snapshot_span">d</set> <unset token="tok_l11_show_backlog_table"></unset> </condition> <condition value="-90d@d"> <set token="tok_snapshot_span">d</set> <unset token="tok_l11_show_backlog_table"></unset> </condition> <condition value="@mon"> <set token="tok_snapshot_span">d</set> <unset token="tok_l11_show_backlog_table"></unset> </condition> <condition value="-6mon@mon"> <set token="tok_snapshot_span">mon</set> <unset token="tok_l11_show_backlog_table"></unset> </condition> <condition value="-12mon@mon"> <set token="tok_snapshot_span">mon</set> <unset token="tok_l11_show_backlog_table"></unset> </condition> <condition value="@y"> <set token="tok_snapshot_span">mon</set> <unset token="tok_l11_show_backlog_table"></unset> </condition> <condition value="-20y@y"> <set token="tok_snapshot_span">mon</set> <unset token="tok_l11_show_backlog_table"></unset> </condition> </change> <default>-30d@d</default> <initialValue>-30d@d</initialValue> </input> <input type="dropdown" token="tok_trend_overlay"> <label>Overlay</label> <choice value="backlog">Backlog</choice> <choice value="bpe">BPE</choice> <default>backlog</default> <initialValue>backlog</initialValue> <change> <unset token="tok_l11_show_backlog_table"></unset> </change> </input> <chart> <search base="base"> <query>| search $tok_l1_show_backlog$ (state_group="Open" OR state_group="Pending" OR state_group="Resolved" OR state_group="Closed") | eval created_flag = if((state_group="Open" OR state_group="Pending" OR state_group="Resolved" OR state_group="Closed"),1,0) | eval resolved_flag = if((state_group="Resolved" OR state_group="Closed"),1,0) | eval marker = case(created_ym=resolved_ym,1,1=1,0) | eval list = mvappend("created|".created_ymd."|".created_flag, "resolved|".resolved_ymd."|".resolved_flag) | fields list | mvexpand list | rex field=list "(?<action>\w+)\|(?<time>\d+)\|(?<count>\d)" | fields time action count | chart sum(count) as count over time by action | fillnull value=0 created resolved | eval backlog = created - resolved | streamstats sum(backlog) as backlog | eval _time = strptime(time,"%Y%m%d") | where _time >= relative_time(now(),"$tok_snapshot$") OR resolved_e >= relative_time(_time,"$tok_snapshot$") | timechart span=$tok_snapshot_span$ sum(created) as created sum(resolved) as resolved last(backlog) as backlog | eval bpe = if(created=0 OR resolved=0, 0.00,round(resolved/created,2)) | table _time created resolved $tok_trend_overlay$ | filldown $tok_trend_overlay$</query> </search> <option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option> <option name="charting.axisLabelsX.majorLabelStyle.rotation">0</option> <option name="charting.axisTitleX.visibility">collapsed</option> <option name="charting.axisTitleY.visibility">visible</option> <option name="charting.axisTitleY2.visibility">visible</option> <option name="charting.axisX.abbreviation">none</option> <option name="charting.axisX.scale">linear</option> <option name="charting.axisY.abbreviation">none</option> <option name="charting.axisY.scale">linear</option> <option name="charting.axisY2.abbreviation">none</option> <option name="charting.axisY2.enabled">1</option> <option name="charting.axisY2.scale">inherit</option> <option name="charting.chart">column</option> <option name="charting.chart.bubbleMaximumSize">50</option> <option name="charting.chart.bubbleMinimumSize">10</option> <option name="charting.chart.bubbleSizeBy">area</option> <option name="charting.chart.nullValueMode">gaps</option> <option name="charting.chart.overlayFields">bpe,backlog</option> <option name="charting.chart.showDataLabels">none</option> <option name="charting.chart.sliceCollapsingThreshold">0.01</option> <option name="charting.chart.stackMode">default</option> <option name="charting.chart.style">shiny</option> <option name="charting.drilldown">all</option> <option name="charting.layout.splitSeries">0</option> <option name="charting.layout.splitSeries.allowIndependentYRanges">0</option> <option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option> <option name="charting.legend.mode">standard</option> <option name="charting.legend.placement">bottom</option> <option name="charting.lineWidth">2</option> <option name="refresh.display">progressbar</option> <option name="trellis.enabled">0</option> <option name="trellis.scales.shared">1</option> <option name="trellis.size">medium</option> <drilldown> <condition></condition> </drilldown> </chart> </panel> </row>
... View more
06-07-2021
02:55 AM
ModalView.js define([ 'underscore', 'backbone', 'jquery', 'splunkjs/mvc', 'splunkjs/mvc/searchmanager', 'splunkjs/mvc/simplexml/element/table', "splunkjs/mvc/chartview" ], function(_, Backbone, $, mvc, SearchManager, TableElement, ChartView) { var modalTemplate = "<div id=\"pivotModal\" class=\"modal\">" + "<div class=\"modal-header\"><h3><%- title %></h3><button class=\"close\">Close</button></div>" + "<div class=\"modal-body\"></div>" + "<div class=\"modal-footer\"></div>" + "</div>" + "<div class=\"modal-backdrop\"></div>"; var ModalView = Backbone.View.extend({ defaults: { title: 'Not set' }, initialize: function(options) { this.options = options; this.options = _.extend({}, this.defaults, this.options); this.childViews = []; console.log('Hello from the modal window: ', this.options.title); this.template = _.template(modalTemplate); }, events: { 'click .close': 'close', 'click .modal-backdrop': 'close' }, render: function() { var data = { title : this.options.title }; this.$el.html(this.template(data)); return this; }, show: function() { $(document.body).append(this.render().el); $(this.el).find('.modal-body').append('<div id="modalVizualization"/>'); $(this.el).find('.modal').css({ width:'90%', height:'auto', left: '5%', 'margin-left': '0', 'max-height':'100%' }); var search = mvc.Components.get(this.options.search.id); var detailTable = new TableElement ({ id: "detailTable", managerid: search.name, pageSize: "5", el: $('#modalVizualization') }).render(); this.childViews.push(detailTable); search.startSearch(); }, close: function() { this.unbind(); this.remove(); _.each(this.childViews, function(childView) { childView.unbind(); childView.remove(); }); } }); return ModalView; });
... View more
06-07-2021
02:53 AM
Hi everyone I need to insert this search into a modal popup to visualize this table |loadjob savedsearch:"tkt_aide_orchestrator:ticket_aide:ticket_aide_master" | fillnull value="#N/A" |search $tok_permissions$ | search $tok_company$ $tok_contract$ $tok_contact_type$ $tok_service$ $tok_element$ $tok_category$ $tok_subcategory$ $tok_type$ $tok_queue$ | search (state_group="Open" OR state_group="Pending" OR state_group="Resolved" OR state_group="Closed") | where (created_e >= relative_time($tok_trend_time$,"@$tok_snapshot_span$") AND created_e < relative_time($tok_trend_time$,"+$tok_snapshot_span$@$tok_snapshot_span$")) OR (resolved_e >= relative_time($tok_trend_time$,"@$tok_snapshot_span$") AND resolved_e < relative_time($tok_trend_time$,"+$tok_snapshot_span$@$tok_snapshot_span$")) | table id state priority queue assigned_to created resolved" I wrote this two codes app.js require([ 'underscore', 'backbone', '../app/ticket_aide/components/ModalView', 'splunkjs/mvc', 'splunkjs/mvc/searchmanager', 'splunkjs/mvc/simplexml/ready!', 'splunkjs/mvc/savedsearchmanager', 'splunkjs/mvc/postprocessmanager', 'splunkjs/mvc/chartview', 'splunkjs/mvc/simplexml/element/table' ], function(_, Backbone, ModalView, mvc, SearchManager, SavedSearchManager, PostProcessManager) { var master = mvc.Components.get('master'); var tokens=mvc.Components.get("default"); tokens.on("change:created_lower_bound", function(created_lower_bound) { tokens.set('created_lower_bound',created_lower_bound) }); tokens.on("change:created_upper_bound", function(created_upper_bound) { tokens.set('created_upper_bound',created_upper_bound) }); tokens.on("change:tok_company", function(tok_company) { tokens.set('ton_company',tok_company) }); tokens.on("change:tok_contract", function(tok_contract) { tokens.set('tok_contract',tok_contract) }); tokens.on("change:tok_contact_type", function(tok_contact_type) { tokens.set('tok_contact_type',tok_contact_type) }); tokens.on("change:tok_service", function(tok_service) { tokens.set('tok_service',tok_service) }); tokens.on("change:tok_element", function(tok_element) { tokens.set('tok_element',tok_element) }); tokens.on("change:tok_category", function(tok_category) { tokens.set('tok_category',tok_category) }); tokens.on("change:tok_subcategory", function(tok_subcategory) { tokens.set('tok_subcategory',tok_subcategory) }); tokens.on("change:tok_type", function(tok_type) { tokens.set('tok_type',tok_type) }); tokens.on("change:tok_queue", function(tok_queue) { tokens.set('tok_queue',tok_queue) }); tokens.on("change:tok_permissions", function(tok_permissions) { tokens.set('tok_permissions',tok_permissions) }); tokens.on("change:tok_snapshot_span", function(tok_snapshot_span) { token.set('tok_snapshot_span',tok_snapshot_span) }); var mysavedsearch= new SavedSearchManager ({ id: "mysavedsearch", searchname: "ticket_aide_master", app: "ticket_aide" }) var detailSearch = new PostProcessManager({ id: "detailSearch", managerid: mysavedsearch, preview: false, cache: false, search: "| fillnull value=\"#N/A\" |search $tok_permissions$ | search $tok_company$ $tok_contract$ $tok_contact_type$ $tok_service$ $tok_element$ $tok_category$ $tok_subcategory$ $tok_type$ $tok_queue$ | search (state_group=\"Open\" OR state_group=\"Pending\" OR state_group=\"Resolved\" OR state_group=\"Closed\") | where (created_e >= relative_time($tok_trend_time$,\"@$tok_snapshot_span$\") AND created_e < relative_time($tok_trend_time$,\"+$tok_snapshot_span$@$tok_snapshot_span$\")) OR (resolved_e >= relative_time($tok_trend_time$,\"@$tok_snapshot_span$\") AND resolved_e < relative_time($tok_trend_time$,\"+$tok_snapshot_span$@$tok_snapshot_span$\")) | table id state priority queue assigned_to created resolved" },{tokens: true}); master.on("click", function(e) { e.preventDefault(); console.log("E",e); if(e.data['click.value'] === "_time") { var _title= e.data['click.value'] tokens.set('tok_trend_time',_title) var modal=new ModalView({ title: _title, search: detailSearch }) modal.show(); }; }); }); But this code doesn't work and i'm not able to find any error or issue. Any suggestions? Thx
... View more
Labels
- Labels:
-
chart
-
drilldown
-
javascript
-
panel
-
simple XML
06-04-2021
08:26 AM
It works, but maybe i didn't explain well what I have to do I would to show in the modal view a table that is a details table for the column that I click on the column chart
... View more
06-04-2021
05:35 AM
Thanks for your answer, unfortunately it seems doesn't working Maybe is helpful for you to know that the chart that I've posted is a drilldown and this drilldown need to pass some tokens to the table in the modal view First Panel Drilldown
... View more
06-03-2021
10:33 AM
Hi everyone I found a javascript code that show a table drilldown in a modal window. I'm trying to adapt this one to this column chart When I click on one of these bars, it could be represented a table with event details. I wrote this two codes app.js require([ 'underscore', 'backbone', '../app/ticket_aide/components/ModalView', 'splunkjs/mvc', 'splunkjs/mvc/searchmanager', 'splunkjs/mvc/simplexml/ready!', 'splunkjs/mvc/savedsearchmanager', 'splunkjs/mvc/postprocessmanager' ], function(_, Backbone, ModalView, mvc, SearchManager, SavedSearchManager, PostProcessManager) { var master = mvc.Components.get('master'); var tokens = mvc.Components.getInstance("submitted"); var mysavedsearch= new SavedSearchManager ({ id: "MyReport", searchname: "ticket_aide_master", app: "ticket_aide" }) var detailSearch = new PostProcessManager({ id: "detailSearch", managerid: "MyReport", search: mvc.tokenSafe("| fillnull value=\"#N/A\" |search $tok_permissions$ | search $tok_company$ $tok_contract$ $tok_contact_type$ $tok_service$ $tok_element$ $tok_category$ $tok_subcategory$ $tok_type$ $tok_queue$| search (state_group=\"Open\" OR state_group=\"Pending\" OR state_group=\"Resolved\" OR state_group=\"Closed\") | where (created_e >= relative_time($tok_trend_time$,\"@$tok_snapshot_span$\") AND created_e < relative_time($tok_trend_time$,\"+$tok_snapshot_span$@$tok_snapshot_span$\")) OR (resolved_e >= relative_time($tok_trend_time$,\"@$tok_snapshot_span$\") AND resolved_e < relative_time($tok_trend_time$,\"+$tok_snapshot_span$@$tok_snapshot_span$\")) | table id state priority queue assigned_to created resolved") }, {tokens: true, tokenNamespace: "submitted"}); master.on("click", function(e) { e.preventDefault(); if(e.field === "_time") { var _title = e.data['click.value']; tokens.set('_time', _title); var modal = new ModalView({ title: _title, search: detailSearch }); modal.show(); } }); }); ModalView.js define([ 'underscore', 'backbone', 'jquery', 'splunkjs/mvc', 'splunkjs/mvc/searchmanager', 'splunkjs/mvc/simplexml/element/table' ], function(_, Backbone, $, mvc, SearchManager, TableElement) { var modalTemplate = "<div id=\"pivotModal\" class=\"modal\">" + "<div class=\"modal-header\"><h3><%- title %></h3><button class=\"close\">Close</button></div>" + "<div class=\"modal-body\"></div>" + "<div class=\"modal-footer\"></div>" + "</div>" + "<div class=\"modal-backdrop\"></div>"; var ModalView = Backbone.View.extend({ defaults: { title: 'Not set' }, initialize: function(options) { this.options = options; this.options = _.extend({}, this.defaults, this.options); this.childViews = []; console.log('Hello from the modal window: ', this.options.title); this.template = _.template(modalTemplate); }, events: { 'click .close': 'close', 'click .modal-backdrop': 'close' }, render: function() { var data = { title : this.options.title }; this.$el.html(this.template(data)); return this; }, show: function() { $(document.body).append(this.render().el); $(this.el).find('.modal-body').append('<div id="modalVizualization"/>'); $(this.el).find('.modal').css({ width:'90%', height:'auto', left: '5%', 'margin-left': '0', 'max-height':'100%' }); var search = mvc.Components.get(this.options.search.id); var detailTable = new TableElement({ id: "detailTable", managerid: search.name, pageSize: "5", el: $('#modalVizualization') }).render(); this.childViews.push(detailTable); search.startSearch(); }, close: function() { this.unbind(); this.remove(); _.each(this.childViews, function(childView) { childView.unbind(); childView.remove(); }); } }); return ModalView; }); Anyone could help me to find what is wrong and how to make it works, please??
... View more
Labels
- Labels:
-
chart
-
drilldown
-
javascript
-
token
06-03-2021
03:42 AM
It doesn't work for me with your correction. Where have you put your scripts?
... View more
06-03-2021
03:18 AM
Hi everyone!
I found these JavaScript to visualize drill down search in a modal window App.js
require([
'underscore',
'backbone',
'../app/Splunk-Modal-Window/components/ModalView',
'splunkjs/mvc',
'splunkjs/mvc/searchmanager',
'splunkjs/mvc/simplexml/ready!'
], function(_, Backbone, ModalView, mvc, SearchManager) {
var master = mvc.Components.get('master');
var tokens = mvc.Components.getInstance("submitted");
var detailSearch = new SearchManager({
id: "detailSearch",
earliest_time: "-24h@h",
latest_time: "now",
preview: true,
cache: false,
search: "index=_internal sourcetype=$sourcetype$ | timechart count"
}, {tokens: true, tokenNamespace: "submitted"});
master.on("click", function(e) {
e.preventDefault();
if(e.field === "sourcetype") {
var _title = e.data['click.value'];
tokens.set('sourcetype', _title);
var modal = new ModalView({ title: _title, search: detailSearch });
modal.show();
}
});
}); ModalView.js
define([
'underscore',
'backbone',
'jquery',
'splunkjs/mvc',
'splunkjs/mvc/searchmanager',
'splunkjs/mvc/simplexml/element/table'
], function(_, Backbone, $, mvc, SearchManager, TableElement) {
var modalTemplate = "<div id=\"pivotModal\" class=\"modal\">" +
"<div class=\"modal-header\"><h3><%- title %></h3><button class=\"close\">Close</button></div>" +
"<div class=\"modal-body\"></div>" +
"<div class=\"modal-footer\"></div>" +
"</div>" +
"<div class=\"modal-backdrop\"></div>";
var ModalView = Backbone.View.extend({
defaults: {
title: 'Not set'
},
initialize: function(options) {
this.options = options;
this.options = _.extend({}, this.defaults, this.options);
this.childViews = [];
console.log('Hello from the modal window: ', this.options.title);
this.template = _.template(modalTemplate);
},
events: {
'click .close': 'close',
'click .modal-backdrop': 'close'
},
render: function() {
var data = { title : this.options.title };
this.$el.html(this.template(data));
return this;
},
show: function() {
$(document.body).append(this.render().el);
$(this.el).find('.modal-body').append('<div id="modalVizualization"/>');
$(this.el).find('.modal').css({
width:'90%',
height:'auto',
left: '5%',
'margin-left': '0',
'max-height':'100%'
});
var search = mvc.Components.get(this.options.search.id);
var detailTable = new TableElement({
id: "detailTable",
managerid: search.name,
pageSize: "5",
el: $('#modalVizualization')
}).render();
this.childViews.push(detailTable);
search.startSearch();
},
close: function() {
this.unbind();
this.remove();
_.each(this.childViews, function(childView) {
childView.unbind();
childView.remove();
});
}
});
return ModalView;
}); Splunk dashboard xml <dashboard script="app.js"> <label>Modal Demo</label> <row> <panel> <table id="master"> <title>Master</title> <search> <query>index=_internal | stats count by sourcetype</query> <earliest>-60m@m</earliest> <latest>now</latest> </search> <!-- Set the type of of drilldown, since we will always consume the same field, use row--> <option name="drilldown">row</option> </table> </panel> </row> </dashboard> I'm a beginner in the javascript world and I'm not able to find the error in this code. Does anyone have a suggestion? Thanks
... View more
- Tags:
- dashboard
Labels
- Labels:
-
drilldown
-
javascript
-
panel
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
07-04-2025
07:52 AM
|
