.. _Historical Flows Explorer:

Historical Flow Analysis JSON Example
-------------------------------------
.. code:: bash

    {
        "name" : "Applications",
        "data_source" : "flows",
        "chart" : [
        {
            "chart_id" : "top_l7_proto", // Each id MUST be different
            "chart_name" : "Top App Proto",
            "chart_css_styles" : { 
                "max-height" : "25rem",
                "min-height" : "25rem",
            },
            "chart_endpoint" : "/lua/rest/v2/get/db/charts/top_l7_proto.lua",
            "chart_events" : { 
                "dataPointSelection" : "db_analyze"
            },
            "chart_gui_filter" : "l7proto", 
            "chart_sql_query" : "SELECT L7_PROTO,SUM(TOTAL_BYTES) AS bytes FROM flows WHERE ($WHERE) GROUP BY L7_PROTO ORDER BY bytes DESC",
            "chart_type" : "donut_apex_chart",
            "chart_record_value" : "bytes",
            "chart_aggregate_low_data" : true,
            "chart_record_label" : "L7_PROTO",
            "chart_width" : 4, 
            "chart_y_formatter" : "format_bytes", 
        },{
            "chart_id" : "l7_proto_per_flow", // Each id MUST be different
            "chart_name" : "Num Flows per App",
            "chart_css_styles" : { 
                "max-height" : "35rem",
                "min-height" : "35rem",
            },
            "chart_endpoint" : "/lua/rest/v2/get/db/charts/l7_proto_per_flow.lua",
            "chart_events" : { 
                "dataPointSelection" : "db_analyze"
            },
            "chart_gui_filter" : "l7proto", 
            "chart_sql_query" : "SELECT L7_PROTO,COUNT(*) AS flows FROM flows WHERE ($WHERE) GROUP BY L7_PROTO ORDER BY flows DESC LIMIT 15",
            "chart_type" : "treemap_apex_chart",
            "chart_i18n_extra_x_label" : "flows",
            "chart_record_value" : "flows",
            "chart_record_label" : "L7_PROTO",
            "chart_width" : 6, 
            "chart_y_formatter" : "format_value", 
        },{
            "chart_id" : "highest_avg_flow_size_per_l7", // Each id MUST be different
            "chart_name" : "Avg Flow Size per App",
            "chart_css_styles" : { 
                "max-height" : "35rem",
                "min-height" : "35rem",
            },
            "chart_endpoint" : "/lua/rest/v2/get/db/charts/l7_proto_per_flow.lua",
            "chart_events" : { 
                "dataPointSelection" : "db_analyze"
            },
            "chart_gui_filter" : "l7proto", 
            "chart_sql_query" : "SELECT L7_PROTO,avg(TOTAL_BYTES) AS avg_bytes FROM flows WHERE ($WHERE) GROUP BY L7_PROTO ORDER BY avg_bytes DESC LIMIT 15",
            "chart_type" : "bar_apex_chart",
            "chart_i18n_extra_x_label" : "flow_size",
            "chart_record_value" : "avg_bytes",
            "chart_record_label" : "L7_PROTO",
            "chart_width" : 6, 
            "chart_y_formatter" : "format_bytes",
        }],
        "show_in_page" : "analysis",
    }
