Hi Pete, this is pretty interesting! How did you move the button widgets about around 5.45? Unless you used pages, which then meant that you can't prevent someone from clicking the original "click me to get a prize" button before they complete clicking 3, 2 , 1
I did use pages. I also used bindings to control the link destination which is totally buggy and not recommended. It's not officially supported. I'm not 100% sure I actually had it working correctly when I recorded. I've mostly got it behaving with URL links, not EA assets.
Hi there great video ! :) Does this coalesce function work also on mutli-value fields or by using it do you loose the multiple aspect of your original field ? Thanks
To be honest I've never tested. My guess is it either doesn't work at all or it returns an array with only a single value. I'm guessing the latter as this is how it behaves on list widgets with multiselect. If you try it out, please let me know.
@@LetsPlaySalesforce I have tried it today, and It is returning a value but it doesn't seem like it is keeping the multiple aspect of the field. The numbers returned don't add up as they should. :'( Is there another way to deal with a null value of a multi-value field to group by values of this field including the null value. (a "no value" bar for example)? Thanks
@@kevintoomey1817 this particular week maybe a bit challenging but if you're in San Francisco find me after one of my dreamforce sessions and maybe we can try to troubleshoot it
@@LetsPlaySalesforce Sadly I am not going to San Fransisco for dreamforce hopefully next year ;) I am looking for a work around but I found nothing yet.
Hi Pete - thanks for the video! Do you know if i could use coalesce to actually count the null? I am trying to write a SAQL but i need to count line items that have null value with "case when". Tried using "is null" but doesn't give me much success.
If you override your nulls with something like "blank" using coalesce, you can then do a post-projection filter to keep only those records and count them. Check out my video "advanced filters" from the same series for more info.
Hey Pete - it took me a while but i finally managed to get my code to work between coalesce and the post-projection filter! Thanks again for the videos, really really helpful! :D I am looking to do calculations now for the end result of my post projection.. i.e. if result is > 25%, the score is 5 * weight of the category otherwise other rule or calculation etc.. i tried using "case when" but when it comes to the calculation piece my code doesn't seem to work. Do you by any chance did any video relating to that kind of use cases?
hehe you're quickly becoming my fave person! I'm using percentage actually maybe that's why.. but just in case i'll post the code. huge thanks again! you're the best!
This series is great Pete! Thanks for taking some time to shed light on this intimidating subject.
Awesome explanations...
Hi Pete, It’s really Awesome!
Can you share the Getting price code
sudharshan putha happy you like it! Which code do you need? I cover a lot in this video, what time stamp do you need the code for?
Hi Pete, this is pretty interesting! How did you move the button widgets about around 5.45? Unless you used pages, which then meant that you can't prevent someone from clicking the original "click me to get a prize" button before they complete clicking 3, 2 , 1
I did use pages. I also used bindings to control the link destination which is totally buggy and not recommended. It's not officially supported. I'm not 100% sure I actually had it working correctly when I recorded. I've mostly got it behaving with URL links, not EA assets.
Hi there great video ! :) Does this coalesce function work also on mutli-value fields or by using it do you loose the multiple aspect of your original field ? Thanks
To be honest I've never tested. My guess is it either doesn't work at all or it returns an array with only a single value. I'm guessing the latter as this is how it behaves on list widgets with multiselect. If you try it out, please let me know.
@@LetsPlaySalesforce I have tried it today, and It is returning a value but it doesn't seem like it is keeping the multiple aspect of the field. The numbers returned don't add up as they should. :'( Is there another way to deal with a null value of a multi-value field to group by values of this field including the null value. (a "no value" bar for example)? Thanks
Thank you very much for your response by the way. :)
@@kevintoomey1817 this particular week maybe a bit challenging but if you're in San Francisco find me after one of my dreamforce sessions and maybe we can try to troubleshoot it
@@LetsPlaySalesforce Sadly I am not going to San Fransisco for dreamforce hopefully next year ;) I am looking for a work around but I found nothing yet.
Hi Pete! Great Videos. Can you email me the code for the one demoed at 5:53?
I went on to break it, but I have a mostly functional backup. Email me at letsplaysalesforce@gmail.com and I'll send you what I have.
Hi Pete - thanks for the video! Do you know if i could use coalesce to actually count the null? I am trying to write a SAQL but i need to count line items that have null value with "case when".
Tried using "is null" but doesn't give me much success.
If you override your nulls with something like "blank" using coalesce, you can then do a post-projection filter to keep only those records and count them. Check out my video "advanced filters" from the same series for more info.
Let's Play Salesforce thanks for the quick reply!! I'm gonna try it and might come back to you with questions 😅 (sorry, rookie here!)
Hey Pete - it took me a while but i finally managed to get my code to work between coalesce and the post-projection filter! Thanks again for the videos, really really helpful! :D
I am looking to do calculations now for the end result of my post projection.. i.e. if result is > 25%, the score is 5 * weight of the category otherwise other rule or calculation etc.. i tried using "case when" but when it comes to the calculation piece my code doesn't seem to work. Do you by any chance did any video relating to that kind of use cases?
Melannie Tjeng are you multiplying by a decimal like .25? If so, you need 0.25. Otherwise, post your code and error on the community and @mention me.
hehe you're quickly becoming my fave person! I'm using percentage actually maybe that's why.. but just in case i'll post the code. huge thanks again! you're the best!