I am trying to make a bar chart in Canvas with two fields. I want the Y-axis to have the unique count on 'filed A' and the X-axis to display the top six names in 'field B' that has the most unique count in 'field A' while also excluding some names from the count
I tried the following with ELastic SQL, but it does not seem to give me all the records and I can't limit it to 6
SELECT component_name AS value, app_code AS appcode FROM "index**" WHERE NOT (app_code = 'xxxx' OR app_code = 'yyyy' OR app_code = 'zzzz' )
I am able to get the correct result with the visualization tab, but not in canves.
Any help will be appreciated?