Did you know that you can analyze eazyBI with eazyBI? eazyBI Wrapped is exactly that! In our “language” we call it usage statistics and it shows how eazyBI has been used in your organization.
This dashboard might not be the most serious one, but definitely gives an overview of what is being used the most while using eazyBI and might bring some ideas on further improvements of the most popular reports and dashboards.
The dashboard includes:
- Overview report with total users and generated report count, favorite chart types, and top dashboards.
- Activity Chopstick Report to see daily report executions and uncover the most active and inactive days of the year.
- Favorite Chart Types – discover which chart type is most often used for data visualizations across your reports.
- Top 10 Reports & Dashboards: Celebrate the crowd favorites that have helped the most!
- Activity Heatmap: Pinpoint the most active days and hours when your company was buzzing with activity.
Get similar insights about how your organization is using eazyBI by pasting this dashboard definition in your account. Go to your usage statistics account. Copy the dashboard definition below and import it in the Dashboard section.
{
"name": "2024 in eazyBI",
"folder_name": "Yearly trends (2024)",
"definition": {"pages":[{"cube_name":"Usage","name":"Time","selected_set":["[Time].[2024]"],"members":[{"depth":1,"name":"2024","full_name":"[Time].[2024]","drillable":true,"caption":"2024","start_date":"2024-01-01"}],"bookmarked_members":[],"current_page_members":["[Time].[2024]"]}],"reports":[{"width":100,"cube_report_name":"Summary","cube_name":"Usage","folder_name":"Yearly trends (2024)"},{"width":50,"height":480,"cube_report_name":"Activity chopstick report","cube_name":"Usage","folder_name":"Yearly trends (2024)"},{"width":50,"height":480,"cube_report_name":"Favorite chart types","cube_name":"Usage","folder_name":"Yearly trends (2024)"},{"width":50,"cube_report_name":"Weekly Heatmap","cube_name":"Usage","folder_name":"Yearly trends (2024)"},{"width":50,"cube_report_name":"Top 10 Reports","cube_name":"Usage","folder_name":"Yearly trends (2024)"},{"width":50,"cube_report_name":"Top 10 Dashboards","cube_name":"Usage","folder_name":"Yearly trends (2024)"}],"description":"\u003cdiv\u003e\n \u003cimg style=\"width:100%\" src=\"https://storage.googleapis.com/eazybi-public/Events/Advent-2024/eazyBI%20wrapped%202024_dashboard_hq.png\"/\u003e\n\u003c/div\u003e","pages_options":{}},
"dashboard_reports": [ {
"cube_name": "Usage",
"cube_reports": [ {
"name": "Summary",
"folder_name": "Yearly trends (2024)",
"result_view": "gauge",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Total active users]","[Measures].[Total active reports]","[Measures].[Top chart type]","[Measures].[Busiest time]","[Measures].[Top Dashboard]"],"members":[{"depth":0,"full_name":"[Measures].[Total active users]","format_string":"MarkdownFormatter","report_specific":true,"name":"Total active users","calculated":true},{"depth":0,"full_name":"[Measures].[Total active reports]","format_string":"MarkdownFormatter","report_specific":true,"name":"Total active reports","calculated":true},{"depth":0,"full_name":"[Measures].[Top chart type]","format_string":"MarkdownFormatter","report_specific":true,"name":"Top chart type","calculated":true},{"depth":0,"full_name":"[Measures].[Busiest time]","format_string":"MarkdownFormatter","report_specific":true,"name":"Busiest time","calculated":true,"id":"[Measures].[Busiest time]"},{"depth":0,"full_name":"[Measures].[Top Dashboard]","format_string":"","report_specific":true,"name":"Top Dashboard","calculated":true}]}]},"rows":{"dimensions":[{"name":"Account","selected_set":["[Account].[All Accounts]"],"members":[],"bookmarked_members":[]}],"extreme_by":{"expression":["[Measures].[Report Executions]"],"extreme":"top_count","limit":10,"others":false},"nonempty_crossjoin":false},"pages":{"dimensions":[{"name":"Time","selected_set":["[Time].[2024]"],"members":[{"depth":1,"name":"2024","full_name":"[Time].[2024]","drillable":true}],"bookmarked_members":[],"current_page_members":["[Time].[2024]"]}]},"options":{},"view":{"current":"gauge","maximized":false,"gauge":{"swap_axes":false,"series_options":{},"gauge_limit":{"[Measures].[Top chart type]":[{"color":"#FFA806"}],"[Measures].[Busiest time]":[{"color":"#2F579C"}],"[Measures].[Total active users]":[{"color":"#B31238"}],"[Measures].[Total active reports]":[{"color":"#0093B5"}]},"only_values":true},"table":{"cell_formatting":{}}},"calculated_members":[{"dimension":"Measures","name":"Top chart type","formula":"CASE \n Order(\n [Report Type].[Report Type].Members,\n [Measures].[Report Executions], BDESC\n ).Item(0).Name\n WHEN \"Table\" THEN \"\u003ci class='fa-solid fa-table'\u003e\u003c/i\u003e Table\"\n WHEN \"Bar chart\" THEN \"\u003ci class='fa-solid fa-chart-simple'\u003e\u003c/i\u003e Bar\"\n WHEN \"Line chart\" THEN \"\u003ci class='fa-solid fa-chart-line'\u003e\u003c/i\u003e Line\"\n WHEN \"Pie chart\" THEN \"\u003ci class='fa-solid fa-chart-pie'\u003e\u003c/i\u003e Pie\"\n WHEN \"Scatter chart\" THEN \"\u003ci class='fa-solid fa-chart-scatter'\u003e\u003c/i\u003e Scatter\"\n WHEN \"Timeline chart\" THEN \"\u003ci class='fa-solid fa-chart-line'\u003e\u003c/i\u003e Timeline\"\n WHEN \"Gantt chart\" THEN \"\u003ci class='fa-solid fa-chart-gantt'\u003e\u003c/i\u003e Gantt\"\n WHEN \"Gauge\" THEN \"\u003ci class='fa-solid fa-gauge-simple-high'\u003e\u003c/i\u003e Gauge\"\n WHEN \"Map chart\" THEN \"\u003ci class='fa-regular fa-globe'\u003e\u003c/i\u003e Map\"\n ELSE\n Order(\n [Report Type].[Report Type].Members,\n [Measures].[Report Executions], BDESC\n ).Item(0).Name\nEND","format_string":"MarkdownFormatter"},{"dimension":"Measures","name":"Top Report","formula":"Order(\n [Report].[Report].Members,\n [Measures].[Report Executions], BDESC\n).Item(0).Name ","format_string":""},{"dimension":"Measures","name":"Top Dashboard","formula":"Order(\n [Dashboard].[Dashboard].Members,\n --divide report executions with active report count to coutn each dashboard only once\n [Measures].[Report Executions]/[Measures].[Active Reports]\n , BDESC\n).Item(0).Name","format_string":""},{"dimension":"Measures","name":"Busiest time","formula":"\"\u003ci class='fa-solid fa-clock-ten'\u003e\u003c/i\u003e \" ||\n--find the busiest week day name\nOrder(\n CrossJoin(\n [Week Day].[Week Day].Members,\n [Hour].[Hour].Members\n ),\n [Measures].[Report Executions],\n BDESC\n).Item(0).Item(0).Name\n|| \" at \" || \n--find the busiest hour\nOrder(\n CrossJoin(\n [Week Day].[Week Day].Members,\n [Hour].[Hour].Members\n ),\n [Measures].[Report Executions],\n BDESC\n).Item(0).Item(1).Name\n|| \":00\"","format_string":"MarkdownFormatter"},{"dimension":"Measures","name":"Total active users","formula":"\"\u003ci class='fa-solid fa-users'\u003e\u003c/i\u003e\"\n||\nStr([Measures].[Active Users])","format_string":"MarkdownFormatter"},{"dimension":"Measures","name":"Total active reports","formula":"\"\u003ci class='fa-solid fa-file-chart-column'\u003e\u003c/i\u003e\"\n||\nStr([Measures].[Active Reports])","format_string":"MarkdownFormatter"}]}
},{
"name": "Activity chopstick report",
"folder_name": "Yearly trends (2024)",
"result_view": "timeline_chart",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Report Executions]"],"members":[]}]},"rows":{"dimensions":[{"name":"Time","selected_set":["[Time].[2024]"],"selected_set_expression":"DescendantsSet({{selected_set}}, [Time].[Day])","members":[],"bookmarked_members":[]}]},"pages":{"dimensions":[{"name":"Time","duplicate":true,"selected_set":["[Time].[2024]"],"members":[{"depth":1,"name":"2024","full_name":"[Time].[2024]","drillable":true}],"bookmarked_members":[],"current_page_members":["[Time].[2024]"]}]},"options":{},"view":{"current":"timeline_chart","maximized":false,"timeline_chart":{"series_type":"column","stacked":true,"series_options":{"Report Executions":{"color":"#00B8D9","conditional_formatting":{"type":"top_bottom","rules":[{"name":"top","value":3,"color":"#D4153B"},{"name":"bottom"},{"name":"default","color":"#00B8D9"}]}},"red dot":{"color":"#B31238"}}},"table":{"cell_formatting":{"[Measures].[Report Executions]":{"type":"heatmap","whole_row":true,"rules":[{"name":"min"},{"name":"mid"},{"name":"max","background_color":"#274380"}]}}}},"calculated_members":[]}
},{
"name": "Favorite chart types",
"folder_name": "Yearly trends (2024)",
"result_view": "bar_chart",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Report Executions]"],"members":[]}]},"rows":{"dimensions":[{"name":"Report Type","selected_set":["[Report Type].[Report Type].Members"],"members":[],"bookmarked_members":[]}],"order_by":{"expression":["[Measures].[Report Executions]"],"order":"DESC"},"nonempty_crossjoin":true},"pages":{"dimensions":[{"name":"Time","selected_set":["[Time].[2024]"],"members":[{"depth":1,"name":"2024","full_name":"[Time].[2024]","drillable":true}],"bookmarked_members":[],"current_page_members":["[Time].[2024]"]}]},"options":{},"view":{"current":"bar_chart","maximized":false,"bar_chart":{"stacked":false,"vertical":false,"swap_axes":false,"data_labels":true,"series_options":{"Report Executions":{"dataLabelType":"top horizontal","color":"#FFA806"}}},"table":{"cell_formatting":{"[Measures].[Report Executions]":{"type":"heatmap","whole_row":true,"rules":[{"name":"min"},{"name":"mid"},{"name":"max","background_color":"#274380"}]}}}},"calculated_members":[]}
},{
"name": "Weekly Heatmap",
"folder_name": "Yearly trends (2024)",
"result_view": "table",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Report Executions]"],"members":[]},{"name":"Week Day","selected_set":["[Week Day].[Week Day].Members"],"members":[],"bookmarked_members":[]}]},"rows":{"dimensions":[{"name":"Hour","selected_set":["[Hour].[Hour].Members"],"members":[],"bookmarked_members":[]}]},"pages":{"dimensions":[{"name":"Time","selected_set":["[Time].[2024]"],"members":[{"depth":1,"name":"2024","full_name":"[Time].[2024]","drillable":true}],"bookmarked_members":[],"current_page_members":["[Time].[2024]"]}]},"options":{},"view":{"current":"table","maximized":false,"table":{"row_dimension_headers":{"Hour":true},"cell_formatting":{"[Measures].[Report Executions]":{"type":"heatmap","rules":[{"name":"min"},{"name":"mid"},{"name":"max","background_color":"#274380"}]}}}},"calculated_members":[]}
},{
"name": "Top 10 Reports",
"folder_name": "Yearly trends (2024)",
"result_view": "table",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Report Executions]"],"members":[]}]},"rows":{"dimensions":[{"name":"Report","selected_set":["[Report].[Report].Members"],"members":[],"bookmarked_members":[]}],"extreme_by":{"expression":["[Measures].[Report Executions]"],"extreme":"top_count","limit":10,"others":false},"nonempty_crossjoin":true},"pages":{"dimensions":[{"name":"Time","selected_set":["[Time].[2024]"],"members":[{"depth":1,"name":"2024","full_name":"[Time].[2024]","drillable":true}],"bookmarked_members":[],"current_page_members":["[Time].[2024]"]}]},"options":{},"view":{"current":"table","maximized":false,"table":{"row_dimension_headers":{"Report":true},"cell_formatting":{}}},"calculated_members":[]}
},{
"name": "Top 10 Dashboards",
"folder_name": "Yearly trends (2024)",
"result_view": "table",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Dashboard executions]"],"members":[{"depth":0,"full_name":"[Measures].[Dashboard executions]","format_string":"#,##0","report_specific":true,"name":"Dashboard executions","calculated":true}]}]},"rows":{"dimensions":[{"name":"Dashboard","selected_set":["[Dashboard].[Dashboard].Members"],"members":[],"bookmarked_members":[]}],"extreme_by":{"expression":["[Measures].[Dashboard executions]"],"extreme":"top_count","limit":10,"others":false},"nonempty_crossjoin":true},"pages":{"dimensions":[{"name":"Time","selected_set":["[Time].[2024]"],"members":[{"depth":1,"name":"2024","full_name":"[Time].[2024]","drillable":true}],"bookmarked_members":[],"current_page_members":["[Time].[2024]"]}]},"options":{},"view":{"current":"table","maximized":false,"table":{"row_dimension_headers":{"Dashboard":true},"cell_formatting":{}}},"calculated_members":[{"dimension":"Measures","name":"Dashboard executions","formula":"[Measures].[Report Executions]/\n[Measures].[Active Reports]","format_string":"#,##0"}]}
} ],
"calculated_members": []
} ]
}
What insights surprised you the most? Let us know your thoughts in the comments!
Happy reporting! 
Zane / support@eazyBI.com