edit: I don't know what the label "7 - Data Storage" means or why it is there - this is about visualization.Looking for a way to ensure that colors for categories are consistent across charts, to greatly improve the user experience.For example, if I ...
Hi @DRay @Liliia_DevX ,I am curious: if a customer wants to have a formula in the second indicator widget not affected by the dashboard filters, how would one go about doing this?My solution would be:COUNT(coloumn_name, ALL(dim_value))Would this be c...
Hello: I've been exploring a few ways to modify values contained in Table and Pivot Table widgets using the script editor. While I have successfully been able to modify the widget in my browser, when I export the data to CSV or Excel, I'm still getti...
What order do dashboard events fire in?What order to widget events fire in?Dashboard events:initializedrefreshstartrefreshendwidgetrefreshedwidgetaddedstylechangeddestroyededitstarteditendfilterschangedwidgetinitializedwidgetbuildquerywidgetbeforeque...
Gradient Conditional Formatting In Pivot TablesI found this article in Sisense Community, and I want to replicate the same for a pivot table as given in the post .But I was informed we can't do this in the latest version of Sisense. Can we somehow st...
How do I allow users to subscribe themselves (or others in their agency) to any report to get emailed? How can I support this without them seeing all users in Sisense given that Sisense user is in a single-tenant system? @DRay
Hi,I have a table with test cases (testcase_key, Type), cycles (cycle1, cycle2, ...), and executions (test_result, execution_timestamp).Scenario: A test can be executed multiple times within one cycle, and the same test case can also be executed in ...
Either with python or native features? @DRay
Hi,Recently upgraded to Sisense Linux which required updating some syntax of API calls. Managed to get the exporting call working, however, having an issue with the "paperFormat" parameter. Pre-upgrade I was able to use "paperFormat": "letter" to exp...
Hello, I'd like to add trend lines to a line chart (like this) but based on the data existing in the chart.For example the benchmark line would be 5% higher than CVR1 and the Target line would be 6.5% higher than CVR1, this would be moving week on we...
Hi @DRay, @Liliia_DevX ,I am wondering how the SSO flow is working under the hood with the Compose SDK SisenseContextProvider. Looking for in-depth knowledge of the SSO flow in SPA apps?
Hi,I'd like to create a Box & Whisker Plot to show the distribution of "Bookings" by "Day of Week" across the time period so the client/tenant should be able to see, for example, that on Mondays their bookings can range from 150 to 325 but there are ...
I used this formula to get days from creation to deactivation.DDiff([Days in Client Last Deactivated On],[Days in Client Creation Date])What formula can I use to obtain days from creation to current date/now?I only have designer access to Sisense and...
Hello! I have the following formula that I keep on getting an error message on, and I'm not sure why:MIN(DDIFF([Days in Invoice Billing End Date],[Days in Invoice Line Item Service Date]),DDIFF([Days in Invoice Line Item Service Date],[Days in Invoic...
In a table or pivot table widget I want to concatenate strings contained in two separate data model columns. Example: col1 contains "Abraham" and col2 contains "Lincoln". I want to concatenate them, along with a space to display "Abraham Lincoln" in ...
