Harry
Cloud Apps
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Widget to display time
One simple method to fins widget id is, open Script Editor window of the Text Widget and copy widget id from URL. In below screenshot, widget ID is highlighted in yellow color Please let me know if have any questions Always here to help, Harry from QBeeQ harry.km@qbeeq.pl QBeeQ - Gold Implementation and Development Partner www.qbeeq.pl3.2KViews0likes2CommentsRe: Widget to display time
Hello R1 , One solution is to add a Text widget to dashboard and add below dashboard script. In the script, update the variable 'filterName' with name of Country filter, 'textWidgetID' with ID of Text widget and 'countryTimeZoneMapping' with area-time zone name mapping dashboard.on('filterschanged', function(se, ev){ displayTime(se) }) dashboard.on('widgetready', function(se, ev){ displayTime(se) }) function displayTime(se){ let filterName = 'Country' //update the name of country filter let textWidgetID = '6380c6426bc7f50039bf366b' //update widget-id of text widget let selectedCountry = '' //update area-timezone mapping let countryTimeZoneMapping = { 'Brazil':'America/Sao_Paul', 'France':'Europe/Paris', 'Canada':'America/New_York', 'India':'Asia/Calcutta' } let filterObject = se.filters.$$items.find(el=>el.jaql.title == filterName) if(filterObject && filterObject.jaql.filter && filterObject.jaql.filter.members) selectedCountry = filterObject.jaql.filter.members[0] let dateString = new Date().toLocaleString('en-US', { timeZone: countryTimeZoneMapping[selectedCountry]}); $(`widget[widgetid="${textWidgetID}"] richtexteditor .wd`).text(dateString) } Please let me know if have any questions Always here to help, Harry from QBeeQ harry.km@qbeeq.pl QBeeQ - Gold Implementation and Development Partner www.qbeeq.pl3.2KViews2likes5CommentsRe: JTD - BLOX: script to include and exclude filters
Hello Srav_Sense , Try adding dimensions in excludeFilterDims and includeFilterDims as array. For example: "excludeFilterDims": [ "[TableName.ColumnName1]", "[TableName.ColumnName2]" ], "includeFilterDims": [ "[TableName.ColumnName3]", "[TableName.ColumnName4]" ] Please let me know if you have any questions Always here to help, Harry from QBeeQ harry.km@qbeeq.pl QBeeQ - Gold Implementation and Development Partner www.qbeeq.pl3.9KViews2likes0CommentsRe: Blox - Action button - Hover options
Hello DamianC , You can add hover effect to Blox button by adding CSS in "style" key as below "style": ".blox-slides button:hover{background-color:red!important}", Blox script for Action button would be { "type": "ActionSet", "actions": [ { "type": "Filters", "title": "Apply", "style": { "backgroundColor": "blue" } } ] } Please let me know if you have any questions Always here to help, Harry from QBeeQ harry.km@qbeeq.pl QBeeQ - Gold Implementation and Development Partner www.qbeeq.pl3.5KViews3likes1CommentRe: RSUM with Display Missing as Zero
Hello wallingfordce , Try this widget script. (update the variable 'panelName' with name of panel with RSUM calculation) widget.on('processresult', function(se, ev){ var panelName = 'RSUM(Total Quantity (1))' var series = ev.result.series.find(el => el.name == panelName) var prevValue = series.data[0].y $.each(series.data, function(index, value){ if(value.y == null) value.y = prevValue else prevValue = value.y }) }) Please let me know if you have any questions Always here to help, Harry from QBeeQ harry.km@qbeeq.pl QBeeQ - Gold Implementation and Development Partner www.qbeeq.pl4KViews1like2CommentsRe: How to Left-Align tabber text?
Hello gayatrishahane , Here is a widget script to align tabs to left widget.on('ready',function(w, e) { $('.listDefaultCSS', element).css('text-align', 'left') }) Please let me know if you have any questions Always here to help, Harry from QBeeQ harry.km@qbeeq.pl QBeeQ - Gold Implementation and Development Partner www.qbeeq.pl3.3KViews0likes1CommentRe: How can we show previous 12 month on selecting a particular month in filter
Hello rahuldhomane , You can try below widget script to display previous 12 months of data from selected month. Here update the variable 'monthFilterName' with name of your filter. widget.on("beforequery", function(se,ev) { var monthFilterName = "Months in Date of Joining"; var numberofPrevMonths = 10 monthFilter = ev.query.metadata.find(el => el.jaql.title == monthFilterName && el.panel == 'scope') if(monthFilter) { prevMonth = new Date(monthFilter.jaql.filter.members[0]) for(i = 1; i < numberofPrevMonths; i++) { prevMonth = new Date(prevMonth.setMonth(prevMonth.getMonth()-1)) preMonthStr = prevMonth.getFullYear() + '-' + ('0' + (prevMonth.getMonth()+1)).slice(-2) + "-01T00:00:00" //prevMonth.toISOString(); monthFilter.jaql.filter.members.unshift(preMonthStr) } } }); Also if you add Date Range Slider plugin, it will give you an option to select any date range in addition to previous 12 months. Please let me know if you have any questions Always here to help, Harry from QBeeQ harry.km@qbeeq.pl QBeeQ - Gold Implementation and Development Partner www.qbeeq.pl4.1KViews0likes2CommentsRe: Ignore the Dashboard filter for one of the columns
Hello Srav_Sense , You can ignore a filter in formula using 'All' function. For example, if you want find total amount, but by ignoring date filter, the formula would be: (COUNT([AMOUNT]), ALL([DATE])) Note: the granularity of date in filter and formula should be same. i.e. If filter is showing months, 'Months in Date' should be selected in formula. Here is the documentation about the function: https://documentation.sisense.com/docs/function-references#all Please let me know if you have any questions Always here to help, Harry from QBeeQ harry.km@qbeeq.pl www.qbeeq.pl4.4KViews1like0CommentsRe: Highlight Max and Min values of a Line chart using JS or Formula
Hello nazeer475 , Using below script you can highlight min and max value in a line chart. You can use different styles for min and max labels. widget.on('processresult', function(se, ev) { maxItem = Math.max.apply(Math, ev.result.series[0].data.map(function(el) { return el.y; })) minItem = Math.min.apply(Math, ev.result.series[0].data.map(function(el) { return el.y; })) maxfilterItems = ev.result.series[0].data.filter(el => el.y == maxItem) minfilterItems = ev.result.series[0].data.filter(el => el.y == minItem) $.each(maxfilterItems, function(index, value) { value.dataLabels = { borderColor: 'green', color: 'green', borderWidth: 1, borderRadius: 3, padding: 3, style: { fontWeight: 'bold' } } }) $.each(minfilterItems, function(index, value) { value.dataLabels = { borderColor: 'red', color: 'red', borderWidth: 1, borderRadius: 3, padding: 3, style: { fontWeight: 'bold' } } }) }) Please let me know if you have any questions Always here to help, Harry from QBeeQ harry.km@qbeeq.pl www.qbeeq.pl1.5KViews0likes0CommentsRe: Interval on X-axis labels on Chart
Hello gayatrishahane , You can limit the labels in X-axis using below script. This script shows every 10th label in X-axis. widget.on('processresult', function(se, ev){ ev.result.xAxis.tickInterval = 10 }) Please let me know if you have any questions Always here to help, Harry from QBeeQ harry.km@qbeeq.pl www.qbeeq.pl2.6KViews1like1Comment