harikm007
Data Warehouse
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: How to add different colours to each row in pivot table?
Hi JennyW , If I understand it correctly, you need to color the Pivot Table's rows based on the content of a date field. If a row contains 'Monday', a certain color should be applied, and if it contains 'Tuesday', a different color should be set. If that's the case, please try the script provided below. This script will work if the date field is the first column in the table. const dayColorMapping = { 'sunday': '#9cbff7', 'monday': '#ee9cf7', 'tuesday': '#f79cba', 'wednesday': '#9cebf7', 'thursday': '#abf79c', 'friday': '#f7f49c', 'saturday': '#f79c9c' } const weekday = ["sunday","monday","tuesday","wednesday","thursday","friday","saturday"]; const dateColumnIndex = 0; widget.transformPivot( { }, function setCellBackground(metadata, cell) { if(metadata.rowIndex > 0){ const date = new Date(metadata.rows[dateColumnIndex].member); const day = weekday[date.getDay()]; if(day in dayColorMapping) { cell.style.backgroundColor = dayColorMapping[day]; } } } ); Result: Let me know if that works! - HariRe: 👋 Welcome! Let’s Get to Know Each Other!
Hi, I’m Hari from Kerala, India. I work as a Business Intelligence Analyst at Helm Operations, where we help manage maritime fleets. Outside of work, I enjoy spending time with family and friends, and I’m into running and cycling. 🚴♂️🏃♂️ Looking forward to connecting with others and learning more in this community!Re: CommunityFest 2025 Day 4: How has Sisense made your day-to-day work easier or more impactful?
Sisense has definitely made my day-to-day work easier and more efficient. Data analysis is incredibly quick. When I get new data in a CSV or Excel file, I can load it straight into an Elasticube and start building widgets right away, instead of having to upload everything to a database and write queries from scratch. Pulse has also been a huge help. Instead of checking dashboards every day to see if values exceed certain thresholds, the alerts keep me proactively informed. It saves time and ensures nothing important slips through the cracks.Re: 🎢 CommunityFest Day 3: Step right up and show off your skills! 🎪
Interactive Body Pain Intensity Map This Blox visualization is an interactive Body Pain Intensity Map, designed to show which parts of the body experience the most discomfort or strain. Each red bubble represents a specific body region, and the size of the bubble corresponds to the level of pain or impact intensity - the larger the bubble, the higher the reported pain in that area. The numbers inside the labels quantify that intensity, providing a clear comparison between different regions. What makes this chart interactive is that each number is clickable, allowing users to filter by clicking on numbers. This visualization helps users quickly identify problem areas and analyze how pain or impact is distributed across the body.Re: Filter to only show Relevant Dimension Values
Hi Laflet , We can do it using 'Custom' option in the dashboard filter. By default, when you use a field from a Dimension table, Sisense shows all values from that table, even those not linked to any fact records. Add below jaql in the 'Custom' option of the filter and apply. Then set it as background filter. Here, replace [fact_table.Id] with the table name and field name of your fact table column. { "attributes": [ { "dim": "[fact_table.Id]", "filter": { "exclude": { "members": [ "N\\A" ] } } } ] } Please let me know if you have any questions -HariRe: Querying Model in Text Widgets?
Hi As you know, the Text widget in Sisense doesn’t allow adding dimensions or measures directly, so there’s no built-in way to display dynamic values like {Total Revenue} out of the box. However, this can be achieved using a small custom script. Here’s one approach you can try: Create a Text Widget and add your desired text in the widget, for example: This year revenue: {Total Revenue}. We’ll use a script to replace {Total Revenue} with the actual value from your model. Add the following script to your widget: widget.on('domready', function(w, args){ const textToReplace = '{Total Revenue}' const result = getMeasure(args.widget); args.widget.style.content.html = args.widget.style.content.html.replace(textToReplace, result.values[0].text); }) function getMeasure(widget) { const query = { "datasource": widget.datasource, "metadata": [ { "jaql": { "type": "measure", "formula": "[3DDF8-AEA]", "context": { "[3DDF8-AEA]": { "table": "sales_revenue", "column": "amount", "dim": "[sales_revenue.amount]", "datatype": "numeric", "columnTitle": "amount", "tableTitle": "sales_revenue", "agg": "sum", "title": "sum of amount" } }, "title": "[sum of amount]", "columnTitle": "[sum of amount]" } } ] }; return runHTTP(query); } function runHTTP(jaql) { const $internalHttp = prism.$injector.has("base.factories.internalHttp") ? prism.$injector.get("base.factories.internalHttp") : null; const ajaxConfig = { url: "/api/datasources/" + encodeURIComponent(jaql.datasource.title) + "/jaql", method: "POST", data: JSON.stringify(jaql), contentType: "application/json", dataType: "json", async: false }; const httpPromise = $internalHttp ? $internalHttp(ajaxConfig, true) : $.ajax(ajaxConfig); return httpPromise.responseJSON; }; Replace the value of textToReplace with the placeholder text you want to replace in your widget. In the script above, replace the query object with the JAQL you want to execute. If you need to use a more complex calculation, you can get the exact JAQL by creating a temporary Indicator Widget and adding your formula in the Primary panel. Then, in your browser console, run: prism.activeWidget.metadata.panels[0].items[0].jaql Copy the JAQL object from the console output and use it in query variable in the script. Then, save the script and refresh the dashboard. Result: If you prefer a simpler, no-code approach, you can use the Paldi Advanced Text Widget plugin. It allows you to: - Add rich text, images, and HTML content - Display dynamic values and dimensions directly - Avoid custom scripting This is often the most efficient and flexible solution for dynamic text in dashboards. https://www.paldi.solutions/sisense-plugins/advanced-text-widget Please let me know if you have any questions -HariRe: How to make Switchable Dimension with Radio Buttons
Hi Astroraf , Hope the script below works for you! Blox script: { "title": "", "style": "", "script": "", "showCarousel": true, "body": [ { "type": "Container", "class": "radiotval-dimswitch", "items": [ { "type": "Input.ChoiceSet", "id": "radiotVal", "displayType": "expanded", "choices": [ { "title": "Total Revenue", "value": "0" }, { "title": "Total Quantity", "value": "1" } ] } ] } ], "actions": [] } Also add below widget script to the blox widget. Here add ids of target widgets to widgetids array. widget.on('domready',function(widget, args){ widgetIds = ['68ffba3fa3420a7cd45d34feb', '68ffba47aa380a7cd27d34fed']; const radios = document.querySelectorAll('.radiotval-dimswitch input'); refWidget = prism.activeDashboard.widgets.$$widgets.find(w => w.oid === widgetIds[0]); if (refWidget.metadata.panels[1].$$widget.type == 'indicator') { defaultPanel = refWidget.metadata.panels[0].items[0].jaql.title; } else { defaultPanel = refWidget.metadata.panels[1].items[0].jaql.title; } defaultMeasureIndex = widget.metadata.panels[1].items.findIndex(i=>i.jaql.title === defaultPanel); radios.forEach(radio => { radio.checked = (radio.value == defaultMeasureIndex); }); radios.forEach(r => r.addEventListener('change', e => { dimToSwapTo = widget.metadata.panels[1].items[event.target.value].jaql; switchMeasure(dimToSwapTo) })); }) function switchMeasure(dimToSwapTo){ prism.activeDashboard.widgets.$$widgets .filter(i => widgetIds.includes(i.oid)) .forEach(function (widget) { if (widget.metadata.panels[1].$$widget.type == 'indicator') { widget.metadata.panels[0].items[0].jaql = dimToSwapTo; } else { widget.metadata.panels[1].items[0].jaql = dimToSwapTo; } widget.changesMade('plugin-BloX', 'metadata'); widget.refresh(); }) } Result: Please let me know if you have any questions -Hari https://www.binextlevel.com/
