Liliia_DevX
Sisense Employee
Joined 03-02-2023
User Profile
User Widgets
Contributions
Re: The New Sisense Support Portal is Now Live! 🚀
francoisvv hi! We've checked the issue and found out that an email with a code was sent successfully. Could you please check with your IT/security team if it could have been blocked by the security settings? Please update me on the result.11Views1like0CommentsRe: The New Sisense Support Portal is Now Live! 🚀
Hi francoisvv , Please accept our apologies for this inconvenience. We're working on the fix of this issue. Please send an email to mailto:[email protected] to create a ticket and reply to the support team back via email for now. Thanks for your patience and understanding.21Views1like1CommentRe: How to create a week date range with start and end if the week for each week?
Hi, It should be possible to add custom columns in the model for the start and end dates and concatenate them into a string to use as the dimension. Otherwise, swap 'beforeviewloaded' for onBeforeRender prop in CSDK and use the same logic to manipulate highcharts options. Hope that helps :)38Views0likes0CommentsRe: How to create a week date range with start and end if the week for each week?
Hi :) Please try this approach suggested by OleksiiDemianyk. On the client you need to: Add 6 days to each date returned by Sisense; Change category from the default one to the ${startWeekDate} - ${startWeekDate + 7 days} This can be done on the event beforeviewloaded. Here is the sample where we have week as the only category: const months = { 1: 'Jan', 2: 'Feb', 3: 'Mar', 4: 'Apr', 5: 'May', 6: 'Jun', 7: 'Jul', 8: 'Aug', 9: 'Sep', 10: 'Oct', 11: 'Nov', 12: 'Dec' }; widget.on('beforeviewloaded', (scope, args) => { const [ seria ] = args.options.series; seria.data.forEach((point, index) => { const startDate = formatDate(point.selectionData[0]); const endDate = formatDate(new Date( new Date(point.selectionData[0]).getTime() + 6 * 24 * 60 * 60000), true); args.options.xAxis.categories[index] = `${startDate} - ${endDate}`; }) }) function formatDate( dateItem, returnYear = false ) { const [ year, monthIndex, date ] = dateItem.toISOString().substr(0, 10).split('-'); const monthString = months[parseInt(monthIndex)]; return returnYear ? `${date} ${monthString} ${year}` : `${date} ${monthString}`; } Hope that helps!105Views0likes2CommentsRe: Querying Model in Text Widgets?
Astroraf Hi 🙃, According to our dev team, there is no need to query data inside a text widget. Instead, load the data with a separate useExecuteQuery hook (example on playground). You can also render this data in any format anywhere on the page. If you need to inject a new widget to the existing dashboard on the fly, you can add a new widget (e.g., TextWidget with a static data-string) like in this example. Even a better option is to create your own custom widget (example) with any data visualization you need. CustomWidget is a much more powerful and flexible solution and is a direct replacement for the BloX plugin in the Sisense native application. Hope that helps!68Views1like2CommentsRe: How to create a filter within a widget?
Hi Astroraf ! It might be possible to use Blox to create buttons with filters instead of the drop-down like in this guide: https://community.sisense.com/kb/blox/changing-measures-in-the-entire-dashboard-using-blox-user-interface/8802/comments/26261#M3953 It's changing values but I believe that similar logic could be used for your case. Anyway it will be still a separate widget.38Views0likes0CommentsRe: JumpToDashboard - Troubleshooting the most common configuration issues
Hi Astroraf! Please try to use resetDashFilterAfterJTD to reset filters on your JTD dashboards after jumping to them. It might be a spelling issue. If it's not, please raise a support ticket providing parent and drill dashboards examples along with the JumpToDashboard configuration for us to review :)45Views2likes0Comments