Where can I find deeper syntax documentation for the JSON expression language? More specifically, I’m looking for more information regarding the filter function for arrays.
Hello Bob,
Here is where i would go -https://democentral.learnquicksight.online/#Dashboard-FeatureDemo-Highcharts-Visual
Hope this helps a bit along with QuickSight documentation -Using Highcharts - Amazon QuickSight
Cheers,
Deep
Thanks Deep, but I’ve been through all of this. What I need is low level syntax documentation similar to what’s provided for the Highcharts API. Trial and error building of the json is not very productive.
Unfortunately not sure what you mean low level syntax , could you post an example using the Arena on what you are trying to achieve ?
Kind regards,
Koushik
@Koushik_Muthanna, when you look at the documentation for a function in QuickSight, you can see the syntax for the expression. For example, the coalesce() function provides coalesce(expression1 , expression2 [, expression3 , ... ]) along with the return type, etc. I am looking for the same for calls that can be used in the JSON, such as for ‘filter’ or ‘case’ statements.
At the moment , the highcharts example in democentral has details on the functions for JSON expression language ( https://democentral.learnquicksight.online/#Dashboard-FeatureDemo-Highcharts-Visual ) , click on the sheet [ JSON Expression Language ]
Let us know if there are others you are looking for and we can work on the updating it with examples [ if supported ] .
Kind regards,
Koushik
Thanks @Koushik_Muthanna, I’ve seen these before. I’m assuming the ‘Boolean Operations’ is for the ‘filter’ call, which is great, but there’s nothing about how and where ‘filter’ can be used within the JSON. In addition, there’s no mention of the ‘case’ statement, which is in a few of the samples. Samples are nice, but actual documentation is required as the vast majority of Highcharts samples and documentation use function calls which are not exposed/supported in QS, so that information is not helpful.
Hi @bodonnell,
I agree that the highchart documentation is quite light and would be extremely helpful if there was additional insight into each available visual option and the syntax for it. I will mark this as a feature request to promote visibility to the AWS support team for this to be expanded and improved!
hey @bodonnell
I also agree that highchart documentation is quite superficial in terms of all the possibilities we can try. What I did and still do is access highcharts documentation which can be found here:
Of course these are meant to be used as a JS library, so most of them in the demo section doesn’t work as expected due to JS functions needed.
But as a search for syntax, keys/values and some more variants of highcharts possibilities, I consider this a quite fair approach, not the best, but still enough to try some new things.
Thanks @FMagrinelli. Yeah, I’ve been neck deep in the Highcharts API documentation and demos… overall pretty solid. Not sure if you’ve seen this, was shared with me by someone from AWS - Highcharts GPT - Charting Powered by ChatGPT | Highcharts. It creates the JSON and code for whatever you ask for. Like any of these offerings, it can be hit and miss and the results still need to be converted to QS friendly JSON, ‘cleaned’ of functions, and have data connections added, but overall a good starting point!
2 Likes
Oh I did not know about this one, thanks for that!
Indeed, a good starting point for beginners, specially with the lack of documentation.