Business Report

Link to the app
https://oaa.app.link/launch-app-ee847e13-4970-433b-a865-f387c0c7e484

📘

Grouped column chart with multiple series

height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=months;chartorientation=horizontal;showdatamarkers=false;showeditbuttons=B23:G23;seriescaptions=Budget,Forecast;showlegend=true;legendtextcolor=#ffffff;colorpalette=#edad52,#21BADA;buttonheight=33%;separatorcolor=white;groupname=vixdCcak;
640640

Grouped column chart with multiple series

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

640640

"Business Report" Overview Dashboard

640640

"Business Report" Regions Dashboard

640640

"Business Report" Details List

640640

"Business Report" Dynamic Dashboard Generated from List Data

App Definitions

backgroundcolor=40494B;topareaheight=20%;paddinghorz=0;paddingvert=0;functionbuttoncolor=#f39a1d;headeropacity=8;pagecount=3;printsheet=Report Summary;menuentries=print;headerfade=true;topareaimage=https://api.openasapp.net/v1/api/EntityImageStorage/AppStorage/ee847e13-4970-433b-a865-f387c0c7e484/public/topAreaImage-8e4f782da14f4de68b13b45aaa298500.jpeg

Raw XML Configuration

<?xml version="1.0" encoding="utf-8"?>
<pages
    xmlns="urn:WunderApp">
    <page caption="Overview" pageid="1" definitions="sheetname=Report Summary;summarywidth=110;summaryopacity=6;summarybackgroundcolor=AC190D;">
        <excelcontent id="1">
            <caption>Allgemein</caption>
            <description>Allgemein</description>
            <definitions>buttonopacity=9;separatorcolor=CFCFCF;elementcolor=39A83C;valuetextcolor=39A83C;</definitions>
            <items>
                <item caption="qiSy6ImI" contenttype="grouplayout" id="qiSy6ImI" inputtype="output">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item caption="Turnover Sales - current month" contenttype="chart" id="LaFP5E2h" inputtype="output" address="B4:D4;B21:D21">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=#00000000;numberformat=N0;month;chartorientation=horizontal;colorpalette=#d32531;showeditbuttons=B4:D4;groupname=qiSy6ImI;titletextcolor=#ffffff;yaxiscaption= [kEURO];xaxiscaption=current;</itemdefinitions>
                </item>
                <item caption="Delta" contenttype="result" id="jBiT7phZ" inputtype="output" address="E21">
                    <itemdefinitions>nocaption=true;backgroundcolor=#40494b;usecellformat=true;buttonheight=55;valuefontsize=15;groupname=qiSy6ImI;elementwidth=80;captionhorzalign=center;</itemdefinitions>
                </item>
                <item caption="PDR0HFAM" contenttype="grouplayout" id="PDR0HFAM" inputtype="output">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item caption="Turnover Sales - accumulated" contenttype="chart" id="JPSBtUMO" inputtype="output" address="G4:I4;G21:I21">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=accumulated;chartorientation=horizontal;numberformat=N0;colorpalette=#d32531;showeditbuttons=G4:I4;showlegend=false;legendtextcolor=#ffffff;groupname=PDR0HFAM;</itemdefinitions>
                </item>
                <item caption="Delta" contenttype="result" id="I7QDgI7S" inputtype="output" address="J21">
                    <itemdefinitions>nocaption=true;backgroundcolor=#40494b;usecellformat=true;buttonheight=55;valuefontsize=15;groupname=PDR0HFAM;elementwidth=80;captionhorzalign=center;</itemdefinitions>
                </item>
                <item caption="KNKi4Lr0" contenttype="grouplayout" id="KNKi4Lr0" inputtype="output">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item caption="Turnover sales area A - current month" contenttype="chart" id="MUqY3N5c" inputtype="output" address="B4:D4;B12:D12">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=current month;chartorientation=horizontal;colorpalette=#21bada;showeditbuttons=B4:E4;groupname=KNKi4Lr0;</itemdefinitions>
                </item>
                <item caption="Delta" contenttype="integer" id="HcnSTXbJ" inputtype="output" address="E12">
                    <itemdefinitions>backgroundcolor=#40494b;elementcolor=#09679b;valuetextcolor=#ffffff;showeditbuttons=true;numberformat=P0;buttonheight=55;valuefontsize=15;groupname=KNKi4Lr0;elementwidth=80;captionhorzalign=center;</itemdefinitions>
                </item>
                <item caption="HXxzhti7" contenttype="grouplayout" id="HXxzhti7" inputtype="output">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item caption="Turnover sales area A - accumulated" contenttype="chart" id="N5EmaeYp" inputtype="output" address="G4:I4;G12:I12">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=accumulated;chartorientation=horizontal;colorpalette=#2172da;showeditbuttons=G4:I4;groupname=HXxzhti7;</itemdefinitions>
                </item>
                <item caption="Delta" contenttype="result" id="3vtlZAJL" inputtype="output" address="J12">
                    <itemdefinitions>nocaption=true;backgroundcolor=#40494b;usecellformat=true;buttonheight=55;valuefontsize=15;valuetextcolor=#ffffff;groupname=HXxzhti7;elementwidth=80;captionhorzalign=center;</itemdefinitions>
                </item>
                <item caption="oqWEKO8E" contenttype="grouplayout" id="oqWEKO8E" inputtype="output">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item caption="Turnover sales R&amp;D - current month" contenttype="chart" id="WBDyRZEK" inputtype="output" address="B4:E4;B19:D19">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=currrent month;chartorientation=horizontal;colorpalette=#ec7063;showeditbuttons=G4:I4;groupname=oqWEKO8E;</itemdefinitions>
                </item>
                <item caption="Delta" contenttype="result" id="HMJ0dGRj" inputtype="output" address="E19">
                    <itemdefinitions>nocaption=true;backgroundcolor=#40494b;usecellformat=true;buttonheight=55;valuefontsize=15;valuetextcolor=#ffffff;groupname=oqWEKO8E;elementwidth=80;captionhorzalign=center;</itemdefinitions>
                </item>
                <item caption="J4bsk9Jv" contenttype="grouplayout" id="J4bsk9Jv" inputtype="output">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item caption="Turnover sales R&amp;D - accumulated" contenttype="chart" id="OWxERfnY" inputtype="output" address="G4:I4;G19:I19">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=accumulated;chartorientation=horizontal;colorpalette=#db5c8d;showeditbuttons=G4:I4;groupname=J4bsk9Jv;</itemdefinitions>
                </item>
                <item caption="Delta" contenttype="result" id="Nbfi1F8U" inputtype="output" address="J19">
                    <itemdefinitions>nocaption=true;backgroundcolor=#40494b;usecellformat=true;valuetextcolor=#ffffff;buttonheight=55;valuefontsize=15;groupname=J4bsk9Jv;elementwidth=80;captionhorzalign=center;</itemdefinitions>
                </item>
                <item id="vixdCcak" caption="vixdCcak" inputtype="output" contenttype="grouplayout">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item caption="Turnover outlook" contenttype="chart" id="WgbEGocj" inputtype="output" address="B23:F23;B24:F24;B25:F25">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=months;chartorientation=horizontal;showdatamarkers=false;showeditbuttons=B23:G23;seriescaptions=Budget,Forecast;showlegend=true;legendtextcolor=#ffffff;colorpalette=#edad52,#21BADA;buttonheight=33%;separatorcolor=white;groupname=vixdCcak;</itemdefinitions>
                </item>
                <item id="AE27585v" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=25%;backgroundcolor=#00000000;groupname=vixdCcak;elementwidth=1;</itemdefinitions>
                </item>
                <item id="NhKubkf9" caption="NhKubkf9" inputtype="output" contenttype="grouplayout">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;paddingright=45;paddingleft=45;</itemdefinitions>
                </item>
                <item caption="Deal Funnel" contenttype="chart" id="N7tzSADQ" inputtype="output" address="A31:B35">
                    <itemdefinitions>height=240;charttype=funnel;backgroundcolor=transparent;titletextcolor=white;colorpalette=f88f8f,83abe3,84e383,e886c0,83cde3;showeditbuttons=A31:A3;showlegend=true;legendtextcolor=#ffffff;buttonheight=33;separatorcolor=CFCFCF;groupname=NhKubkf9;</itemdefinitions>
                </item>
                <item id="lAF66jgQ" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=25%;backgroundcolor=#00000000;groupname=NhKubkf9;separatorcolor=CFCFCF;elementwidth=1;</itemdefinitions>
                </item>
                <item caption="Customer Satisfaction" contenttype="chart" id="UIagsZpZ" inputtype="output" address="A39:B43">
                    <itemdefinitions>height=240;charttype=polar;backgroundcolor=transparent;titletextcolor=white;colorpalette=#18a4f2;</itemdefinitions>
                </item>
            </items>
        </excelcontent>
    </page>
    <page caption="Regions" pageid="2" definitions="sheetname=Regionen Charts;">
        <excelcontent id="2">
            <items>
                <item caption="0WnFcmjk" contenttype="grouplayout" id="0WnFcmjk" inputtype="output">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item caption="EU1" contenttype="chart" id="wu0UJkR31" inputtype="output" address="B5:D5">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=current;chartorientation=horizontal;colorpalette=#6cce3e;groupname=0WnFcmjk;</itemdefinitions>
                </item>
                <item caption="EU1" contenttype="chart" id="tZ8reUCN1" inputtype="output" address="H5:J5">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=accumulated;chartorientation=horizontal;colorpalette=#3cc795;groupname=0WnFcmjk;</itemdefinitions>
                </item>
                <item caption="m3Ogs1Se" contenttype="grouplayout" id="m3Ogs1Se" inputtype="output">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item caption="EU2" contenttype="chart" id="wu0UJkR32" inputtype="output" address="B8:D8">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=current;chartorientation=horizontal;colorpalette=#6cce3e;groupname=m3Ogs1Se;</itemdefinitions>
                </item>
                <item caption="EU2" contenttype="chart" id="tZ8reUCN2" inputtype="output" address="H8:J8">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=accumulated;chartorientation=horizontal;colorpalette=#3cc795;groupname=m3Ogs1Se;</itemdefinitions>
                </item>
                <item caption="3HO5o3xe" contenttype="grouplayout" id="3HO5o3xe" inputtype="output">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item caption="EU3" contenttype="chart" id="wu0UJkR33" inputtype="output" address="B11:D11">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=current;chartorientation=horizontal;colorpalette=#6cce3e;groupname=3HO5o3xe;</itemdefinitions>
                </item>
                <item caption="EU3" contenttype="chart" id="tZ8reUCN3" inputtype="output" address="H11:J11">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=accumulated;chartorientation=horizontal;colorpalette=#3cc795;groupname=3HO5o3xe;</itemdefinitions>
                </item>
                <item caption="YTQmX56h" contenttype="grouplayout" id="YTQmX56h" inputtype="output">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item caption="EU4" contenttype="chart" id="wu0UJkR4" inputtype="output" address="B14:D14">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=current;chartorientation=horizontal;colorpalette=#6cce3e;groupname=YTQmX56h;</itemdefinitions>
                </item>
                <item caption="EU4" contenttype="chart" id="tZ8reUCN4" inputtype="output" address="H14:J14">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=accumulated;chartorientation=horizontal;colorpalette=#3cc795;groupname=YTQmX56h;</itemdefinitions>
                </item>
                <item caption="0Ab2hmqW" contenttype="grouplayout" id="0Ab2hmqW" inputtype="output">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item caption="EU5" contenttype="chart" id="wu0UJkR35" inputtype="output" address="B17:D17">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=current;chartorientation=horizontal;colorpalette=#6cce3e;groupname=0Ab2hmqW;</itemdefinitions>
                </item>
                <item caption="EU5" contenttype="chart" id="tZ8reUCN5" inputtype="output" address="H17:J17">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=accumulated;chartorientation=horizontal;colorpalette=#3cc795;groupname=0Ab2hmqW;</itemdefinitions>
                </item>
                <item caption="J0bQezZN" contenttype="grouplayout" id="J0bQezZN" inputtype="output">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item caption="EU6" contenttype="chart" id="wu0UJkR36" inputtype="output" address="B20:D20">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=current;chartorientation=horizontal;colorpalette=#6cce3e;groupname=J0bQezZN;</itemdefinitions>
                </item>
                <item caption="EU6" contenttype="chart" id="tZ8reUCN6" inputtype="output" address="H20:J20">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=accumulated;chartorientation=horizontal;colorpalette=#3cc795;groupname=J0bQezZN;</itemdefinitions>
                </item>
                <item caption="LZRk479e" contenttype="grouplayout" id="LZRk479e" inputtype="output">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item caption="NA1" contenttype="chart" id="wu0UJkR37" inputtype="output" address="B23:D23">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=current;chartorientation=horizontal;colorpalette=#6cce3e;groupname=LZRk479e;</itemdefinitions>
                </item>
                <item caption="NA1" contenttype="chart" id="tZ8reUCN7" inputtype="output" address="H23:J23">
                    <itemdefinitions>height=240;charttype=column;backgroundcolor=transparent;titletextcolor=white;yaxiscaption= [kEURO];xaxiscaption=accumulated;chartorientation=horizontal;colorpalette=#3cc795;groupname=LZRk479e;</itemdefinitions>
                </item>
            </items>
        </excelcontent>
    </page>
    <page caption="Regions Details " pageid="3" definitions="sheetname=Regionen;summarywidth=110;summaryopacity=6;summarybackgroundcolor=AC190D;">
        <excelcontent id="1">
            <items>
                <item caption="" contenttype="list" id="08pY23Z7" inputtype="" address="A1">
                    <itemdefinitions>componentname=list;padding=0;gridtheme=dark;height=;gridrowheight=40;gridcollapsegroups=false;gridallowedit=false;metrictext=;menuentries=send,print;headeravailable=true;showcolumnheader=true;drilldowncolumns=2,1,3;sumcolumns=6;searchcolumns=;listcolumns=1::,2::,4::,3::,7::,8::,5::,9::,10::,6::,11::;detailcolumns=1,2,4,3,7,8,5,9,10,6,11;showsearchpanel=true;</itemdefinitions>
                </item>
            </items>
        </excelcontent>
    </page>
</pages>

Card Definitions

cardbackgroundimage=https://api.openasapp.net/v1/api/EntityImageStorage/AppStorage/ee847e13-4970-433b-a865-f387c0c7e484/public/cardBackgroundImage.jpeg?v=zALc4Yhj;cardheight=160;carddescriptionhide=true;cardcaptionbackgroundcolor=#608db0;cardbackgroundcolor=transparent;captionheight=50;captionopacity=8