Last Saved By |
Sofokus Admin
|
Owners |
[Sofokus Admin, Ivan Lazarov]
|
Table |
superset_partnerships
|
Created By |
Sofokus Admin
|
Changed By |
Sofokus Admin
|
Uuid |
a9049ab3-8f43-6e92-6821-7a4b61fbe6bb
|
Created On |
2019-12-03 13:15:48.901624
|
Changed On |
2022-02-09 10:04:11.939013
|
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 |
2022-02-09 10:04:11.928237
|
Certified By |
None
|
Certification Details |
None
|
Alerts |
[]
|
Email Schedules |
[]
|
Dashboards |
[Dashboard<1>, Dashboard<4>]
|
Report Schedules |
[]
|