HamzaJ
02-01-2024Data Integration
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).
- Replace the dashboardIDs with the IDs of the dashboards that you want to have exported
- Open the python script in your favorite IDE and replace the following:
- base_url --> with your own base url
- translation_dict --> i use this to translate english to dutch. Either empty it if or replace it with your own language
- Authorization --> Add your bearer token
- 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.