Hi, I have a list of tasks and their start and end date in an index. And list of holidays in a lookup file. I want to find the difference between start and end date. Also this should exclude the day if there are any holidays in between start and end date. Task Start End Days A 5-Jan-20 5-Feb-20   B 15-Jan-20 5-Mar-20   C 1-Apr-20 30-Apr-20     Holidays: 1-Jan-20 27-Jan-20 10-Apr-20 11-Apr-20 12-Apr-20 13-Apr-20 .... Am currently during this using appendcols and mv commands which is making it very slow. Am looking for a direct/easier/perf optimized  solution | appendcols [ inputlookup Holidays.csv | tableHolidays ] | reverse | eventstats list(Holidays) as Holidays delim="|" | nomv Holidays | eval between= mvrange(start, end, "1d"), date_diff = strftime(between,"%d/%m/%y %H:%M:%S") | mvexpand date_diff | where NOT match(date_diff, Holidays) | stats list(date_diff) AS date_diff BY tasks ... View more

Hi, I am looking forward to create a bubble chart like this: https://www.highcharts.com/demo/bubble, where I can click and drag your mouse pointer to make a box in the chart. Every value in the box inside the chart, I would be able to pass them as filters to subsequent charts. In the case of the link (https://www.highcharts.com/demo/bubble), you can select a bunch of bubbles (countries) and these countries should act as filters to subsequent charts. Any help? Note: I can do drilldown from one chart to another chart based on a single bar selected (in case of bar chart). I am more interested in the multiselect. Example in D3js: https://observablehq.com/@d3/brushable-scatterplot-matrix https://bl.ocks.org/mthh/e9ebf74e8c8098e67ca0a582b30b0bf0 ... View more

Hi, I would like to change the default chart colors template for all my charts in my app. I know we can chart for each chart using "charting.seriesColors". However, I am looking for any settings or conf file changes so that all my charts in my dashboard and all new charts will follow the new template colors. ... View more

I have created a bubble chart with X-axis value, Y-axis value and Bubble size. Each row is unique and they have a category name. Now I want to display the category name as the legend for each of the bubble. Sample Data: Region|ProductCount|Sales|Profit North|10|1000|200 South|20|2000|250 East|15|1000|150 West|15|1000|300 X-axis = ProductCount Y-axis = Sales Bubble Size = Profit I got until this. But I am not able to get Region as legend/color. The below code works without 'Region' in the table. index=foo | stats sum(ProductCount) as ProductCount, sum(Sales) as Sales, sum(Profit) as Profit by Region | table Region, ProductCount, Sales, Profit ... View more

I have data like below, TaskName - Status Task 1 - New Task 1 - Running Task 1 - Running Task 1 - Pause Task 1 - Running Task 1 - Done I want the output to be, New(1) - Running(2) - Pause(1) - Running(1) - Done(1). I was able to get New - Running - Running - Pause - Running - Done with the below query, index="default" | stats list(status) as status delim=" - " by task | nomv status ... View more