ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: How to capture clicked metric value from a Pie Chart using Compose SDK? Hi midhun_e WidgetById has a prop named onDataPointClick, it should do what you want. onDataPointClick={(point: DataPoint ) => { console.log('Data Point Clicked:', point.categoryValue); }} Let us know if it works for you Thanks Steve Re: Embedded Dashboard - Failure on load hi nmilya please could you raise a support ticket for this one, since we don't want to ask for further troubleshooting data to be posted in a public forum. if you can include on the ticker a HAR file containing the captured network traffic from the browser while reproducing this problem, that could help the team. If I had to take a wild guess, it would be to ensure you're not also setting ssoEnabled=true on the SisenseContextProvider, but our support team can help futher. Thanks Steve Re: Fetching full dashboard definitions efficiently Hi merrittMelker I think the 3rd option in your list may be your best shot. This is how we do it inside Compose SDK e.g useGetDashboardModel In terms of network traffic efficiency, on the first call you may also include a fields list so only the ones you need for using in your code are returned e.g. /api/v1/dashboards/{dashboardId}?fields=oid,title,datasource,filters Hope that helps Steve Re: Get a list of Datasets in an elasticube with ComposeSDK Hi francoisvv We're hoping to add some things in future that could make some of this easier, but for now if you're using React then you can try using useFetch with /api/datasources/<modelname>/fields/search API Here's a quick / basic example, hope it helps import { useFetch } from "@sisense/sdk-ui"; import { measureFactory } from "@sisense/sdk-data"; const CodeExample = () => { const { data, isLoading, error } = useFetch<unknown, Error>( "api/datasources/Sample%20ECommerce/fields/search", { method: "POST", body: JSON.stringify({ offset: 0, count: 50, }), } ); data && console.log(data); return ( <> {data && data.map((row) => ( <p> Table: {row.table}, Dim: {row.id}, Title: {row.title} </p> ))} </> ); }; export default CodeExample; Re: compose sdk aggregated Table widget expand collapse feature Hi apillai Currently the built in Table components do not have this feature. We encourage submitting this idea to the product feedback section too, there other community members can upvote this idea which helps us prioritize. Meanwhile you could explore using the query API (in react: useExecuteQuery) to get the data and pass to your own visualization component(s). We'll add this to the list of backlog of ideas for the Compose SDK Playground code examples, too. Thanks! Steve Re: Retrieving total count and paginating large datasets with Compose SDK Hi herajapakse Thanks for the detailed post and clear explanation of what you're trying to achieve. Unfortunately, as David mentioned, getting the total row count of a query while only requesting a limited amount of rows is not currently supported. We have investigated the situation and are waiting on an enhancement from the backend API which would enable us to request the total number of rows. Previously it has been suggested you could execute a separate query to count the number of rows instead of the aggregation you want in the paginated results, but it may not be a reliable solution for all cases. For now you can implement paged queries with count and offset, just without the total row count at this time. Steve Re: Help with connecting to Sisense instance hi herajapakse You shouldn't use API Tokens like this in production, for the reasons you state. We're going to update our docs soon to reflect this more strongly. Most customers use Single Sign On (sso) for embedded use cases, and the Sisense platform has built in support for this (not specific to Compose SDK, but holistically). If SSO is configured for Sisense, then your Compose SDK configuration is pretty simple, just set ssoEnabled = true as documented here https://sisense.dev/guides/sdk/getting-started/authentication-security.html#single-sign-on There are links from there to documentation on how to configure SSO on the Sisense platform side, and if you want to use your existing application as an identity provider then you should check out the basics on making a JWT handler that could be served from your application and have Sisense call that whenever someone is trying to authenticate with Sisense https://sisense.dev/guides/accessSecurity/jwt/ This can sometimes be a topic that reads more complicated than it actually is, so feel free to reach out to your customer success representative or support if you need some clarification on what to do. FYI I don't think suggestion #2 below is relevant, since it's talking about JDBC connections, which is something else. Thanks Steve Re: Sunburst Chart issue Hi MikeGre Can you please share any screen capture / GIF of where the subsequent clicks are not working? Do you see any errors in the browser console (developer tools?) Also I want to highlight a feature of the sunburst which can be less obvious initially, that when you hover over a segment a white border appears and this is not part of the clickable area, so where you have lots of very small segments it is easy to miss - the mouse cursor (hand vs pointer) should let you know when you're in the right spot in this case. Sharing this knowledge in case it's relevant, but appreciate it might not be the issue. Thanks Steve Re: Sorting Chart By Different Field Than The One Displayed Hi ewoytowitz I noticed your question was about sorting in Compose SDK, so offering an alternative solution. It should be possible by first running the query, then after results are returned, choosing which columns in the result to map to the chart (e.g. not all of them). There's an example of useExecuteQuery with sorting here https://www.sisense.com/platform/compose-sdk/playground/?example=queries%2Fuse-execute-query-sorting It's sorted by Year, then by revenue. You could imagine your eventCode as the year column in the example, with the sorting applied, and you only use the other columns in the chart mapping. Example of mapping query results to a chart (instead of a table) here https://www.sisense.com/platform/compose-sdk/playground/?example=queries%2Fuse-execute-query We will try to produce a more targeted example for this use case in future, thanks for the inspiration! Steve Re: Help with filterFactory.dateRange Hi ewoytowitz Can you try adding .Days to your dimension to select a specific date level? e.g. DM.SeasonCalendar.CalendarDate.Days I think then it should work, if you use a date format like yyyy-MM-DD .. for example filters: [filterFactory.dateRange(Ecom.Commerce.Date.Days, '2013-04-01', '2013-04-28')] Hope that helps! Steve