| Last Saved By | Sandro Tassa |
|---|---|
| Owners | [Sofokus Admin, Ivan Lazarov, Sandro Tassa] |
| Table | superset_partnerships |
| Created By | Sofokus Admin |
| Changed By | Sandro Tassa |
| Uuid | a9049ab3-8f43-6e92-6821-7a4b61fbe6bb |
| Created On | 2019-12-03 13:15:48.901624 |
| Changed On | 2024-07-11 09:59:23.197907 |
| Name | Budget (€) for 2014 – 2020 |
| Datasource Id | 13 |
| Datasource Type | table |
| Datasource Name | superset_partnerships |
| Visualization Type | big_number_total |
| Parameters | { "adhoc_filters": [ { "clause": "WHERE", "comparator": "2014-2020", "expressionType": "SIMPLE", "filterOptionName": "filter_8z027bsqqae_cpferr4lxm5", "isExtra": false, "isNew": false, "operator": "==", "sqlExpression": null, "subject": "programme_period_title" }, { "clause": "WHERE", "comparator": null, "expressionType": "SQL", "filterOptionName": "filter_psjjtc8a8cl_z4a85xl8kic", "isExtra": false, "isNew": false, "operator": null, "sqlExpression": "partnership_total_budget > 0", "subject": null } ], "datasource": "13__table", "extra_form_data": {}, "granularity_sqla": null, "header_font_size": 0.5, "metric": "sum_partnership_budgets", "slice_id": 310, "subheader": "", "subheader_font_size": 0.3, "time_range": "No filter", "time_range_endpoints": [ "unknown", "inclusive" ], "url_params": {}, "viz_type": "big_number_total", "y_axis_format": ",.2f" } |
| Query Context | {"datasource":{"id":13,"type":"table"},"force":false,"queries":[{"time_range":"No filter","granularity":null,"filters":[{"col":"programme_period_title","op":"==","val":"2014-2020"}],"extras":{"time_range_endpoints":["unknown","inclusive"],"having":"","having_druid":[],"where":"(partnership_total_budget > 0)"},"applied_time_extras":{},"columns":[],"metrics":["sum_partnership_budgets"],"annotation_layers":[],"timeseries_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{}}],"result_format":"json","result_type":"full"} |
| Description | None |
| Cache Timeout | None |
| Perm | [keep_statistics].[superset_partnerships](id:13) |
| Schema Perm | None |
| Last Saved At | 2024-07-11 09:59:23.185566 |
| Certified By | None |
| Certification Details | None |
| Alerts | [] |
| Email Schedules | [] |
| Dashboards | [Dashboard<1>, Dashboard<4>] |
| Report Schedules | [] |