mB Pat Vachon, Champion
-
42,926 Points
Posted 1 year ago
mB Pat Vachon, Champion
-
42,926 Points
The snippet doesn't run when the series model doesn't have any data/points.
Stephen Sells, Official Rep
-
17,316 Points
mB Pat Vachon, Champion
-
42,926 Points
Stephen Sells, Official Rep
-
17,316 Points
Stephen Sells, Official Rep
-
17,316 Points
mB Pat Vachon, Champion
-
42,926 Points
<skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="false" useviewportmeta="true" showheader="false" theme="Lightning Design"> <models> <model id="UIOnly" query="true" createrowifnonefound="true" datasource="Ui-Only" processonclient="true" unloadwarningifunsavedchanges="false"> <fields> <field id="ADPLastNValue" displaytype="TEXT" ogdisplaytype="TEXT" readonly="false" returntype="DOUBLE" precision="9" scale="0" defaultvaluetype="fieldvalue" label="ADPLastNValue"/> <field id="ADPLastNLabel" displaytype="TEXT" label="ADPLastNLabel"/> <field id="DPLastNValue" displaytype="TEXT" label="DPLastNValue" ogdisplaytype="TEXT" precision="9" scale="0"/> <field id="DPLastNLabel" displaytype="TEXT" label="DPLastNLabel"/> </fields> <conditions/> <actions/> </model> <model id="FacilitiesRecordType" limit="1" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="RecordType"> <fields> <field id="Id"/> <field id="IsActive"/> <field id="Description"/> </fields> <conditions> <condition type="fieldvalue" value="Account" enclosevalueinquotes="true" field="SobjectType"/> <condition type="fieldvalue" value="Facilities" enclosevalueinquotes="true" field="Name" operator="="/> </conditions> <actions/> </model> <model id="AllAccounts" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account" doclone="" queryallrows="true"> <fields> <field id="Id"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="RecordTypeId" fieldtargetobjects="RecordType" operator="=" model="FacilitiesRecordType" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate" state="" inactive="false"/> <condition type="multiple" field="Sales_Region__c" operator="in" inactive="true" enclosevalueinquotes="true" name="__autofilter__Sales_Region__c" state="filterableoff" value=""/> <condition type="fieldvalue" value="On-boarding" enclosevalueinquotes="true" field="Dental_Marketing_Status__c" operator="=" state="off" inactive="true"/> <condition type="multiple" value="" field="Type" operator="in" enclosevalueinquotes="true" state="filterableoff" inactive="true" name="Type"> <values/> </condition> </conditions> <actions> <action> <actions> <action type="blockUI"/> <action type="requeryModels" behavior="standard"> <models> <model>AllAccountsAgg</model> <model>AllAccountsAggByStatusActive</model> <model>AllAccountsAggByStatusInactive</model> <model>AllAccountsAggByStatusDeclined</model> <model>AllAccountsAggByStatusProspect</model> <model>Dental_Accounts</model> <model>Dental_Accounts_OB</model> <model>Dental_Accounts_CR</model> <model>Dental_Accounts_20</model> <model>Dental_Accounts_30</model> <model>Dental_Accounts_40</model> <model>Dental_Accounts_50</model> <model>DentalActiveSummary</model> <model>ActiveDentalPatients</model> <model>ActiveDentalProspects</model> </models> <onerroractions> <action type="blockUI" message="There was an error with query" timeout="3000"/> </onerroractions> </action> <action type="custom" snippet="calcLastValsLabels"> <onerroractions> <action type="blockUI" message="There was an error in calcLastValsLabels snippet" timeout="3000"/> </onerroractions> </action> <action type="unblockUI"/> </actions> <events> <event>models.loaded</event> </events> </action> </actions> <groupby method="simple"/> </model> <model id="AllAccountsAgg" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Account"> <fields> <field id="Id" name="FacilityCount" function="COUNT"/> <field id="Bed_Count__c" name="BedCount" function="SUM"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" operator="in" model="AllAccounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> </conditions> <actions> <action> <actions/> <events> <event>models.loaded</event> </events> </action> </actions> <groupby method="simple"/> </model> <model id="AllAccountsAggByStatusActive" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Account"> <fields> <field id="Id" name="FacilityCount" function="COUNT"/> <field id="Bed_Count__c" name="BedCount" function="SUM"/> <field id="FacilityPercent" uionly="true" displaytype="FORMULA" ogdisplaytype="TEXT" readonly="true" returntype="DOUBLE" precision="9" scale="1"> <formula>{{FacilityCount}}/{{$Model.AllAccountsAgg.data.0.FacilityCount}} *100</formula> </field> <field id="BedPercent" uionly="true" displaytype="FORMULA" label="BedPercent" ogdisplaytype="TEXT" readonly="true" returntype="DOUBLE" precision="9" scale="1"> <formula>{{BedCount}}/{{$Model.AllAccountsAgg.data.0.BedCount}} *100</formula> </field> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" operator="in" model="AllAccounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> <condition type="fieldvalue" value="Active" enclosevalueinquotes="true" field="Dental_Status__c"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="AllAccountsAggByStatusInactive" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Account"> <fields> <field id="Id" name="FacilityCount" function="COUNT"/> <field id="Bed_Count__c" name="BedCount" function="SUM"/> <field id="FacilityPercent" uionly="true" displaytype="FORMULA" ogdisplaytype="TEXT" readonly="true" returntype="DOUBLE" precision="9" scale="1"> <formula>{{FacilityCount}}/{{$Model.AllAccountsAgg.data.0.FacilityCount}} *100</formula> </field> <field id="BedPercent" uionly="true" displaytype="FORMULA" label="BedPercent" ogdisplaytype="TEXT" readonly="true" returntype="DOUBLE" precision="9" scale="1"> <formula>{{BedCount}}/{{$Model.AllAccountsAgg.data.0.BedCount}} *100</formula> </field> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" operator="in" model="AllAccounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> <condition type="fieldvalue" value="Inactive" enclosevalueinquotes="true" field="Dental_Status__c"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="AllAccountsAggByStatusDeclined" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Account"> <fields> <field id="Id" name="FacilityCount" function="COUNT"/> <field id="Bed_Count__c" name="BedCount" function="SUM"/> <field id="FacilityPercent" uionly="true" displaytype="FORMULA" ogdisplaytype="TEXT" readonly="true" returntype="DOUBLE" precision="9" scale="1"> <formula>{{FacilityCount}}/{{$Model.AllAccountsAgg.data.0.FacilityCount}} *100</formula> </field> <field id="BedPercent" uionly="true" displaytype="FORMULA" label="BedPercent" ogdisplaytype="TEXT" readonly="true" returntype="DOUBLE" precision="9" scale="1"> <formula>{{BedCount}}/{{$Model.AllAccountsAgg.data.0.BedCount}} *100</formula> </field> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" operator="in" model="AllAccounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> <condition type="fieldvalue" value="Declined" enclosevalueinquotes="true" field="Dental_Status__c"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="AllAccountsAggByStatusProspect" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Account"> <fields> <field id="Id" name="FacilityCount" function="COUNT"/> <field id="Bed_Count__c" name="BedCount" function="SUM"/> <field id="FacilityPercent" uionly="true" displaytype="FORMULA" ogdisplaytype="TEXT" readonly="true" returntype="DOUBLE" precision="9" scale="1"> <formula>{{FacilityCount}}/{{$Model.AllAccountsAgg.data.0.FacilityCount}} *100</formula> </field> <field id="BedPercent" uionly="true" displaytype="FORMULA" label="BedPercent" ogdisplaytype="TEXT" readonly="true" returntype="DOUBLE" precision="9" scale="1"> <formula>{{BedCount}}/{{$Model.AllAccountsAgg.data.0.BedCount}} *100</formula> </field> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" operator="in" model="AllAccounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> <condition type="fieldvalue" value="Prospect" enclosevalueinquotes="true" field="Dental_Status__c"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="AllFacilityAccountsStatusNotActInaDecPros" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account"> <fields> <field id="Name"/> <field id="Dental_Status__c"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" operator="in" model="AllAccounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> <condition type="multiple" value="" field="Dental_Status__c" operator="not in" enclosevalueinquotes="true"> <values> <value>Active</value> <value>Inactive</value> <value>Declined</value> <value>Prospect</value> </values> </condition> </conditions> <actions/> <groupby method="simple"/> </model> <model id="Dental_Accounts" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account"> <fields> <field id="Sales_Region__c"/> <field id="Type"/> <field id="Name"/> <field id="Dental_Marketing_Status__c"/> <field id="Dental_Status__c"/> <field id="Dental_Status_Age__c"/> <field id="Id"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" operator="in" model="AllAccounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="Dental_Accounts_OB" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account"> <fields> <field id="Sales_Region__c"/> <field id="Type"/> <field id="Name"/> <field id="Dental_Marketing_Status__c"/> <field id="Dental_Status__c"/> <field id="Dental_Status_Age__c"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" fieldtargetobjects="RecordType" operator="in" model="Dental_Accounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> <condition type="fieldvalue" value="On-boarding" enclosevalueinquotes="true" field="Dental_Marketing_Status__c"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="Dental_Accounts_CR" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account"> <fields> <field id="Sales_Region__c"/> <field id="Type"/> <field id="Name"/> <field id="Dental_Marketing_Status__c"/> <field id="Dental_Status__c"/> <field id="Dental_Status_Age__c"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" fieldtargetobjects="RecordType" operator="in" model="Dental_Accounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> <condition type="fieldvalue" value="Clinic Ready" enclosevalueinquotes="true" field="Dental_Marketing_Status__c"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="Dental_Accounts_20" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account"> <fields> <field id="Sales_Region__c"/> <field id="Type"/> <field id="Name"/> <field id="Dental_Marketing_Status__c"/> <field id="Dental_Status__c"/> <field id="Dental_Status_Age__c"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" fieldtargetobjects="RecordType" operator="in" model="Dental_Accounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="Dental_Accounts_30" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account"> <fields> <field id="Sales_Region__c"/> <field id="Type"/> <field id="Name"/> <field id="Dental_Marketing_Status__c"/> <field id="Dental_Status__c"/> <field id="Dental_Status_Age__c"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" fieldtargetobjects="RecordType" operator="in" model="Dental_Accounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="Dental_Accounts_40" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account"> <fields> <field id="Sales_Region__c"/> <field id="Type"/> <field id="Name"/> <field id="Dental_Marketing_Status__c"/> <field id="Dental_Status__c"/> <field id="Dental_Status_Age__c"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" fieldtargetobjects="RecordType" operator="in" model="Dental_Accounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="Dental_Accounts_50" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account"> <fields> <field id="Sales_Region__c"/> <field id="Type"/> <field id="Name"/> <field id="Dental_Marketing_Status__c"/> <field id="Dental_Status__c"/> <field id="Dental_Status_Age__c"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" fieldtargetobjects="RecordType" operator="in" model="Dental_Accounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="DentalActiveSummary" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Account"> <fields> <field id="Id" name="AccountCount" function="COUNT"/> <field id="Bed_Count__c" name="BedCount" function="SUM"/> <field id="Active_Dental_Patients__c" name="ActiveDentalPatients" function="SUM"/> <field id="Dental_Prospects__c" name="DentalProspects" function="SUM"/> <field id="Participation" uionly="true" displaytype="FORMULA" ogdisplaytype="TEXT" readonly="true" returntype="DOUBLE" precision="9" scale="1" label="Participation"> <formula>ROUND({{$Model.DentalActiveSummary.data.0.ActiveDentalPatients}}/{{$Model.DentalActiveSummary.data.0.BedCount}}*100)</formula> </field> </fields> <conditions> <condition type="fieldvalue" value="Active" enclosevalueinquotes="true" field="Dental_Status__c"/> <condition type="modelmerge" value="" field="Id" operator="in" model="Dental_Accounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="ActiveDentalPatients" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Account_Snapshot__c" orderby=""> <fields> <field id="Date" uionly="true" displaytype="FORMULA" label="Date" ogdisplaytype="TEXT" readonly="true" returntype="TEXT" datasource="salesforce"> <formula>IF({{{CALENDAR_MONTH}}}="1","Jan", IF({{{CALENDAR_MONTH}}}="2","Feb", IF({{{CALENDAR_MONTH}}}="3","Mar", IF({{{CALENDAR_MONTH}}}="4","Apr", IF({{{CALENDAR_MONTH}}}="5","May", IF({{{CALENDAR_MONTH}}}="6","June", IF({{{CALENDAR_MONTH}}}="7","July", IF({{{CALENDAR_MONTH}}}="8","Aug", IF({{{CALENDAR_MONTH}}}="9","Sept", IF({{{CALENDAR_MONTH}}}="10","Oct", IF({{{CALENDAR_MONTH}}}="11","Nov","Dec"))))))))))) +"-"+{{{DAY_IN_MONTH}}}+"-"+{{{CALENDAR_YEAR}}}</formula> </field> <field id="SortedDate" uionly="true" displaytype="FORMULA" label="SortedDate" ogdisplaytype="TEXT" readonly="true" returntype="TEXT" precision="9" scale="0"> <formula>{{{CALENDAR_YEAR}}}+ IF(LEN({{{CALENDAR_MONTH}}})=1,"0"+{{{CALENDAR_MONTH}}},{{{CALENDAR_MONTH}}})+ IF(LEN({{{DAY_IN_MONTH}}})=1,"0"+{{{DAY_IN_MONTH}}},{{{DAY_IN_MONTH}}})</formula> </field> <field id="Active_Dental_Patients__c" name="sumActiveDentalPatientsc" function="SUM"/> </fields> <conditions> <condition type="fieldvalue" value="LAST_N_DAYS:7" enclosevalueinquotes="false" field="CreatedDate" state="filterableon" inactive="false" name="Last7Days"/> <condition type="fieldvalue" value="LAST_N_MONTHS:3" enclosevalueinquotes="false" field="CreatedDate" state="filterableoff" inactive="true" name="Last3Months"/> <condition type="fieldvalue" value="NEXT_N_YEARS:1" enclosevalueinquotes="false" field="CreatedDate" state="filterableoff" inactive="true" name="Last1Year"/> <condition type="modelmerge" value="" field="Account__c" fieldtargetobjects="Account" operator="in" model="AllAccounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> </conditions> <actions/> <groupby method="simple"> <field id="CreatedDate" name="DAY_IN_YEAR" function="DAY_IN_YEAR"/> <field id="CreatedDate" name="CALENDAR_MONTH" function="CALENDAR_MONTH"/> <field id="CreatedDate" name="CALENDAR_YEAR" function="CALENDAR_YEAR"/> <field id="CreatedDate" name="DAY_IN_MONTH" function="DAY_IN_MONTH"/> </groupby> </model> <model id="DentalProspects" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Account_Snapshot__c" orderby=""> <fields> <field id="Date" uionly="true" displaytype="FORMULA" label="Date" ogdisplaytype="TEXT" readonly="true" returntype="TEXT" datasource="salesforce"> <formula>IF({{{CALENDAR_MONTH}}}="1","Jan", IF({{{CALENDAR_MONTH}}}="2","Feb", IF({{{CALENDAR_MONTH}}}="3","Mar", IF({{{CALENDAR_MONTH}}}="4","Apr", IF({{{CALENDAR_MONTH}}}="5","May", IF({{{CALENDAR_MONTH}}}="6","June", IF({{{CALENDAR_MONTH}}}="7","July", IF({{{CALENDAR_MONTH}}}="8","Aug", IF({{{CALENDAR_MONTH}}}="9","Sept", IF({{{CALENDAR_MONTH}}}="10","Oct", IF({{{CALENDAR_MONTH}}}="11","Nov","Dec"))))))))))) +"-"+{{{DAY_IN_MONTH}}}+"-"+{{{CALENDAR_YEAR}}}</formula> </field> <field id="SortedDate" uionly="true" displaytype="FORMULA" label="SortedDate" ogdisplaytype="TEXT" readonly="true" returntype="TEXT" precision="9" scale="0"> <formula>{{{CALENDAR_YEAR}}}+ IF(LEN({{{CALENDAR_MONTH}}})=1,"0"+{{{CALENDAR_MONTH}}},{{{CALENDAR_MONTH}}})+ IF(LEN({{{DAY_IN_MONTH}}})=1,"0"+{{{DAY_IN_MONTH}}},{{{DAY_IN_MONTH}}})</formula> </field> <field id="Dental_Prospects__c" name="sumDentalProspectsc" function="SUM"/> </fields> <conditions> <condition type="fieldvalue" value="LAST_N_DAYS:7" enclosevalueinquotes="false" field="CreatedDate" state="filterableon" inactive="false" name="Last7Days"/> <condition type="fieldvalue" value="LAST_N_MONTHS:3" enclosevalueinquotes="false" field="CreatedDate" state="filterableoff" inactive="true" name="Last3Months"/> <condition type="fieldvalue" value="NEXT_N_YEARS:1" enclosevalueinquotes="false" field="CreatedDate" state="filterableoff" inactive="true" name="Last1Year"/> <condition type="modelmerge" value="" field="Account__c" fieldtargetobjects="Account" operator="in" model="AllAccounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> </conditions> <actions/> <groupby method="simple"> <field id="CreatedDate" name="DAY_IN_YEAR" function="DAY_IN_YEAR"/> <field id="CreatedDate" name="CALENDAR_MONTH" function="CALENDAR_MONTH"/> <field id="CreatedDate" name="CALENDAR_YEAR" function="CALENDAR_YEAR"/> <field id="CreatedDate" name="DAY_IN_MONTH" function="DAY_IN_MONTH"/> </groupby> </model> </models> <components> <wrapper uniqueid="sk-1S_VFE-1897"> <components> <panelset type="standard" uniqueid="sk-1JLn1Y-803" scroll=""> <panels> <panel type="left" width="225px" uniqueid="logoPanel" cssclass="headerPanel"> <components> <image source="staticresource" uniqueid="sk-1JLo-4-810" datasource="salesforce" behavior="link" alt="MultiGen Health" resource="mgh_logo" resourceContentType="image/jpeg"> <styles> <styleitem type="itemsize"/> <styleitem type="border"/> </styles> <interactions> <interaction type="tap"> <action type="redirect" window="blank" url="http://multigenhealth.com/"/>; </interaction> </interactions> </image> </components> </panel> <panel cssclass="headerPanel"> <components> <filterset model="AllAccounts" searchmethod="server" searchbox="true" uniqueid="sk-vJxoV-618" position="right" emptysearchbehavior="query" instantfilters="false"> <filters> <filter type="multiselect" filteroffoptionlabel="--- Any ---" createfilteroffoption="true" affectcookies="false" autocompthreshold="25" conditionsource="auto" labelmode="auto" conditionfield="Sales_Region__c" conditionoperator="in"/> <filter type="multiselect" filteroffoptionlabel="--- Any ---" createfilteroffoption="true" affectcookies="false" autocompthreshold="25" conditionsource="manual" labelmode="manual" condition="Type" label="Account Type"> <sources> <source type="manual" effectsbehavior="justdefault"> <options> <option label="Long-Term Care" type="simple" value="Long-Term Care"/> <option label="Retirement" type="simple" value="Retirement"/> <option label="Corporation" type="simple" value="Corporation"/> </options> </source> </sources> </filter> </filters> <searchfields/> </filterset> </components> </panel> </panels> </panelset> </components> <styles> <styleitem type="background"/> <styleitem type="border" padding="top,"> <styles> <styleitem property="padding-top" value="10px"/> <styleitem property="box-sizing" value="border-box"/> </styles> </styleitem> <styleitem type="size"/> </styles> </wrapper> <richtext multiple="false" uniqueid="sk-1JJ9mP-706"> <contents><p style="text-align: center;"><strong><span style="font-size:48px;">Facilities</span></strong></p> </contents> </richtext> <wrapper uniqueid="sk-vgUGT-731"> <components> <wrapper uniqueid="sk-1SzXxe-1679"> <components> <grid uniqueid="sk-vlWSa-297" columngutter="10px" rowgutter="10px"> <divisions> <division behavior="flex" minwidth="100px" ratio="1" verticalalign="top"> <components> <wrapper uniqueid="sk-kh45C-629"> <components> <richtext multiple="false" uniqueid="sk-kghoD-585" model="AllAccountsAgg"> <contents><p style="text-align: center;"><span style="font-size:22px;"><span style="color:#e6ebed;">Total Facilities</span></span></p> <p style="text-align: center;"><span style="font-size:36px;"><span style="color:#ffffff;">{{FacilityCount}}</span></span></p> </contents> </richtext> </components> <styles> <styleitem type="background" bgtype="color"> <styles> <styleitem property="background-color" value="#033349"/> </styles> </styleitem> <styleitem type="border" margin="none" borders="all"> <styles> <styleitem property="border" value="10px solid #033349"/> <styleitem property="box-sizing" value="border-box"/> </styles> </styleitem> <styleitem type="size"/> </styles> </wrapper> </components> </division> <division behavior="flex" verticalalign="top" minwidth="100px" ratio="1"> <components> <wrapper uniqueid="sk-kh45C-629"> <components> <richtext multiple="false" uniqueid="sk-kghoD-585" model="AllAccountsAgg"> <contents><p style="text-align: center;"><span style="font-size:22px;"><span style="color:#e6ebed;">Total Beds</span></span></p> <p style="text-align: center;"><span style="font-size:36px;"><span style="color:#ffffff;">{{BedCount}}</span></span></p> </contents> </richtext> </components> <styles> <styleitem type="background" bgtype="color"> <styles> <styleitem property="background-color" value="#033349"/> </styles> </styleitem> <styleitem type="border" borders="all"> <styles> <styleitem property="border" value="10px solid #033349"/> <styleitem property="box-sizing" value="border-box"/> </styles> </styleitem> <styleitem type="size"/> </styles> </wrapper> </components> </division> </divisions> <styles> <styleitem type="background" bgtype="none"/> </styles> </grid> </components> <styles> <styleitem type="background"/> <styleitem type="border" borders="bottom,"> <styles> <styleitem property="border-bottom" value="10px solid #e6ebed"/> <styleitem property="box-sizing" value="border-box"/> </styles> </styleitem> <styleitem type="size"/> </styles> </wrapper> <grid uniqueid="sk-vcer--276" columngutter="10px" rowgutter="10px"> <divisions> <division behavior="flex" minwidth="300px" ratio="1" verticalalign="top"> <components> <wrapper uniqueid="sk-kh45C-629"> <components> <wrapper uniqueid="sk--vHRC-853"> <components> <richtext multiple="false" uniqueid="sk-kghoD-585" model="AllAccountsAggByStatusActive"> <contents><p><font color="#e6ebed"><span style="font-size: 22px;">Active</span></font></p> </contents> </richtext> </components> <styles> <styleitem type="background"/> <styleitem type="border" margin="bottom,"> <styles> <styleitem property="margin-bottom" value="10px"/> <styleitem property="box-sizing" value="border-box"/> </styles> </styleitem> <styleitem type="size"/> </styles> </wrapper> <grid uniqueid="sk--hCIG-872"> <divisions> <division behavior="flex" minwidth="75px" ratio="1" verticalalign="top"> <components> <template multiple="false" uniqueid="sk--ny5X-455" model="AllAccountsAggByStatusActive" allowhtml="true"> <contents><div float="left" class="nx-picker-icon-wrapper" title="bed" style=" color: white; "><i class="sk-webicon nx-picker-icon" aria-label="bed" role="img" handle="sk-webicon-font-awesome:bed"><svg width="30" height="30"><use xmlns:xlink="http://www.w3.org/1999/xlink"; xlink:href="/resource/skuid__IconsSVG/font-awesome/font-awesome.min.svg#home"></use></svg></i></div></contents> </template> <richtext multiple="false" uniqueid="sk--hL4V-893" model="AllAccountsAggByStatusActive"> <contents><p><span style="font-size:28px;"><span style="color:#ffffff;">{{FacilityCount}}</span></span></p> <p><span style="font-size:28px;"><span style="color:#ffffff;">{{FacilityPercent}}%</span></span></p> </contents> </richtext> </components> </division> <division behavior="flex" verticalalign="top" minwidth="75px" ratio="1"> <components> <template multiple="false" uniqueid="sk--m4UQ-394" allowhtml="true"> <contents><div class="nx-picker-icon-wrapper" title="bed" style="color: white; float: right; margin-right: 18px;"> <i class="sk-webicon nx-picker-icon" aria-label="bed" role="img" handle="sk-webicon-font-awesome:bed"> <svg width="30" height="30"><use xmlns:xlink="http://www.w3.org/1999/xlink"; xlink:href="/resource/skuid__IconsSVG/font-awesome/font-awesome.min.svg#bed"></use> </svg> </i> </div></contents> </template> <richtext multiple="false" uniqueid="sk--hS20-920" model="AllAccountsAggByStatusActive"> <contents><p style="text-align: right;"><span style="font-size:28px;"><span style="color:#ffffff;">{{BedCount}}</span></span></p> <p style="text-align: right;"><span style="font-size:28px;"><span style="color:#ffffff;">{{BedPercent}}%</span></span></p> </contents> </richtext> </components> </division> </divisions> <styles> <styleitem type="background" bgtype="none"/> </styles> </grid> </components> <styles> <styleitem type="background" bgtype="color"> <styles> <styleitem property="background-color" value="#033349"/> </styles> </styleitem> <styleitem type="border" borders="all"> <styles> <styleitem property="border" value="10px solid #033349"/> <styleitem property="box-sizing" value="border-box"/> </styles> </styleitem> <styleitem type="size"/> </styles> </wrapper> </components> </division> <division behavior="flex" minwidth="300px" ratio="1" verticalalign="top"> <components> <wrapper uniqueid="sk-kh45C-629"> <components> <wrapper uniqueid="sk--vHRC-853"> <components> <richtext multiple="false" uniqueid="sk-kghoD-585" model="AllAccountsAggByStatusInactive"> <contents><p><font color="#e6ebed"><span style="font-size: 22px;">Inactive</span></font></p> </contents> </richtext> </components> <styles> <styleitem type="background"/> <styleitem type="border" margin="bottom,"> <styles> <styleitem property="margin-bottom" value="10px"/> <styleitem property="box-sizing" value="border-box"/> </styles> </styleitem> <styleitem type="size"/> </styles> </wrapper> <grid uniqueid="sk--hCIG-872"> <divisions> <division behavior="flex" minwidth="75px" ratio="1" verticalalign="top"> <components> <template multiple="false" uniqueid="sk--ny5X-455" model="AllAccountsAggByStatusInactive" allowhtml="true"> <contents><div float="left" class="nx-picker-icon-wrapper" title="bed" style=" color: white; "><i class="sk-webicon nx-picker-icon" aria-label="bed" role="img" handle="sk-webicon-font-awesome:bed"><svg width="30" height="30"><use xmlns:xlink="http://www.w3.org/1999/xlink"; xlink:href="/resource/skuid__IconsSVG/font-awesome/font-awesome.min.svg#home"></use></svg></i></div></contents> </template> <richtext multiple="false" uniqueid="sk--hL4V-893" model="AllAccountsAggByStatusInactive"> <contents><p><span style="font-size:28px;"><span style="color:#ffffff;">{{FacilityCount}}</span></span></p> <p><span style="font-size:28px;"><span style="color:#ffffff;">{{FacilityPercent}}%</span></span></p> </contents> </richtext> </components> </division> <division behavior="flex" verticalalign="top" minwidth="75px" ratio="1"> <components> <template multiple="false" uniqueid="sk--m4UQ-394" allowhtml="true" model="AllAccountsAggByStatusInactive"> <contents><div class="nx-picker-icon-wrapper" title="bed" style="color: white; float: right; margin-right: 18px;"> <i class="sk-webicon nx-picker-icon" aria-label="bed" role="img" handle="sk-webicon-font-awesome:bed"> <svg width="30" height="30"><use xmlns:xlink="http://www.w3.org/1999/xlink"; xlink:href="/resource/skuid__IconsSVG/font-awesome/font-awesome.min.svg#bed"></use> </svg> </i> </div></contents> </template> <richtext multiple="false" uniqueid="sk--hS20-920" model="AllAccountsAggByStatusInactive"> <contents><p style="text-align: right;"><span style="font-size:28px;"><span style="color:#ffffff;">{{BedCount}}</span></span></p> <p style="text-align: right;"><span style="font-size:28px;"><span style="color:#ffffff;">{{BedPercent}}%</span></span></p> </contents> </richtext> </components> </division> </divisions> <styles> <styleitem type="background" bgtype="none"/> </styles> </grid> </components> <styles> <styleitem type="background" bgtype="color"> <styles> <styleitem property="background-color" value="#033349"/> </styles> </styleitem> <styleitem type="border" borders="all"> <styles> <styleitem property="border" value="10px solid #033349"/> <styleitem property="box-sizing" value="border-box"/> </styles> </styleitem> <styleitem type="size"/> </styles> </wrapper> </components> </division> <division behavior="flex" minwidth="300px" ratio="1" verticalalign="top"> <components> <wrapper uniqueid="sk-kh45C-629"> <components> <wrapper uniqueid="sk--vHRC-853"> <components> <richtext multiple="false" uniqueid="sk-kghoD-585" model="AllAccountsAggByStatusDeclined"> <contents><p><font color="#e6ebed"><span style="font-size: 22px;">Declined</span></font></p> </contents> </richtext> </components> <styles> <styleitem type="background"/> <styleitem type="border" margin="bottom,"> <styles> <styleitem property="margin-bottom" value="10px"/> <styleitem property="box-sizing" value="border-box"/> </styles> </styleitem> <styleitem type="size"/> </styles> </wrapper> <grid uniqueid="sk--hCIG-872"> <divisions> <division behavior="flex" minwidth="75px" ratio="1" verticalalign="top"> <components> <template multiple="false" uniqueid="sk--ny5X-455" model="AllAccountsAggByStatusDeclined" allowhtml="true"> <contents><div float="left" class="nx-picker-icon-wrapper" title="bed" style=" color: white; "><i class="sk-webicon nx-picker-icon" aria-label="bed" role="img" handle="sk-webicon-font-awesome:bed"><svg width="30" height="30"><use xmlns:xlink="http://www.w3.org/1999/xlink"; xlink:href="/resource/skuid__IconsSVG/font-awesome/font-awesome.min.svg#home"></use></svg></i></div></contents> </template> <richtext multiple="false" uniqueid="sk--hL4V-893" model="AllAccountsAggByStatusDeclined"> <contents><p><span style="font-size:28px;"><span style="color:#ffffff;">{{FacilityCount}}</span></span></p> <p><span style="font-size:28px;"><span style="color:#ffffff;">{{FacilityPercent}}%</span></span></p> </contents> </richtext> </components> </division> <division behavior="flex" verticalalign="top" minwidth="75px" ratio="1"> <components> <template multiple="false" uniqueid="sk--m4UQ-394" allowhtml="true" model="AllAccountsAggByStatusDeclined"> <contents><div class="nx-picker-icon-wrapper" title="bed" style="color: white; float: right; margin-right: 18px;"> <i class="sk-webicon nx-picker-icon" aria-label="bed" role="img" handle="sk-webicon-font-awesome:bed"> <svg width="30" height="30"><use xmlns:xlink="http://www.w3.org/1999/xlink"; xlink:href="/resource/skuid__IconsSVG/font-awesome/font-awesome.min.svg#bed"></use> </svg> </i> </div></contents> </template> <richtext multiple="false" uniqueid="sk--hS20-920" model="AllAccountsAggByStatusDeclined"> <contents><p style="text-align: right;"><span style="font-size:28px;"><span style="color:#ffffff;">{{BedCount}}</span></span></p> <p style="text-align: right;"><span style="font-size:28px;"><span style="color:#ffffff;">{{BedPercent}}%</span></span></p> </contents> </richtext> </components> </division> </divisions> <styles> <styleitem type="background" bgtype="none"/> </styles> </grid> </components> <styles> <styleitem type="background" bgtype="color"> <styles> <styleitem property="background-color" value="#033349"/> </styles> </styleitem> <styleitem type="border" borders="all"> <styles> <styleitem property="border" value="10px solid #033349"/> <styleitem property="box-sizing" value="border-box"/> </styles> </styleitem> <styleitem type="size"/> </styles> </wrapper> </components> </division> <division behavior="flex" minwidth="300px" ratio="1" verticalalign="top"> <components> <wrapper uniqueid="sk-kh45C-629"> <components> <wrapper uniqueid="sk--vHRC-853"> <components> <richtext multiple="false" uniqueid="sk-kghoD-585" model="AllAccountsAggByStatusProspect"> <contents><p><font color="#e6ebed"><span style="font-size: 22px;">Prospect</span></font></p> </contents> </richtext> </components> <styles> <styleitem type="background"/> <styleitem type="border" margin="bottom,"> <styles> <styleitem property="margin-bottom" value="10px"/> <styleitem property="box-sizing" value="border-box"/> </styles> </styleitem> <styleitem type="size"/> </styles> </wrapper> <grid uniqueid="sk--hCIG-872" columngutter="" rowgutter=""> <divisions> <division behavior="flex" minwidth="75px" ratio="1" verticalalign="top"> <components> <template multiple="false" uniqueid="sk--ny5X-455" model="AllAccountsAggByStatusProspect" allowhtml="true"> <contents><div float="left" class="nx-picker-icon-wrapper" title="bed" style=" color: white; "><i class="sk-webicon nx-picker-icon" aria-label="bed" role="img" handle="sk-webicon-font-awesome:bed"><svg width="30" height="30"><use xmlns:xlink="http://www.w3.org/1999/xlink"; xlink:href="/resource/skuid__IconsSVG/font-awesome/font-awesome.min.svg#home"></use></svg></i></div></contents> </template> <richtext multiple="false" uniqueid="sk--hL4V-893" model="AllAccountsAggByStatusProspect"> <contents><p><span style="font-size:28px;"><span style="color:#ffffff;">{{FacilityCount}}</span></span></p> <p><span style="font-size:28px;"><span style="color:#ffffff;">{{FacilityPercent}}%</span></span></p> </contents> </richtext> </components> </division> <division behavior="flex" verticalalign="top" minwidth="75px" ratio="1"> <components> <template multiple="false" uniqueid="sk--m4UQ-394" allowhtml="true" model="AllAccountsAggByStatusProspect"> <contents><div class="nx-picker-icon-wrapper" title="bed" style="color: white; float: right; margin-right: 18px;"> <i class="sk-webicon nx-picker-icon" aria-label="bed" role="img" handle="sk-webicon-font-awesome:bed"> <svg width="30" height="30"><use xmlns:xlink="http://www.w3.org/1999/xlink"; xlink:href="/resource/skuid__IconsSVG/font-awesome/font-awesome.min.svg#bed"></use> </svg> </i> </div></contents> </template> <richtext multiple="false" uniqueid="sk--hS20-920" model="AllAccountsAggByStatusProspect"> <contents><p style="text-align: right;"><span style="font-size:28px;"><span style="color:#ffffff;">{{BedCount}}</span></span></p> <p style="text-align: right;"><span style="font-size:28px;"><span style="color:#ffffff;">{{BedPercent}}%</sp
mB Pat Vachon, Champion
-
42,926 Points
Stephen Sells, Official Rep
-
17,316 Points
Can your reproduce this using standard objects and fields and without snippets?
What version are you on? When I go to rebuild your page, I see different options than you do.
How does your "No Data" work? I don't see that anywhere in the XML I have been given.
This is the XML I am currently working on:
<skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="false" useviewportmeta="true" showheader="false"> <models>
<model id="Accounter" limit="20" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account">
<fields>
<field id="Name"/>
<field id="Id"/>
<field id="AnnualRevenue"/>
</fields>
<conditions>
<condition type="fieldvalue" value="Redrum" enclosevalueinquotes="true" field="Name" state="filterableoff" inactive="true" name="Name"/>
</conditions>
<actions/>
</model>
</models>
<components>
<buttonset model="Accounter" uniqueid="sk-2LRet2-173">
<buttons>
<button type="multi" label="Activate Via Button Set" uniqueid="sk-2LSK2E-223">
<actions>
<action type="activateCondition" model="Accounter" condition="Name"/>
<action type="requeryModel" behavior="standard" model="Accounter"/>
</actions>
</button>
<button type="multi" label="Deactivate Via Button Set" uniqueid="sk-2LSSwr-240">
<actions>
<action type="deactivateCondition" model="Accounter" condition="Name"/>
<action type="requeryModel" model="Accounter" behavior="standard"/>
</actions>
</button>
</buttons>
</buttonset>
<filterset model="Accounter" searchmethod="server" searchbox="true" uniqueid="sk-2LQuiU-133">
<filters>
<filter type="select" filteroffoptionlabel="Add Filter" createfilteroffoption="true" affectcookies="false" autocompthreshold="25" conditionsource="manual" labelmode="no">
<sources>
<source type="manual" effectsbehavior="justdefault">
<options>
<option label="Activate" type="complex">
<effects>
<effect action="set" value="" condition="Name"/>
</effects>
</option>
<option label="Inactive" type="complex">
<effects>
<effect action="deactivate" value="" condition="Name"/>
</effects>
</option>
</options>
</source>
</sources>
</filter>
</filters>
</filterset>
<richtext multiple="false" uniqueid="sk-2LUK7D-295" model="Accounter">
<contents><p style="text-align: center;"><span style="font-size:72px;">---No Data---</span></p>
</contents>
<renderconditions logictype="and">
<rendercondition type="blank" operator="=" fieldmodel="Accounter" sourcetype="fieldvalue" nosourcerowbehavior="skipandrender" value="null" enclosevalueinquotes="false" field="Name" fieldtargetobjects="Account"/>
</renderconditions>
</richtext>
<skootable showconditions="true" showsavecancel="true" showerrorsinline="true" searchmethod="server" searchbox="true" showexportbuttons="false" pagesize="10" alwaysresetpagination="false" createrecords="true" model="Accounter" buttonposition="" mode="read" allowcolumnreordering="true" responsive="true" uniqueid="sk-2LQqRy-106">
<fields>
<field id="Id" hideable="true" uniqueid="fi-2LQseo-120"/>
<field id="Name" hideable="true" uniqueid="fi-2LQsep-121"/>
<field id="AnnualRevenue" hideable="true" uniqueid="fi-2LQsep-122"/>
</fields>
<rowactions>
<action type="edit"/>
<action type="delete"/>
</rowactions>
<massactions usefirstitemasdefault="true">
<action type="massupdate"/>
<action type="massdelete"/>
</massactions>
<views>
<view type="standard"/>
</views>
</skootable>
</components>
<resources>
<labels/>
<javascript/>
<css/>
</resources>
<styles>
<styleitem type="background" bgtype="none"/>
</styles>
</skuidpage>
Stephen Sells, Official Rep
-
17,316 Points
Can your reproduce this using standard objects and fields and without snippets?
What version are you on? When I go to rebuild your page, I see different options than you do.
How does your "No Data" work? I don't see that anywhere in the XML I have been given.
This is the XML I am currently working on:
<skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="false" useviewportmeta="true" showheader="false"> <models>
<model id="Accounter" limit="20" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account">
<fields>
<field id="Name"/>
<field id="Id"/>
<field id="AnnualRevenue"/>
</fields>
<conditions>
<condition type="fieldvalue" value="Redrum" enclosevalueinquotes="true" field="Name" state="filterableoff" inactive="true" name="Name"/>
</conditions>
<actions/>
</model>
</models>
<components>
<buttonset model="Accounter" uniqueid="sk-2LRet2-173">
<buttons>
<button type="multi" label="Activate Via Button Set" uniqueid="sk-2LSK2E-223">
<actions>
<action type="activateCondition" model="Accounter" condition="Name"/>
<action type="requeryModel" behavior="standard" model="Accounter"/>
</actions>
</button>
<button type="multi" label="Deactivate Via Button Set" uniqueid="sk-2LSSwr-240">
<actions>
<action type="deactivateCondition" model="Accounter" condition="Name"/>
<action type="requeryModel" model="Accounter" behavior="standard"/>
</actions>
</button>
</buttons>
</buttonset>
<filterset model="Accounter" searchmethod="server" searchbox="true" uniqueid="sk-2LQuiU-133">
<filters>
<filter type="select" filteroffoptionlabel="Add Filter" createfilteroffoption="true" affectcookies="false" autocompthreshold="25" conditionsource="manual" labelmode="no">
<sources>
<source type="manual" effectsbehavior="justdefault">
<options>
<option label="Activate" type="complex">
<effects>
<effect action="set" value="" condition="Name"/>
</effects>
</option>
<option label="Inactive" type="complex">
<effects>
<effect action="deactivate" value="" condition="Name"/>
</effects>
</option>
</options>
</source>
</sources>
</filter>
</filters>
</filterset>
<richtext multiple="false" uniqueid="sk-2LUK7D-295" model="Accounter">
<contents><p style="text-align: center;"><span style="font-size:72px;">---No Data---</span></p>
</contents>
<renderconditions logictype="and">
<rendercondition type="blank" operator="=" fieldmodel="Accounter" sourcetype="fieldvalue" nosourcerowbehavior="skipandrender" value="null" enclosevalueinquotes="false" field="Name" fieldtargetobjects="Account"/>
</renderconditions>
</richtext>
<skootable showconditions="true" showsavecancel="true" showerrorsinline="true" searchmethod="server" searchbox="true" showexportbuttons="false" pagesize="10" alwaysresetpagination="false" createrecords="true" model="Accounter" buttonposition="" mode="read" allowcolumnreordering="true" responsive="true" uniqueid="sk-2LQqRy-106">
<fields>
<field id="Id" hideable="true" uniqueid="fi-2LQseo-120"/>
<field id="Name" hideable="true" uniqueid="fi-2LQsep-121"/>
<field id="AnnualRevenue" hideable="true" uniqueid="fi-2LQsep-122"/>
</fields>
<rowactions>
<action type="edit"/>
<action type="delete"/>
</rowactions>
<massactions usefirstitemasdefault="true">
<action type="massupdate"/>
<action type="massdelete"/>
</massactions>
<views>
<view type="standard"/>
</views>
</skootable>
</components>
<resources>
<labels/>
<javascript/>
<css/>
</resources>
<styles>
<styleitem type="background" bgtype="none"/>
</styles>
</skuidpage>
mB Pat Vachon, Champion
-
42,926 Points
Version 10.0.6
Snippet execution is part of the problem, but not the problem itself. Chart doesn't like having any snippet when there's no data after re-querying model.