davidcomfort/dash_sample_dashboard

Build a Complex Reporting Dashboard using Dash and Plotly

Building a Complex Reporting Dashboard using Dash and Plotly

I will provide detailed instructions on how to build a reporting dashboard using Dash, a Python framework for building analytical web applications. The completed Dashboard can be viewed at https://davidcomfort-dash-app1.herokuapp.com/cc-travel-report/paid-search/. The Dashboard depicts random data and products. There is Medium Article which goes into detail how built the dashboard at https://medium.com/@davidcomfort/how-to-build-a-complex-reporting-dashboard-using-dash-and-plotl-4f4257c18a7f

dash_sample_dashboard's Issues

how to make the table hierarchy collapse and drill down

hi, this may be off topic, but do you know how to collapse&un-collapse rows in the data table?

Why read the data 3 times?

I think the same dataset df = pd.read_csv('data/performance_analytics_cost_and_ga_metrics.csv') was read in these files when then app is launched. It was read 3 times.

components/functions.py
callbacks.py
layouts.py

Would it be better to create a Singleton object so that the CSV is only read once?

Live dashboard isn't working

Live dashboard isn't working (https://davidcomfort-dash-app1.herokuapp.com/cc-travel-report/paid-search/)

"An error occurred in the application and your page could not be served. If you are the application owner, check your logs for details. You can do this from the Heroku CLI with the command
heroku logs --tail"

Problem Running Dashboard

Firstly congratulations your dashboard is very cool, I am trying to run your dashboard locally but I have the following error when executing it:

Running on http://0.0.0.0:8050/cc-travel-report/paid-search/
Debugger PIN: 918-421-685
/usr/local/lib/python3.6/site-packages/dash/resources.py:45: UserWarning:

A local version of https://code.jquery.com/jquery-3.2.1.min.js is not available

/usr/local/lib/python3.6/site-packages/dash/resources.py:45: UserWarning:

A local version of https://codepen.io/bcd/pen/YaXojL.js is not available

Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2309, in __call__
    return self.wsgi_app(environ, start_response)
  File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2295, in wsgi_app
    response = self.handle_exception(e)
  File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1741, in handle_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/local/lib/python3.6/site-packages/flask/_compat.py", line 35, in reraise
    raise value
  File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2292, in wsgi_app
    response = self.full_dispatch_request()
  File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1815, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1718, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/local/lib/python3.6/site-packages/flask/_compat.py", line 35, in reraise
    raise value
  File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1813, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1799, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/usr/local/lib/python3.6/site-packages/dash/dash.py", line 581, in index
    pl=plural
dash.exceptions.InvalidIndexException: Missing element new DashRenderer in index.

Where can I find its corresponding definition for classname "tab first", "tab"

I download all the css file to local dash sample dashboard project
but cannot find its corresponding definition for classname "tab first", "tab"

get_menu() function refers to the classname "tab first", "tab" in header.py

def get_menu():
    menu = html.Div([

        dcc.Link('Overview - Birst   ', href='/cc-travel-report/overview-birst/', className="tab first"),

        dcc.Link('Overview - GA   ', href='/cc-travel-report/overview-ga/', className="tab"),

        dcc.Link('Paid Search   ', href='/cc-travel-report/paid-search/', className="tab"),

        dcc.Link('Display   ', href='/cc-travel-report/display/', className="tab"),

        dcc.Link('Publishing   ', href='/cc-travel-report/publishing/', className="tab"),

        dcc.Link('Metasearch and Travel Ads   ', href='/cc-travel-report/metasearch-and-travel-ads/', className="tab"),

    ], className="row ")
    return menu

code in index.py, and i download all the css files to local

external_css = ["https://cdnjs.cloudflare.com/ajax/libs/normalize/7.0.0/normalize.min.css",
                "https://cdnjs.cloudflare.com/ajax/libs/skeleton/2.0.4/skeleton.min.css",
                "//fonts.googleapis.com/css?family=Raleway:400,300,600",
                "https://codepen.io/bcd/pen/KQrXdb.css",
                "https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css",
                "https://codepen.io/dmcomfort/pen/JzdzEZ.css"]

how to run locally?

thank you for your medium post? how do you run locally?

I tried python app.py

dash.exceptions.InvalidIndexException

According to plotly/dash#641 you have to add {%renderer%}, somewhere after {%scripts%} in index.py.
Otherwise you get the exception dash.exceptions.InvalidIndexException

Styling the Dashboard

Hi David,

I assume the Assets directory and Custom.css is what you used to style the dashboard, How did you connect this file/directory to the main code in order to reflect the styling of the dashboard ? and if its not that directory/file you used to style the dashboard. I would like to know how you styled it by providing borders. Thank you.