Pat Vachon, Champion
-
44,426 Points
Posted 2 years ago
Pat Vachon, Champion
-
44,426 Points
Stephen Sells, Alum
-
17,326 Points
I'm glad you solved it before I finished building my test page. You're the man Pat.
Pat Vachon, Champion
-
44,426 Points
This isn't solved. Just further clarified. I need to use snippets.
Stephen Sells, Alum
-
17,326 Points
The current problem seems to be a chart associated with an aggregate model. LAST_N_DAYS are working on the filter but NEXT_N_YEARS is not working. If you try and have the next run by the filter set, it'll constantly be "Applying" but never actually apply. Is that right? What is the snippet doing? I don't know how to incorporate that
Stephen Sells, Alum
-
17,326 Points
Can you share the XML of the model?
Pat Vachon, Champion
-
44,426 Points
Here you go. You'll have to add some custom fields and one object. Not too many though.
<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
<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
Pat Vachon, Champion
-
44,426 Points
Emailed Chris Jackson the XML since it seems this didn't work.
Stephen Sells, Alum
-
17,326 Points
I got it from him this morning. It doesn't look like the same as in your video. I have a few questions for you:
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>
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, Alum
-
17,326 Points
I got it from him this morning. It doesn't look like the same as in your video. I have a few questions for you:
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>
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>
Pat Vachon, Champion
-
44,426 Points
This would be far easier via GTM.
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.
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.