Option to relable "null" Category in Chart

Ideas
1

Like in my use case I’d relabel it to “Outstanding” as my chart categories by the Date_Completed__c field.

2

Snippet until then. :smiley:

var chart = arguments[0], $ = skuid.$; $.each(chart.xAxis[0].categories, function(c,category){ if(category === "null"){ chart.xAxis[0].categories[c] = "To be done"; } });<br>
3

Wouldn’t a Category Type of “Template” work?

<skuidpage unsavedchangeswarning="yes" personalizationmode="server" useviewportmeta="true" showsidebar="false" showheader="false" tabtooverride="Opportunity"> <models> <model id="Opportunity" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" sobject="Opportunity" type=""> <fields> <field id="Name"/> <field id="Amount"/> <field id="Null__ui" uionly="true" displaytype="TEXT" label="Null Field"/> </fields> <conditions/> <actions/> </model> </models> <components> <wrapper uniqueid="sk-pt5n--172"> <components> <template multiple="false" uniqueid="sk-ptAx0-188" allowhtml="true"> <contents>&amp;lt;strong&amp;gt;Testing Procedure&amp;lt;/strong&amp;gt; &amp;lt;ul&amp;gt; &amp;lt;li&amp;gt;Preview page&amp;lt;/li&amp;gt; &amp;lt;li&amp;gt;&amp;lt;strong&amp;gt;Expected results:&amp;lt;/strong&amp;gt; Chart renders with single "No snippet required!" category&amp;lt;/li&amp;gt; &amp;lt;li&amp;gt;Give &amp;lt;em&amp;gt;Null Field&amp;lt;/em&amp;gt; a value for one row&amp;lt;/li&amp;gt; &amp;lt;li&amp;gt;&amp;lt;strong&amp;gt;Expected results:&amp;lt;/strong&amp;gt; Chart rerenders with two categories: &amp;lt;ul&amp;gt; &amp;lt;li&amp;gt;No snippet required!&amp;lt;/li&amp;gt; &amp;lt;li&amp;gt;The value you entered for &amp;lt;em&amp;gt;Null Field&amp;lt;/em&amp;gt; &amp;lt;/ul&amp;gt; &amp;lt;/li&amp;gt; &amp;lt;/ul&amp;gt;</contents> </template> </components> <styles> <styleitem type="background" bgtype="color"> <styles> <styleitem property="background-color" value="#dbeef3"/> </styles> </styleitem> <styleitem type="border" padding="all" margin="all"> <styles> <styleitem property="padding" value="8px"/> <styleitem property="margin" value="8px"/> <styleitem property="box-sizing" value="border-box"/> </styles> </styleitem> <styleitem type="size"/> </styles> </wrapper> <skuidvis__chart model="Opportunity" maintitle="{{Model&#46;labelPlural}}" type="column" uniqueid="sk-ppwgW-122"> <dataaxes> <axis id="axis1"/> </dataaxes> <categoryaxes> <axis id="categories" categorytype="template" field="Name" template="{{^Null__ui}}No snippet required!{{/Null__ui}}{{#Null__ui}}{{Null__ui}}{{/Null__ui}}"/> </categoryaxes> <serieslist> <series valuefield="Amount" splittype="none" aggfunction="sum"/> </serieslist> <colors/> <legend layout="horizontal" halign="center" valign="bottom"/> </skuidvis__chart> <skootable showconditions="true" showsavecancel="false" showerrorsinline="true" searchmethod="server" searchbox="true" showexportbuttons="false" pagesize="10" createrecords="false" model="Opportunity" buttonposition="" mode="edit" allowcolumnreordering="true" uniqueid="sk-pqNLi-165"> <fields> <field id="Name" hideable="true" uniqueid="fi-pqQTv-183"/> <field id="Amount" hideable="true" uniqueid="fi-pqQTw-185"/> <field id="Null__ui" hideable="true" uniqueid="fi-ps-oc-161" valuehalign="" type=""/> </fields> <rowactions> <action type="edit"/> </rowactions> <massactions usefirstitemasdefault="true"> <action type="massupdate"/> </massactions> <views> <view type="standard"/> </views> <searchfields/> </skootable> </components> <resources> <labels/> <css/> <javascript/> </resources> <styles/> <pageregioncontents/> </skuidpage>
4

I give up on trying to make that XML look good in Get Satisfaction.

5

Not in this case. Date Granularity options.

But … how about adding Template option for Category in Series. Then I could use the suggested method there.

6

Ah, yeah, that’ll be a problem. Your snippet approach is going to be your best bet for now. I agree though, we could make some improvements around categories and dates in Charts.