8013 saved seach aantal openstaande acties per module
Test dashboard 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"
}
}