Logistic Corp - On Time Analysis

Link to this app
https://oaa.app.link/launch-app-541a45ae-59a4-4b7a-bb70-7060b1372c8e

Excel file for this app
https://www.dropbox.com/s/emodu7y0ppji4ev/Logistics%20Corp%20Demo.xlsx?dl=1&raw=1

640640

"Logistic Corp - On Time Analysis" Performance Dashboard

640640

"Logistic Corp - On Time Analysis" Data List

640640

"Logistic Corp - On Time Analysis" Dynamic Dashboard

App Definitions

backgroundcolor=#40494B;paddinghorz=0;paddingvert=0;dynamicdashboard=true;functionbuttoncolor=#e33b27;pagecount=2;topareaheight=20%;headeropacity=8;topareaimage=https://api.openasapp.net/v1/api/EntityImageStorage/AppStorage/541a45ae-59a4-4b7a-bb70-7060b1372c8e/public/topAreaImage-1a466d08035243f5b0cfb7edd542810d.gif;headerfade=true

Raw XML Configuration

<?xml version="1.0" encoding="utf-8"?>
<pages
    xmlns="urn:WunderApp">
    <page caption="Performance Dashboard" pageid="1" definitions="sheetname=APR16 Datasheet;backgroundcolor=40494B;functionbuttoncolor=CD575A;">
        <excelcontent id="1">
            <items>
                <item id="1ET5Uwke" caption="KPIs" contenttype="header">
                    <itemdefinitions>height=8%;backgroundcolor=33383E;textcolor=white;textfontsize=21;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="groupAll" contenttype="grouplayout" inputtype="output">
                    <itemdefinitions>buttonheight=200;metrictext=;separatorcolor=transparent;bordercolor=transparent;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="OTD-Performance" contenttype="chart" inputtype="output" address="OTD-Performance!A10:B11">
                    <itemdefinitions>groupname=groupAll;height=240;charttype=pie;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=gray;seriescolor=#09679b;showlegend=true;colorpalette=EC7063,3CC795,EDAD52,21BADA;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="On Time Vessel" contenttype="chart" inputtype="output" address="OnTimeVessel!A10:B11">
                    <itemdefinitions>groupname=groupAll;height=240;charttype=pie;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=gray;seriescolor=#09679b;showlegend=true;colorpalette=EDAD52,21BADA,3CC795,EC7063;showeditbuttons=true;</itemdefinitions>
                </item>
                <item id="1ET5Uwcr" caption="OTD-Performance by pickup location" contenttype="header">
                    <itemdefinitions>height=8%;backgroundcolor=33383E;textcolor=white;textfontsize=21;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="group1" contenttype="grouplayout" inputtype="output">
                    <itemdefinitions>buttonheight=200;metrictext=;separatorcolor=transparent;bordercolor=transparent;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Bielefeld" contenttype="chart" inputtype="output" address="OTD-Performance!A14:B15">
                    <itemdefinitions>groupname=group1;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=#808080;seriescolor=#09679b;showlegend=true;colorpalette=EC7063,3CC795,EDAD52,21BADA;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="New York" contenttype="chart" inputtype="output" address="OTD-Performance!A18:B19">
                    <itemdefinitions>groupname=group1;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=#808080;seriescolor=#f7af2a;showlegend=true;colorpalette=EC7063,3CC795,EDAD52,21BADA;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="group2" contenttype="grouplayout" inputtype="output">
                    <itemdefinitions>buttonheight=200;metrictext=;separatorcolor=transparent;bordercolor=transparent;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Trier" contenttype="chart" inputtype="output" address="OTD-Performance!A22:B23">
                    <itemdefinitions>groupname=group2;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=#808080;seriescolor=#f7af2a;showlegend=true;colorpalette=EC7063,3CC795,EDAD52,21BADA;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="spacer" contenttype="spacer" inputtype="">
                    <itemdefinitions>groupname=group2;height=3%;showeditbuttons=true;</itemdefinitions>
                </item>
                <item id="1ET5Uw12" caption="OTD-Performance by destination" contenttype="header">
                    <itemdefinitions>height=8%;backgroundcolor=33383E;textcolor=white;textfontsize=21;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="group3" contenttype="grouplayout" inputtype="output">
                    <itemdefinitions>buttonheight=200;metrictext=;separatorcolor=transparent;bordercolor=transparent;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Atlanta, GA, US" contenttype="chart" inputtype="output" address="OTD-Performance!A41:B42">
                    <itemdefinitions>groupname=group3;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=#808080;seriescolor=#f7af2a;showlegend=true;colorpalette=EC7063,3CC795,EDAD52,21BADA;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Baltimore, MD, US" contenttype="chart" inputtype="output" address="OTD-Performance!A45:B46">
                    <itemdefinitions>groupname=group3;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=#808080;seriescolor=#f7af2a;showlegend=true;colorpalette=EC7063,3CC795,EDAD52,21BADA;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="group4" contenttype="grouplayout" inputtype="output">
                    <itemdefinitions>buttonheight=200;metrictext=;separatorcolor=transparent;bordercolor=transparent;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Chiba, JP" contenttype="chart" inputtype="output" address="OTD-Performance!A49:B50">
                    <itemdefinitions>groupname=group4;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=gray;seriescolor=#f7af2a;showlegend=true;colorpalette=EC7063,3CC795,EDAD52,21BADA;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Manila, PH" contenttype="chart" inputtype="output" address="OTD-Performance!A53:B54">
                    <itemdefinitions>groupname=group4;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=gray;seriescolor=#f7af2a;showlegend=true;colorpalette=EC7063,3CC795,EDAD52,21BADA;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="group5" contenttype="grouplayout" inputtype="output">
                    <itemdefinitions>buttonheight=200;metrictext=;separatorcolor=transparent;bordercolor=transparent;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Manzanillo, PA" contenttype="chart" inputtype="output" address="OTD-Performance!A57:B58">
                    <itemdefinitions>groupname=group5;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=gray;seriescolor=#f7af2a;showlegend=true;colorpalette=EC7063,3CC795,EDAD52,21BADA;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Tokyo, JP" contenttype="chart" inputtype="output" address="OTD-Performance!A61:B62">
                    <itemdefinitions>groupname=group5;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=gray;seriescolor=#f7af2a;showlegend=true;colorpalette=EC7063,3CC795,EDAD52,21BADA;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="group6" contenttype="grouplayout" inputtype="output">
                    <itemdefinitions>buttonheight=200;metrictext=;separatorcolor=transparent;bordercolor=transparent;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Veracruz, MX" contenttype="chart" inputtype="output" address="OTD-Performance!A65:B66">
                    <itemdefinitions>groupname=group6;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=gray;seriescolor=#f7af2a;showlegend=true;colorpalette=EC7063,3CC795,EDAD52,21BADA;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="spacer" contenttype="spacer" inputtype="">
                    <itemdefinitions>groupname=group6;height=3%;showeditbuttons=true;</itemdefinitions>
                </item>
                <item id="1ET5Uw13" caption="OTD-Performance by carrier" contenttype="header">
                    <itemdefinitions>height=8%;backgroundcolor=33383E;textcolor=white;textfontsize=21;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="groupCarrier" contenttype="grouplayout" inputtype="output">
                    <itemdefinitions>buttonheight=200;metrictext=;separatorcolor=transparent;bordercolor=transparent;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Sample Carrier" contenttype="chart" inputtype="output" address="OTD-Performance!A80:B81">
                    <itemdefinitions>groupname=groupCarrier;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=gray;seriescolor=#f7af2a;showlegend=true;colorpalette=EC7063,3CC795,EDAD52,21BADA;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="spacer" contenttype="spacer" inputtype="">
                    <itemdefinitions>groupname=groupCarrier;height=3%;showeditbuttons=true;</itemdefinitions>
                </item>
                <item id="1ET5Uwck" caption="On Time Vessel by pickup location" contenttype="header">
                    <itemdefinitions>height=8%;backgroundcolor=33383E;textcolor=white;textfontsize=21;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="group21" contenttype="grouplayout" inputtype="output">
                    <itemdefinitions>buttonheight=200;metrictext=;separatorcolor=transparent;bordercolor=transparent;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Bielefeld" contenttype="chart" inputtype="output" address="OnTimeVessel!A14:B15">
                    <itemdefinitions>groupname=group21;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=#808080;seriescolor=#09679b;showlegend=true;colorpalette=EDAD52,21BADA,3CC795,EC7063;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="New York" contenttype="chart" inputtype="output" address="OnTimeVessel!A18:B19">
                    <itemdefinitions>groupname=group21;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=#808080;seriescolor=#f7af2a;showlegend=true;colorpalette=EDAD52,21BADA,3CC795,EC7063;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="group22" contenttype="grouplayout" inputtype="output">
                    <itemdefinitions>buttonheight=200;metrictext=;separatorcolor=transparent;bordercolor=transparent;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Trier" contenttype="chart" inputtype="output" address="OnTimeVessel!A22:B23">
                    <itemdefinitions>groupname=group22;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=#808080;seriescolor=#f7af2a;showlegend=true;colorpalette=EDAD52,21BADA,3CC795,EC7063;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="spacer" contenttype="spacer" inputtype="">
                    <itemdefinitions>groupname=group22;height=3%;showeditbuttons=true;</itemdefinitions>
                </item>
                <item id="1ET5Uw12" caption="On Time Vessel by destination" contenttype="header">
                    <itemdefinitions>height=8%;backgroundcolor=33383E;textcolor=white;textfontsize=21;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="group23" contenttype="grouplayout" inputtype="output">
                    <itemdefinitions>buttonheight=200;metrictext=;separatorcolor=transparent;bordercolor=transparent;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Atlanta, GA, US" contenttype="chart" inputtype="output" address="OnTimeVessel!A41:B42">
                    <itemdefinitions>groupname=group23;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=#808080;seriescolor=#09679b;showlegend=true;colorpalette=EDAD52,21BADA,3CC795,EC7063;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Baltimore, MD, US" contenttype="chart" inputtype="output" address="OnTimeVessel!A45:B46">
                    <itemdefinitions>groupname=group23;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=#808080;seriescolor=#f7af2a;showlegend=true;colorpalette=EDAD52,21BADA,3CC795,EC7063;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="group24" contenttype="grouplayout" inputtype="output">
                    <itemdefinitions>buttonheight=200;metrictext=;separatorcolor=transparent;bordercolor=transparent;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Chiba, JP" contenttype="chart" inputtype="output" address="OnTimeVessel!A49:B50">
                    <itemdefinitions>groupname=group24;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=gray;seriescolor=#f7af2a;showlegend=true;colorpalette=EDAD52,21BADA,3CC795,EC7063;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Manila, PH" contenttype="chart" inputtype="output" address="OnTimeVessel!A53:B54">
                    <itemdefinitions>groupname=group24;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=gray;seriescolor=#f7af2a;showlegend=true;colorpalette=EDAD52,21BADA,3CC795,EC7063;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="group25" contenttype="grouplayout" inputtype="output">
                    <itemdefinitions>buttonheight=200;metrictext=;separatorcolor=transparent;bordercolor=transparent;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Manzanillo, PA" contenttype="chart" inputtype="output" address="OnTimeVessel!A57:B58">
                    <itemdefinitions>groupname=group25;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=gray;seriescolor=#f7af2a;showlegend=true;colorpalette=EDAD52,21BADA,3CC795,EC7063;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Tokyo, JP" contenttype="chart" inputtype="output" address="OnTimeVessel!A61:B62">
                    <itemdefinitions>groupname=group25;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=gray;seriescolor=#f7af2a;showlegend=true;colorpalette=EDAD52,21BADA,3CC795,EC7063;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="group26" contenttype="grouplayout" inputtype="output">
                    <itemdefinitions>buttonheight=200;metrictext=;separatorcolor=transparent;bordercolor=transparent;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Veracruz, MX" contenttype="chart" inputtype="output" address="OnTimeVessel!A65:B66">
                    <itemdefinitions>groupname=group26;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=gray;seriescolor=#f7af2a;showlegend=true;colorpalette=EDAD52,21BADA,3CC795,EC7063;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="spacer" contenttype="spacer" inputtype="">
                    <itemdefinitions>groupname=group26;height=3%;showeditbuttons=true;</itemdefinitions>
                </item>
                <item id="1ET5Uw13" caption="On Time Vessel by carrier" contenttype="header">
                    <itemdefinitions>height=8%;backgroundcolor=33383E;textcolor=white;textfontsize=21;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="group2Carrier" contenttype="grouplayout" inputtype="output">
                    <itemdefinitions>buttonheight=200;metrictext=;separatorcolor=transparent;bordercolor=transparent;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Sample Carrier" contenttype="chart" inputtype="output" address="OnTimeVessel!A80:B81">
                    <itemdefinitions>groupname=group2Carrier;height=240;charttype=donut;backgroundcolor=transparent;titletextcolor=white;legendtextcolor=gray;seriescolor=#f7af2a;showlegend=true;colorpalette=EDAD52,21BADA,3CC795,EC7063;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="spacer" contenttype="spacer" inputtype="">
                    <itemdefinitions>groupname=group2Carrier;height=3%;showeditbuttons=true;</itemdefinitions>
                </item>
            </items>
        </excelcontent>
    </page>
    <page caption="Data List" pageid="2" definitions="sheetname=APR16 Datasheet;summarywidth=110;summaryopacity=6;summarybackgroundcolor=AC190D;">
        <excelcontent id="2">
            <items>
                <item caption="" contenttype="list" id="D3lbjp16" inputtype="">
                    <itemdefinitions>componentname=list;padding=4;height=;gridrowheight=40;gridcollapsegroups=false;gridallowedit=false;metrictext=;menuentries=send,print;headeravailable=true;showcolumnheader=true;drilldowncolumns=10,5,7,6,11,15,17,9,1,16,12,13,8,4,2,28,29,24,25,23,19,21,20,27;searchcolumns=;listcolumns=17::,13::,10::,5::date,7::,11::,12::,15::,16::,29::,18::;detailcolumns=17:,10:,11:,12:,13:,5:date,7:date,15:,16:,29:,1:,8:date,2:,4:,9:date,19:date,20:date,21:date,23:date,24:date,25:date,27:date,6:,14:,28:;listheaderblock=A1:AD1;listdatablock=A2:AD2;showeditbuttons=true;gridtheme=dark;</itemdefinitions>
                </item>
            </items>
        </excelcontent>
    </page>
</pages>

Card Definitions

cardbackgroundimage=https://api.openasapp.net/v1/api/EntityImageStorage/AppStorage/541a45ae-59a4-4b7a-bb70-7060b1372c8e/public/cardBackgroundImage.gif?v=JQDZy7f0;cardheight=140;carddescriptionhide=true;cardcaptionbackgroundcolor=#0e40a5;cardbackgroundcolor=transparent;captionheight=50;captionopacity=6