enmiwong
Cloud Apps
Joined 2 years ago
User Profile
User Widgets
Contributions
Re: Applied JAQL formula on top of another JAQL formula result
{ "headers": [ "histogram-default___x--sepal_length", "histogram-default___y--sepal_length", "transform_x" ], "metadata": [ { "jaql": { "dim": "[irisdataset6.sepal_length]", "title": "histogram-default___x--sepal_length" } }, { "jaql": { "agg": "countduplicates", "dim": "[irisdataset6.sepal_length]", "title": "histogram-default___y--sepal_length" } }, { "jaql": { "context": { "[sepal_length]": { "dim": "[irisdataset6.sepal_length]" }, "[sepal_width]": { "dim": "[irisdataset6.sepal_width]" } }, "formula": "(1* MAX([sepal_length])' )+ (-1* MAX([sepal_width])) + 0", "title": "transform_x" } } ], "datasource": { "revisionId": "TBD", "fullname": "LocalHost/irisdataset6_PathWave_fa19bddef76d43688f7ae03eb5ef194f" }, "processingInfo": { "cacheType": "result", "cacheTime": "2024-08-31T04:37:34.891Z" }, "translationInfo": { "translationServiceProvider": "NewTranslationService", "isTranslationFallback": false, "isQueryFallback": false, "translationDuration": 0.008, "sqlFromCache": false }, "values": [ [ { "data": 4.3, "text": "4.3" }, { "data": 1, "text": "1" }, { "data": 1.2999999999999998, "text": "1.3" } ], [ { "data": 4.4, "text": "4.4" }, { "data": 3, "text": "3" }, { "data": 1.2000000000000002, "text": "1.2" } ], [ { "data": 4.5, "text": "4.5" }, { "data": 1, "text": "1" }, { "data": 2.2, "text": "2.2" } ], [ { "data": 4.6, "text": "4.6" }, { "data": 4, "text": "4" }, { "data": 0.9999999999999996, "text": "1" } ], [ { "data": 4.7, "text": "4.7" }, { "data": 2, "text": "2" }, { "data": 1.5, "text": "1.5" } ], [ { "data": 4.8, "text": "4.8" }, { "data": 5, "text": "5" }, { "data": 1.4, "text": "1.4" } ], [ { "data": 4.9, "text": "4.9" }, { "data": 6, "text": "6" }, { "data": 1.3000000000000003, "text": "1.3" } ], [ { "data": 5, "text": "5" }, { "data": 10, "text": "10" }, { "data": 1.4, "text": "1.4" } ], [ { "data": 5.1, "text": "5.1" }, { "data": 9, "text": "9" }, { "data": 1.2999999999999998, "text": "1.3" } ], [ { "data": 5.2, "text": "5.2" }, { "data": 4, "text": "4" }, { "data": 1.1000000000000005, "text": "1.1" } ], [ { "data": 5.3, "text": "5.3" }, { "data": 1, "text": "1" }, { "data": 1.5999999999999996, "text": "1.6" } ], [ { "data": 5.4, "text": "5.4" }, { "data": 6, "text": "6" }, { "data": 1.5000000000000004, "text": "1.5" } ], [ { "data": 5.5, "text": "5.5" }, { "data": 7, "text": "7" }, { "data": 1.2999999999999998, "text": "1.3" } ], [ { "data": 5.6, "text": "5.6" }, { "data": 6, "text": "6" }, { "data": 2.5999999999999996, "text": "2.6" } ], [ { "data": 5.7, "text": "5.7" }, { "data": 8, "text": "8" }, { "data": 1.2999999999999998, "text": "1.3" } ], [ { "data": 5.8, "text": "5.8" }, { "data": 7, "text": "7" }, { "data": 1.7999999999999998, "text": "1.8" } ], [ { "data": 5.9, "text": "5.9" }, { "data": 3, "text": "3" }, { "data": 2.7, "text": "2.7" } ], [ { "data": 6, "text": "6" }, { "data": 6, "text": "6" }, { "data": 2.6, "text": "2.6" } ], [ { "data": 6.1, "text": "6.1" }, { "data": 6, "text": "6" }, { "data": 3.0999999999999996, "text": "3.1" } ], [ { "data": 6.2, "text": "6.2" }, { "data": 4, "text": "4" }, { "data": 2.8000000000000003, "text": "2.8" } ], [ { "data": 6.3, "text": "6.3" }, { "data": 9, "text": "9" }, { "data": 2.9, "text": "2.9" } ], [ { "data": 6.4, "text": "6.4" }, { "data": 7, "text": "7" }, { "data": 3.2, "text": "3.2" } ], [ { "data": 6.5, "text": "6.5" }, { "data": 5, "text": "5" }, { "data": 3.3, "text": "3.3" } ], [ { "data": 6.6, "text": "6.6" }, { "data": 2, "text": "2" }, { "data": 3.5999999999999996, "text": "3.6" } ], [ { "data": 6.7, "text": "6.7" }, { "data": 8, "text": "8" }, { "data": 3.4000000000000004, "text": "3.4" } ], [ { "data": 6.8, "text": "6.8" }, { "data": 3, "text": "3" }, { "data": 3.5999999999999996, "text": "3.6" } ], [ { "data": 6.9, "text": "6.9" }, { "data": 4, "text": "4" }, { "data": 3.7, "text": "3.7" } ], [ { "data": 7, "text": "7" }, { "data": 1, "text": "1" }, { "data": 3.8, "text": "3.8" } ], [ { "data": 7.1, "text": "7.1" }, { "data": 1, "text": "1" }, { "data": 4.1, "text": "4.1" } ], [ { "data": 7.2, "text": "7.2" }, { "data": 3, "text": "3" }, { "data": 3.6, "text": "3.6" } ], [ { "data": 7.3, "text": "7.3" }, { "data": 1, "text": "1" }, { "data": 4.4, "text": "4.4" } ], [ { "data": 7.4, "text": "7.4" }, { "data": 1, "text": "1" }, { "data": 4.6000000000000005, "text": "4.6" } ], [ { "data": 7.6, "text": "7.6" }, { "data": 1, "text": "1" }, { "data": 4.6, "text": "4.6" } ], [ { "data": 7.7, "text": "7.7" }, { "data": 4, "text": "4" }, { "data": 3.9000000000000004, "text": "3.9" } ], [ { "data": 7.9, "text": "7.9" }, { "data": 1, "text": "1" }, { "data": 4.1000000000000005, "text": "4.1" } ] ] } The json body attached is the response of JAQL query. the third column is retrieved by apply the formula: "(1* MAX([sepal_length])' )+ (-1* MAX([sepal_width])) + 0". now I want to do some operation to the third column, filter, sort in ascending order.... not sure how to do that1.1KViews0likes0CommentsApplied JAQL formula on top of another JAQL formula result
Hi, I have applied a JAQL formula to get new values (the values * 10), after that, I want to get the MAX from the result of the first query. how to achieve that? this is the result get from JAQL : [{"data": 4.3,"text": "4.3"}, {"data": 1,"text": "1"}, {"data": 43,"text": "43"}] the third column is get by applied this JAQL formula: { "jaql": { "context": { "[sepal_length]": {"dim": "[irisdataset6.sepal_length]"} }, "formula": "10 * MAX([sepal_length]) + 0", "title": "transform_x" } } now I want to get the max from the third column, how to achieve that?1.3KViews0likes5CommentsHow to delete element in an array by id in nested object using custom data api
Hi, I'm having data with the following format: { "dataset_id": "4ac54805-18a2-46a6-afb7-8829eb0e1a27", "configurationDetails": { "measurementType": "Generic Dataset", "fields": [ { "id": "0", "name": "Id", "type": "Property", "dataType": "Integer", "count": 150, "visibility": true } ] } } I want to delete fields with id=0, how to write the query for the delete custom data endpoint here: https://sisense.dev/guides/restApi/custom-data.html#:~:text=DELETE,v1/custom_data/querySolved1.8KViews0likes2CommentsWhat is the dashboard layout used in sisense dashboard ui
May I know what is the dashboard layout library being used in sisense dashboard ui? I’m currently developing dashboard in my application, it should get dashboard and widgets from sisense rest api and position it in the web application. I’m using gridster for the dashboard layout. Wondering how to translate the dashboard layout which is obtained from the sisense rest api into gridster for positioning?1.5KViews0likes4CommentsHow to create the data model without using sisense cli in my application using compose sdk
https://sisense.dev/guides/sdk/quickstart-angular.html#:~:text=%23-,Generating%20a%20Data%20Model%20Representation,-To%20visualize%20data from the compose sdk tutorial above, the datamodel can be get by running cli. How do I achieve this dynamically in my application without running the cli? is there any sisense rest api can do this? I'm getting the DM for building the data visualization as the tutorial provided here: https://www.sisense.com/blog/take-control-of-your-data-visualizations/1.8KViews2likes2Comments