8013 saved seach aantal openstaande acties per module: verschil tussen versies
Nieuwe pagina aangemaakt met 'export version "1.59" { generated by "D2A StreamingD2AExportWriter version 1.3.5 (D2A version 5240.)" schedule "Global schedule" { "Saved search: Aantal opensta...' |
Geen bewerkingssamenvatting |
||
| (5 tussenliggende versies door dezelfde gebruiker niet weergegeven) | |||
| Regel 1: | Regel 1: | ||
[[Test_dashboard_tabel_definitie_optie|Test dashboard tabel definitie optie]] | |||
[[Test_Tegel_tabel_definitie_optie|Test Tegel tabel definitie optie]] | |||
} | |||
export version "1.59" {<br/> generated by "D2A StreamingD2AExportWriter version 1.3.5 (D2A version 5240.)"<br/> schedule "Global schedule" {<br/> "Saved search: Aantal openstaande acties per module" = create or replace saved search "Aantal openstaande acties per module" #4955b53eba1a4586aa31e24a164f0817 reference "VC08013" mode "ACT" options { "groupByField" "Controle/norm" "savedLayoutState" "1,{""activeDetailTab"":2,""borderLayoutOptions"":{""ACT_LAYOUT_NAME"":{""north"":{""size"":""60"",""slidable"":false,""initClosed"":false,""enableCursorHotkey"":false,""autoFold"":false},""east"":{""size"":""800"",""slidable"":false,""initClosed"":false,""enableCursorHotkey"":false,""autoFold"":false},""west"":{""size"":""240"",""slidable"":false,""initClosed"":false,""enableCursorHotkey"":false,""autoFold"":false}}},""viewMode"":""ACT"",""tableCols"":["" page name"","" page type""],""actionMode"":""HIDE_RULES_WITHOUT_ACTIONS""}" } details "Grafiek toont de openstaande acties per module." target audience { "DA" } categories { "Openstaande acties" } additional fields {<br/> "Gegevens":string="Actielijsten"<br/> "X-as":string="Module"<br/> "Y-as":string="Aantal"<br/> }<br/> view #4d928ff2caee4b5b8fadc67709ac5767 {<br/> data calculated pivot {<br/> pivot #da621278f6354cf192eae9b56c1642f4 max 300 rows 25 columns {<br/> sort as tree {<br/> column 0 desc<br/> " pivotdata" asc<br/> "Controle/norm" asc<br/> } row fields {<br/> "Controle/norm"<br/> } column fields {<br/> data " pivotdata"<br/> } value fields {<br/> count " created date" format "j %,d" target long as "BaseAantal"<br/> sum "Impact" format "j € %,.0f" target double as "BaseImpact"<br/> }<br/> do include empty<br/> do show row totals<br/> do show column totals<br/> norm is not upper bound<br/> multivalue fast<br/> not foldable<br/> }<br/> calculated fields {<br/> "{BaseAantal}" format "j %,d" as "Aantal" visible<br/> "{BaseImpact}" format "j € %,.0f" as "Impact" visible<br/> }<br/> sort column 2 desc<br/> }<br/> merge search "controles in productie"<br/> dashboards {<br/> dashboard "Aantal openstaande acties per module" #ee503641f076464b875c5fec4fcb5498 {<br/> kpi #65bc7db2c28546d0900737849d7fbf71 type "DRILLDOWNEXPANDINGSTACKEDBARWITHTARGET" {<br/> chart {<br/> "dataFieldName" = "Aantal"<br/> "xAxisFieldName" = "Module"<br/> "stackFieldName" = " action status"<br/> "yAxisFormat" = "s %s"<br/> }<br/> query {<br/> sort " uuid":{ string } value asc<br/> }<br/> pivot #54bf8c61578d4bdcb6a3086f7abd5725 max 1000 rows 25 columns {<br/> sort as tree {<br/> column 0 desc<br/> " action status" asc<br/> "Specialisme" asc<br/> "CreateDate" asc<br/> " page type" asc<br/> "Aanvangs datum" desc<br/> "Aanvangs jaarmaand" asc<br/> "Specialisme code" asc<br/> " title" asc<br/> " pivotdata" asc<br/> "Norm" asc<br/> " owner" asc<br/> "Module" asc<br/> " page name" asc<br/> } row fields {<br/> "Module"<br/> } column fields {<br/> " action status"<br/> data " pivotdata"<br/> } value fields {<br/> count " page type" format "s %s" target long as "Aantal"<br/> }<br/> do not include empty<br/> do show row totals<br/> do show column totals<br/> norm is not upper bound<br/> multivalue fast<br/> not foldable<br/> }<br/> filters {<br/> }<br/> }<br/> }<br/> dashboard "Aantal openstaande acties per module" #eed783319af34d12aded52a22a4f8a55 {<br/> kpi #e8ccab13817647a39445b38b047254f1 type "DRILLDOWNPIVOT" {<br/> query {<br/> sort " uuid":{ string } value asc<br/> }<br/> pivot #eddab7b15c394c93b3cfec2b8d47bf19 max 1000 rows 25 columns {<br/> sort as tree {<br/> column 0 desc<br/> "VC opmerking" asc<br/> "Specialisme code" asc<br/> " title" asc<br/> " pivotdata" asc<br/> " owner" asc<br/> "Module" asc<br/> } row fields {<br/> "Module"<br/> } column fields {<br/> data " pivotdata"<br/> } value fields {<br/> page count " page name" format "j %,d" target long as "Aantal"<br/> }<br/> do not include empty<br/> do show row totals<br/> do show column totals<br/> norm is not upper bound<br/> multivalue fast<br/> not foldable<br/> }<br/> filters {<br/> }<br/> }<br/> }<br/> }<br/> } queries {<br/> base = query {<br/> filter " rule status":{ enum } == "Geaccepteerd" and " page name":{ string } starts with "R"<br/> facets {<br/> standard " organization structure" {<br/> sort value desc expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children<br/> }<br/> standard "Specialisme" {<br/> sort value desc expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children<br/> }<br/> standard "Module" {<br/> sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children<br/> }<br/> standard " title" {<br/> sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children<br/> }<br/> standard "Schadelastjaar" {<br/> sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children<br/> }<br/> standard "RVE" {<br/> sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children<br/> }<br/> standard "Controle/norm" {<br/> sort value desc expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children<br/> }<br/> standard " owner" {<br/> sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children<br/> }<br/> standard " page type" {<br/> sort value desc expanded not visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children<br/> children {<br/> standard "action" {<br/> sort value desc expanded visible checked count not estimated dont want child labels updated allow change type to date not available as date max 5 children has no more children<br/> }<br/> }<br/> }<br/> standard "Patientnr" {<br/> sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children<br/> }<br/> standard "Handreiking" {<br/> sort value desc expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children<br/> }<br/> standard "DOT Controle Regel" {<br/> sort value desc expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children<br/> }<br/> standard " action status" {<br/> sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children<br/> children {<br/> standard "Open" {<br/> sort value desc expanded visible checked count not estimated dont want child labels updated allow change type to date not available as date max 5 children has no more children<br/> }<br/> }<br/> }<br/> standard " ignored" {<br/> sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children<br/> children {<br/> standard "Nee" {<br/> sort value desc expanded visible checked count not estimated dont want child labels updated allow change type to date not available as date max 5 children has no more children<br/> }<br/> }<br/> }<br/> standard " parked" {<br/> sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children<br/> children {<br/> standard "Nee" {<br/> sort value desc expanded visible checked count not estimated dont want child labels updated allow change type to date not available as date max 5 children has no more children<br/> }<br/> }<br/> }<br/> standard " workflow" {<br/> sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children<br/> children {<br/> standard "Nee" {<br/> sort value desc expanded visible checked count not estimated dont want child labels updated allow change type to date not available as date max 5 children has no more children<br/> }<br/> }<br/> }<br/> standard " comment" {<br/> sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children<br/> }<br/> }<br/> sort " priority" asc, "id" visual desc<br/> }<br/> }<br/> created by "ValueCare" at '1970-01-01 01:00:00.000'<br/> updated by "ValueCare" at '1970-01-01 01:00:00.000'<br/> company "ValueCare" | |||
<br/> }<br/>} | |||
Huidige versie van 2 dec 2019 08:17
Test dashboard tabel definitie optie
Test Tegel tabel definitie optie
export version "1.59" {
generated by "D2A StreamingD2AExportWriter version 1.3.5 (D2A version 5240.)"
schedule "Global schedule" {
"Saved search: Aantal openstaande acties per module" = create or replace saved search "Aantal openstaande acties per module" #4955b53eba1a4586aa31e24a164f0817 reference "VC08013" mode "ACT" options { "groupByField" "Controle/norm" "savedLayoutState" "1,{""activeDetailTab"":2,""borderLayoutOptions"":{""ACT_LAYOUT_NAME"":{""north"":{""size"":""60"",""slidable"":false,""initClosed"":false,""enableCursorHotkey"":false,""autoFold"":false},""east"":{""size"":""800"",""slidable"":false,""initClosed"":false,""enableCursorHotkey"":false,""autoFold"":false},""west"":{""size"":""240"",""slidable"":false,""initClosed"":false,""enableCursorHotkey"":false,""autoFold"":false}}},""viewMode"":""ACT"",""tableCols"":["" page name"","" page type""],""actionMode"":""HIDE_RULES_WITHOUT_ACTIONS""}" } details "Grafiek toont de openstaande acties per module." target audience { "DA" } categories { "Openstaande acties" } additional fields {
"Gegevens":string="Actielijsten"
"X-as":string="Module"
"Y-as":string="Aantal"
}
view #4d928ff2caee4b5b8fadc67709ac5767 {
data calculated pivot {
pivot #da621278f6354cf192eae9b56c1642f4 max 300 rows 25 columns {
sort as tree {
column 0 desc
" pivotdata" asc
"Controle/norm" asc
} row fields {
"Controle/norm"
} column fields {
data " pivotdata"
} value fields {
count " created date" format "j %,d" target long as "BaseAantal"
sum "Impact" format "j € %,.0f" target double as "BaseImpact"
}
do include empty
do show row totals
do show column totals
norm is not upper bound
multivalue fast
not foldable
}
calculated fields {
"{BaseAantal}" format "j %,d" as "Aantal" visible
"{BaseImpact}" format "j € %,.0f" as "Impact" visible
}
sort column 2 desc
}
merge search "controles in productie"
dashboards {
dashboard "Aantal openstaande acties per module" #ee503641f076464b875c5fec4fcb5498 {
kpi #65bc7db2c28546d0900737849d7fbf71 type "DRILLDOWNEXPANDINGSTACKEDBARWITHTARGET" {
chart {
"dataFieldName" = "Aantal"
"xAxisFieldName" = "Module"
"stackFieldName" = " action status"
"yAxisFormat" = "s %s"
}
query {
sort " uuid":{ string } value asc
}
pivot #54bf8c61578d4bdcb6a3086f7abd5725 max 1000 rows 25 columns {
sort as tree {
column 0 desc
" action status" asc
"Specialisme" asc
"CreateDate" asc
" page type" asc
"Aanvangs datum" desc
"Aanvangs jaarmaand" asc
"Specialisme code" asc
" title" asc
" pivotdata" asc
"Norm" asc
" owner" asc
"Module" asc
" page name" asc
} row fields {
"Module"
} column fields {
" action status"
data " pivotdata"
} value fields {
count " page type" format "s %s" target long as "Aantal"
}
do not include empty
do show row totals
do show column totals
norm is not upper bound
multivalue fast
not foldable
}
filters {
}
}
}
dashboard "Aantal openstaande acties per module" #eed783319af34d12aded52a22a4f8a55 {
kpi #e8ccab13817647a39445b38b047254f1 type "DRILLDOWNPIVOT" {
query {
sort " uuid":{ string } value asc
}
pivot #eddab7b15c394c93b3cfec2b8d47bf19 max 1000 rows 25 columns {
sort as tree {
column 0 desc
"VC opmerking" asc
"Specialisme code" asc
" title" asc
" pivotdata" asc
" owner" asc
"Module" asc
} row fields {
"Module"
} column fields {
data " pivotdata"
} value fields {
page count " page name" format "j %,d" target long as "Aantal"
}
do not include empty
do show row totals
do show column totals
norm is not upper bound
multivalue fast
not foldable
}
filters {
}
}
}
}
} queries {
base = query {
filter " rule status":{ enum } == "Geaccepteerd" and " page name":{ string } starts with "R"
facets {
standard " organization structure" {
sort value desc expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children
}
standard "Specialisme" {
sort value desc expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children
}
standard "Module" {
sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children
}
standard " title" {
sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children
}
standard "Schadelastjaar" {
sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children
}
standard "RVE" {
sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children
}
standard "Controle/norm" {
sort value desc expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children
}
standard " owner" {
sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children
}
standard " page type" {
sort value desc expanded not visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children
children {
standard "action" {
sort value desc expanded visible checked count not estimated dont want child labels updated allow change type to date not available as date max 5 children has no more children
}
}
}
standard "Patientnr" {
sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children
}
standard "Handreiking" {
sort value desc expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children
}
standard "DOT Controle Regel" {
sort value desc expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children
}
standard " action status" {
sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children
children {
standard "Open" {
sort value desc expanded visible checked count not estimated dont want child labels updated allow change type to date not available as date max 5 children has no more children
}
}
}
standard " ignored" {
sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children
children {
standard "Nee" {
sort value desc expanded visible checked count not estimated dont want child labels updated allow change type to date not available as date max 5 children has no more children
}
}
}
standard " parked" {
sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children
children {
standard "Nee" {
sort value desc expanded visible checked count not estimated dont want child labels updated allow change type to date not available as date max 5 children has no more children
}
}
}
standard " workflow" {
sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children
children {
standard "Nee" {
sort value desc expanded visible checked count not estimated dont want child labels updated allow change type to date not available as date max 5 children has no more children
}
}
}
standard " comment" {
sort value desc not expanded visible not checked count not estimated want child labels updated allow change type to date not available as date max 5 children has no more children
}
}
sort " priority" asc, "id" visual desc
}
}
created by "ValueCare" at '1970-01-01 01:00:00.000'
updated by "ValueCare" at '1970-01-01 01:00:00.000'
company "ValueCare"
}
}