I have a colleague who needs to filter a dashboard on a very specific time period - from 08:00 yesterday morning to 08:00 this morning.They don't need/want all of yesterday before 08:00 or any of today after 08:00.I've tried playing about with the cu...
Is it possible to have color text invert based on cell highlight color? We have conditional formatting on some cells that create a rather dark highlight and makes the default dark text unreadable. We would like the text color to invert based on cell ...
Hello @DRay @Liliia_DevX @harikm007 ,I saw @harikm007 other post about adding tooltip information to bar chart, column chart, etc, but I was wondering if there was code out there to add it to a pie chart (https://community.sisense.com/t5/build-analy...
Hi all,Wondering if I'm missing something when it comes to using a Pivot. Is there a reason why the last column is always blank here? It doesn't matter which order I rearrange these values, the last one is always blank. I've created another pivot usi...
I am attempting to add a textblock to my Blox KPI with a calculated value. The objective is for the total value to stay the same as a point of comparison, while the user applies filters.In this example, the count changes as the user applies filters. ...
Attempting to create a filtered value by editing the formula. I want to see Count of total people for where risk is high.Field 1: People (All peoples name linked to a risk group)Field 2: Risk Group (High, Medium, Low) COUNT([People], [Risk_Group])I r...
I am trying to have the Break By Update the title of the Switchable Dimension rather than dimension.My script goes as follows. prism.registerSwitchDimension({ widget: widget, widgetTitleTemplate: "{{val}} By {{dim}}", // Dynamically updates ...
I am building a bar chart show actual vs target number. And in my actual number, I am using a conditional color if it is over the target then show yellow if not show blue here. After I added the conditional color on the "Actual sale" value, the legen...
I am using this solution from @intapiuser: https://community.sisense.com/t5/knowledge-base/change-date-granularity-of-a-widget-using-blox/ta-p/8916 to try and get a widget that this BloX affects to update the title of the widget. Attached is the imag...
A customer may want to pass a filter value using the URL (as a parameter). A common case could be when an external system launches a dashboard and wants it to default to a specific value.The following script allows you to parse the parameters receive...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
I have a colleague who needs the ability to compare string values across two fields to assess whether or not they're identical (simple example in excel below). I've not been able to find any documentation on this & would be grateful for assistance.
data of one week means Sunday to Saturday I want but it gives as Thursday of every week on X axis as belowIt is helpful if it can be at least Sunday's date on X axis and weekly data captures .
Does anybody know if regex is an option in Sisense custom tables? Can't find any documentation and it's not listed in available functions. I know I can use it in MySQL tables, but having it in custom tables will be very useful.We are using Sisense Cl...
I have a stakeholder who would like to selectively turn off the markers on line graphs for certain lines.As in the attached image, they want to remove the markers on the dashed lines, but keep them for the solid line. I can't find anything in the doc...
