Ravid_PaldiTeam
Cloud Apps
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: How to find overlapping datetime for two different entries
Hi RobertToumbs Another question, do you need that number to be dynamic? Or in simple terms, do you need your users to be able to apply filters on the dasboards that would remove some of the events and then get a new value that trepresnets the overlaps without the filtered events? Assuming yes, then your best route in high level, would be to: - Generate an Indicator widget. It doesn't realy matter which formula you set for it so you can keep it a static 1 - Create Python script that would be used as a Custom Code Transoformation (CCT) script: - When you set a CCT for a widget, Sisense would essentialy execute that script on the server and execute it on the widget's original query result and then it returns the scripts output to the widget. You can pass the dasboard filter selection as addtional paramters to the script - So the idea is that you would essentially write a CCT script that would build a simpel JAQL that would rertieve all the events ordered by their timestampe and then you would process each data point by their order only for the events that had happened within the followign 72 hours. - I reccomend moving the date to be a numeric date in epoc seconds as it would signficantly improve your perofmance and simplify your script. - Make sure to remember to apply the dashboard filters when you pull the initital data set that needs to be processed. - Based on the numbers that you have provided, I believe that even for 10K records the CCT script won't take more then 30-40 seconds to load tops (if written properly). I didn't find the official documents for the CCT but note that this is a fairly advacned topic in Sisense and you also need to ask your admin to enable that feature for your Sisense server: Good luck and let me know how it goes (: Ravid Paldi Solutions - Gold Certiefied Sisense Parneter ravid@paldi.solutionsRe: How to find overlapping datetime for two different entries
Hi RobertToumbs This is achivable but requires some coding to be done . Below are a ew questions that would help in prividing you a direction to where and how you can achieve this: - What is the maximal numner of rows that the Incidents table would need to process? (10 |100 |1000 |10K...?) - Can you make an assumption on the "maximal duration of an event"? (for example, an event would never take more then 24 hours) - I'm guessing that you have designer access to build your dashboards but do you have data designer access as well to make changes to the data model? Looking forward, Ravid Paldi Solutions - Gold Certiefied Sisense Parneter ravid@paldi.solutionsRe: How to hide column in data export?
Hi DXC To the bestd of my knowledge, there is no way to apply cusotmizations on the native Excel/CSV exports so there is no way to hide a column from thsoe exports. With the above being said, both our export and pivot/tables plugins support this option as a built feature and From which branch of DXC are you? Perhaps you are from a branch that already uses our plugins and then I'll simply hop on a call to show you how it works. Looking forward, Ravid Paldi Solutions - Gold Certified Sisense Partner ravid@paldi.solutionsRe: How to fetch a list of accessible dashboards for each user?
Hi DeCha You need to use the "/adminAccess parameter with a user who has admin privelages in order to use end point in behalf of other users. Indeed we have a free plugin that adds an "Info" button to the users lists page which shows all the dashboards that a user has access to. It requires some logic to construct such list but belwo you can find the APIs that our plugin uses: /api/v1/dashboards/admin /api/v1/users?email={userEmail} /api/shares/dashboard/{oid}?adminAccess=true Feel free to reach out in case you'd like to get our plugin or brainstrom on your use case Thanks, Ravid ravid@paldi.solutions Paldi Solutions - Sisense Gold Certified PartnerRe: How to pivot this data table?
Hi lalasisi The best way to propose features to Sisense is via their Product Feedback forum Per your question about combining the abiltiy to combine texts and aggreagated data - this is a comemrcial solution. It can do it all and much more as it was desgined from the start to be a comperhansive solution to all scenarios where the simple out of the box table/pivot widget is not sufficient. We can hop on a quick call and I'll show you how it works. Its really simple and we offer free trials to all our plugins so you can just try it on your server to verify that it fit to your use case (: Another option would be to customize your own solution using BloX. The guys from RapidBI had pasted a great script below so you can take and tweak it to suite your needs. This is a reasonable (and free) altarnative if you have only a few places that this needs to be implemented without too many addiotnal requirements. https://community-old.sisense.com/hc/en-us/community/posts/360039619893-Transposed-Pivot-Table-With-BloXRe: Automated Scheduled Reporting in Sisense
Thank you for the kind words HamzaJ Your ongoing feedbacks were (and stil are) extremly helpful when we work on our products. Many more capabilties to come. Who needs to get their tables in PDF all sorted out with wraped texts and auto-adjusted columns? (; Cheers, Ravid Paldi Paldi Solutions - Gold Certified Sisense Partner
