Custom Visualization in LookML

[zameerbia]

Please provide detailed instructions on configuring the development environment for creating custom visualizations in Looker, including the necessary steps for installing the required npm packages.

Additionally, I need to develop a bar chart displaying total sales by product brand. Upon clicking on any product brand, a popup window should appear, presenting the top 10 product sales within that brand in a table format.

[francois_care]

Hello @zameerbia ,
Thank you for your question, I'll do my best to provide some insights 🙂

To create custom visualization, you could approach two main ways,

• importing a javascript file in the menu Admin < Visualizations. You could then add any git repo or pre-made javascript files you find on the web, examples here
• building the javascript file within your LookML. Here is a colleague's step by step guide using Gemini to derive the necessary javascript and explaining what to do with it

To have the top 10 be displayed, you could try two approaches,

• add drill fields to your LookML (more info here) which will be automatically sorted based on the first measure hence getting you the "top 10" based on 1 element
• build a derived table to create a metric summarizing the top N based on various criteria (more info here)

Happy Looker coding !
Francois