$100 Amazon Gift Card- High Chart Connect Nulls False

I gave this the best I could. I’m coming to a sense that “no” is the general answer to “is this possible?” I hope someone worthy is able to pull the $100 out of the stone. I am not King Arthur. 

Because of this sneaky suspicion, I’m going to bring this up with the developers and see if it is a functionality they know how to implement. I’ll keep you posted on the results of that meeting.

I mention this because, you might want to change the status from Question to Idea so that it receives visibility from our design team. Your call.

Alright $200 🙂 to pull the sword from the stone.

King Arthur shall remain King Anonymous! And generous is He! He refuses the bounty. What a glorious King indeed!

This should help. One of our developers wrote this code himself. It contains snippets you can use in your own. The only caveat is you’ll need to hit the re-render button to fix the appearance once you hit save. In all other respects it functions as we expect you’ll like.




IF(ISBLANK({{Amount}}),“null”,{{Amount}})











models.saved
models.loaded
row.updated


Amount
Id
Name

































<skuidvis__chart model=“Oppy” maintitle=“{{Model.labelPlural}}” type=“line” uniqueid=“sk-_sIut-139” rendersnippet=“ChartsMod”>














</skuidvis__chart>




var chartObj = arguments[0],
$ = skuid.$;
var points = chartObj.series[0].data;
try {
for (i = 0; i &lt; points.length; i++) {
var point = points[i];
if (point.y &lt; 1)
{
point.y = null;
}
}
}
catch (e) {
console.log(e);
}
var params = arguments[0],
$ = skuid.$;
skuid.$C(“sk-_sIut-139”).render();
console.log(‘save action fired’);

YES!!! Thank you! This got me on the right track! Thank you so much! Please tell King Anonymous that he has made my month!! There may be better ways to do it but my no skill/non programmer workaround that might help others is as follows. So the above snippet makes a break in the line if the value is Less than 1. There may be entries that are 0 that are legitimate where I don’t want a break in the line. I only need a break in the line if the entry is blank (no data collected). So I took these steps: 1. Create a custom formula field called IsBlank__c IF(ISBLANK(RESULTS__c),“null”,“Number”) 2. Create a UI Only Field, Formula, Number, IF({{IsBlank__c}}==“null”,-123456789,{{Result__c}}) 3. Change the Snippet to ==-123456789 or some other very unlikely number. 4. Set the Chart to graph the UI only field. Voila! The chart will graph all number except the crazy number you selected which only shows up if the Results__c field is blank. If you show a table of your data you show the real Result__c field so the crazy number is never seen. Total hack work around but it works! Now, my only question I have to figure out is I have more than multiple series per Chart and this is only working on the first series. var points = chartObj.series[0].data; I assume I just have to add to the snippet for Series[1] series[2] etc. Thank you Stephen Sells and the Anonymous person behind the snippets. It means a lot! Thank you!

Alright, i am back to beg.  I am using this code that was generously given to me:

var chartObj = arguments[0], $ = skuid&#46;$;var series = chartObj&#46;series[0]&#46;data;<br />&nbsp; &nbsp; try {<br />&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<br />&nbsp; &nbsp; &nbsp; &nbsp; for (i = 0; i &lt; series&#46;length; i++) {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var point = series[i];<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (point&#46;y == -123456789)&nbsp;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; point&#46;y = null;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; }&nbsp;<br />&nbsp; &nbsp; &nbsp; &nbsp; catch (e) {<br />&nbsp; &nbsp; &nbsp; &nbsp; console&#46;log(e);<br />}

I made some minor tweaks to the code and it works perfectly for one series. However, my chart has multiple series (up to 15).  How do I define multiple series and make it work for all series on a chart not just the first one?  I tried identifying a chartobj.series[1].data etc. but it broke the page.  It seems like I need it to loop through the data and define all the series and then loop through all the series and change the value of those equaling -123456789 to null.  

I read a lot of posts last night and looked at a lot of examples but rarely did they deal with the subject of multiple series.

Thank you!

When you say that changing the code to chartobj.series[1] broke your page, what errors did you see?

Hi Rich,
I didn’t fully follow your original posting, but you should be able to use a simple “chart.series.length” to iterate through each series on your chart. It looks like you’re almost there. Here’s a stab at updating your code, although you may need to add some checks that the series has a length. 

Thanks for sticking with me to help me find the resolution.

To show what is happening with multiple series on the same chart this is what I am seeing with the snippet left as is.

var chartObj = arguments[0], $ = skuid.$;var series = chartObj.series[0].data;
    try {
        
        for (i = 0; i \< series.length; i++) {
            
            var point = series[i];
                if (point.y == -123456789) 
                {
                    point.y = null;
                    
                }
        }
    } 
        catch (e) {
        console.log(e);
}

Note the blue line actually breaks like I want it to. Whereas the black line shoots downward presumably toward -123456789. 🙂 Ideally both lines would break like the blue line.
_______

Hi Mark,
In answer to your question, if I keep the same code as posted above and all I do is open the snippet and change the 0 in:
chartObj.series[0].data;

to 1 for example:

chartObj.series[1].data;The page no longer loads and the error in the console log is:
TypeError: chartObj.series[1] is undefined.
_______
Josh,
Thank you very much for jumping in. I tried the code and something is off still. I am sure you are on the right track, it is just doesn’t appear to do anything with the addition of the for(J=0; etc… I will read up on post you added to see if I can’t see another way of looking at it.

This is the code I am trying using .length.

var chartObj = arguments[0], $ = skuid.$;var seriesLength = chartObj.series.length;        for (i = 0; i \< seriesLength; i++)             for(j = 0; j \< chartObj.series[i].length; j++) {             var point = chartObj.series[i].data[j];                if (point.y == -123456789)                 {                    point.y = null;                  }         }    } 

This code doesn’t break the page, but the black line still drops down vertically toward -123456789. The blue line continues to work correctly. I need blue line behavior on every line.

Thank you both!
Rich

You might need to define your variables i and j using var i = 0, rather than just i = 0. If that doesn’t work, we’ll have to hope for someone else to chime as that’s all the tricks in my bag.

There’s a standard programming operator called forEach that is used for processing arrays, so that’s another option to try if you can’t get your for statements to iterate through all the data.

Thanks Josh! I will give it a shot.