HamzaJ
Data Integration
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: How to Display Category with 0 Values in Bar/Line Chart?
Hey Astroraf , I know there is a way to do this, but i cant recall the correct formula/steps. I tried it myself but couldnt get it. If there are not to much categories you could try the measured filter route. Otherwise I think a edit on datamodel level is needed. Hamza8Views0likes0CommentsRe: How to Display Category with 0 Values in Bar/Line Chart?
Hey Astroraf , I think it is dependent on how the data is stored. If it is in the same table i think a you can do this with a formula that counts all categories (e.g. count(categories), ALL(filter1),All(Filter2)) . If it is stored in multiple tables then i do not think it is possible, unless; you are on the newest linux version of sisense which supports join types and you can select a different join type then inner join if the amount of categories is limited you can apply a measure filter (e.g. (count(ID), Category=A) per category and repeat it. Hamza19Views0likes2CommentsRe: How can I turn JAQL query into a SQL query?
Only admins can run sql?query= if I am not mistaken. That jaql/sql endpoint is the only endpoint that translates jaql to sql. If it isnt usable, then I am afraid there is no way to translate a jaql to sql within Sisense itself. You would have to translate it somehow yourself unfortunately.40Views1like0CommentsRe: How to filter a table/pivot table: Filter one column that does not equal another column?
Hey Astroraf , You would need to use a formula and then filter on that formula. It can , i think, only be done with a CASE-/IF-statement. If your column is numerical you can do; case when max(A)=max(B) then 1 else 0 end Hamza44Views0likes0CommentsRe: How can I turn JAQL query into a SQL query?
Hey asael, If i am not mistaken there is an api that does exactly this. If you need to automate the process this could be the way. If it is more a one of kind of thing , then you can edit the widget , hit the three dots and select sql query. It will give you the sql code Hamza115Views0likes1CommentRe: How to create a filter within a widget?
Hey Astroraf , I do not know if this is possible with Blox. I am not a Blox Expert :) We use the Advanced Filters plugin from Ravid_PaldiTeam / Benji_PaldiTeam which does exactly this: https://www.paldi.solutions/sisense-plugins/advanced-filters They have a free trial and Ravid/Benji are always happy to help. Hamza50Views0likes0CommentsRe: Data Security Synchronization between Elasticubes
Hey MikeGre , Great find. I took a look at it and...; It works with custom code e.g. jupyter notebooks. This is implemented within the elasticube functionality. You can create a cube, select this notebook and it will ran with every cube refresh. Cube refreshes you can schedule. You could also implement this in the source cube and everytime it refreshes it will copy the DS to another cube. It doesnt seem it does a lot of validations. I only see it validates cubes exists or not Yes. It should work. Linux only btw Hamza90Views2likes1Comment