Forum Discussion

HamzaJ's avatar
HamzaJ
Data Integration
02-01-2024

Dashboard Dictionary

Hello,

My users and designers were looking for an easy way to get insights into how certain dashboards and its widgets were build in terms of formulas and filters. 

For this I have written a python script that takes a list of dashboard IDs and converts them to an Excel with 2 worksheets. The first worksheet shows all widgets, while the second shows all dashboard filters.

Attached you will find a python-script + a CSV (with dashboardIDs).

  1. Replace the dashboardIDs with the IDs of the dashboards that you want to have exported
  2. Open the python script in your favorite IDE and replace the following:
    1.  base_url --> with your own base url
    2. translation_dict --> i use this to translate english to dutch. Either empty it if or replace it with your own language
    3. Authorization --> Add your bearer token
  3. Run the script

The output will be an Excel-file that you can import into an elasticube and create a dashboard with. 

Ps. In my dashboard I use Paldi's Advanced Filters for easy filtering and Advanced Text Widget for easy to style texts.

 

3 Replies

Replies have been turned off for this discussion
  • Hello HamzaJ,

    Can you be more specific regarding the data you are looking for? 

    • HamzaJ's avatar
      HamzaJ
      Data Integration

      Hey DRay ,

      What do you mean? I created a tool that exports dashboards and its metadata to Excel for an easy overview of all used fields and filters within dashboards and widgets. 

      Hamza

      • DRay's avatar
        DRay
        Admin

        Ah, my mistake. I thought you were looking for help with something. My bad. Thank you for contributing to the community!