User Profile

Astroraf

Data Pipeline

Joined 2 years ago

155 Posts33 Likes12 Solutions

View All Badges

User Widgets

Contributions

Re: How to display two different Values from two different years within the same month range?
Hi DRay I solved this by making the Month column a text field with leading zero for sorting purposes: 01 Jan, 02, Feb, 03 March, 04 April etc. Then I just inputted the two values for 2024 and 2025.
09-18-2025 Place Help and How-To
13Views
1like
0Comments
How to display two different Values from two different years within the same month range?
I want to display the Months from Jan to Dec. for two separate values. The image below shows what I am trying to achieve. I want a count for 2025 and I want a count for 2024. I have this my spread sheet but I was currious that if my datatype is a datetime rather then a text, is there a way to achieve this in Sisense DRay Liliia_DevX
Solved
09-15-2025 Place Help and How-To
dashboards & reporting
24Views
0likes
2Comments
Re: How to create a filter within a widget?
zach_myt https://www.binextlevel.com/post/filter-dropdown-in-widget this is the link, but if it doesn't work use zach_myt link then search filter dropdown in his articles.
09-09-2025 Place Help and How-To
17Views
1like
0Comments
Re: How to create a filter within a widget?
I found a solution: https://www.binextlevel.com/post/filter-dropdown-in-widget, use his first comment to create the solution.
09-09-2025 Place Help and How-To
73Views
0likes
0Comments
Re: Custom Filtering to allow users to filter for specific zip codes
For anyone interested we would be happy to walk through our solution, please contact me at [email protected]
09-09-2025 Place Help and How-To
5Views
0likes
1Comment
Re: How to create a filter within a widget?
DRayLiliia_DevX not sure if both of you have ever seen this done in Sisense before
09-09-2025 Place Help and How-To
25Views
0likes
0Comments
How to create a filter within a widget?
I know there are ways of creating custom filters with BloX, where we can pinpoint to a widget we want to affect but is there any solutions out there to have a filter WITHIN a widget? I provided some images of what I want to achieve.
Solved
09-09-2025 Place Help and How-To
Code-first Analytics
dashboards & reporting
75Views
0likes
7Comments
Re: BloX Template: Indicators With Sparkline
Hi DRay , Unfortunately this does not help. I am looking into the what kind of charts can be made available in the sparkline. There isn't clear documentation on what charts are made available. Is it just line, bar, and pie?
08-28-2025 Place Blox
18Views
0likes
1Comment
Re: BloX Template: Indicators With Sparkline
intapiuser DRay is there a document showing all the different "types" of sparkline graphs you can showcase? I saw Pie chart was an option from a client of mine but haven't found any documentation regarding what are the available charts/stylization to it.
08-28-2025 Place Blox
19Views
0likes
0Comments
Re: How to target a specific cell/column to change the column in a pivot table?
Solved the issue: The order of the scripts and then us // 1) Color the column's sub-header cell (row-1 "member"): widget.transformPivot( { type: ['member'], // header cells axis: 'columns', // match column members columns: [{ dim: '[Program_Assessment_Response_Question.Program_Assessment_Question_Version_Name]', members: ['Activity date for billable time'] }] }, function (metadata, cell) { cell.style = cell.style || {}; cell.style.backgroundColor = '#e6f4ea'; // light green cell.style.borderRadius = '4px'; cell.style.textAlign = 'center'; // keeps it centered } ); // 2) Color all value cells under that column: widget.transformPivot( { type: ['value'], // data cells columns: [{ dim: '[Program_Assessment_Response_Question.Program_Assessment_Question_Version_Name]', members: ['Activity date for billable time'] }] }, function (metadata, cell) { cell.style = cell.style || {}; cell.style.backgroundColor = '#e6f4ea'; cell.style.borderRadius = '4px'; } ); (function () { // Same dimension you used for "Activity date for billable time" var DIM = '[Program_Assessment_Response_Question.Program_Assessment_Question_Version_Name]'; // The four column headers to color var MEMBERS = [ 'CM Assessment/Interview', 'CM Screening and Evaluation', 'Contact with Family Member', 'Contact with Member' ]; // Light blue var COLOR = '#dbeafe'; // tweak if you want a different shade function paintCell(_, cell) { cell.style = cell.style || {}; cell.style.backgroundColor = COLOR; cell.style.borderRadius = '4px'; } // 1) Color the column header (member cells on the columns axis) widget.transformPivot( { type: ['member'], axis: 'columns', columns: [{ dim: DIM, members: MEMBERS }] }, paintCell ); // 2) Color all data cells under those columns widget.transformPivot( { type: ['value'], columns: [{ dim: DIM, members: MEMBERS }] }, paintCell ); })(); /*--------------------*/ (function () { // Text shown in the top header (row-0) var TOP_LABEL = 'Program Activity Time'; // Scope to this widget only var root = (widget.$$container?.[0] || widget.$container?.[0] || widget.container || document); function centerTopHeader() { // find the row-0 header cell whose text matches TOP_LABEL var tds = root.querySelectorAll('.table-grid.table-grid--top td.table-grid__cell--row-0'); var col = null; for (var i = 0; i < tds.length; i++) { var td = tds[i]; var text = td.querySelector('.table-grid__content div')?.innerText?.trim() || ''; if (text === TOP_LABEL) { var cls = Array.prototype.slice.call(td.classList).find(function (c) { return c.indexOf('table-grid__cell--col-') === 0; }); if (cls) col = +cls.split('--col-')[1]; break; } } if (col == null) return; // center ONLY that top header cell’s content var nodes = root.querySelectorAll( '.table-grid.table-grid--top td.table-grid__cell--row-0.table-grid__cell--col-' + col + ' .table-grid__content' ); nodes.forEach ? nodes.forEach(centerEl) : Array.prototype.forEach.call(nodes, centerEl); } function centerEl(el) { el.style.setProperty('display', 'flex', 'important'); el.style.setProperty('justify-content', 'center', 'important'); el.style.setProperty('align-items', 'center', 'important'); el.style.setProperty('text-align', 'center', 'important'); } // run after the pivot paints function run() { setTimeout(centerTopHeader, 0); } widget.on && widget.on('domready', run); widget.on && widget.on('ready', run); widget.on && widget.on('refresh', run); // tiny retry in case the grid mounts a bit later (function tick(n){ if (n <= 0) return; if (!root.querySelector('.table-grid')) return void setTimeout(function(){ tick(n-1); }, 150); run(); })(30); // re-apply if the grid re-renders its header DOM var grid = root.querySelector('.sisense-pivot__multi-grid') || root; if (window.MutationObserver && grid) { var mo = new MutationObserver(function (m) { for (var i=0;i<m.length;i++) { if (m[i].addedNodes.length || m[i].removedNodes.length) { centerTopHeader(); break; } } }); mo.observe(grid, { childList: true, subtree: true }); } })();
08-21-2025 Place Help and How-To
0Views
0likes
0Comments

Groups

Sisense Intelligence Feedback Group
This group is dedicated to improving Sisense Intelligence through feedback and collaboration.
5 Posts