-
Re: Dividing in SQL
Given the math you've put on the screen, there is no reason to run this ETL as a SQL transform. Just keep your data unaggregated. Be careful with Sum(`Early to Lost`+`Early to Won`+`Early to Late`) A…1 -
Re: Calculation of a row value by the Grand total for that selection
What you're describing is a window function. If you abstract your problem and google "percent of total" SQL, you'll find loads of solutions. You'll have to ask your CSM or support to enable…2 -
Re: Custom User|Edit Page Grant
@Culper_Jr , I appreciate that it is a little jarring to have 'read only' users be able to see a section called 'Admin.' But it's just a name. In terms of actions, the stuff they can do is very limit…1 -
Re: Custom User|Edit Page Grant
@Culper_Jr ask your CSM. But also, I recommend you frame your question differently. Instead of "why can i see X in the admin section", reframe it as "i want to limit this behavior.&quo…2 -
Re: In a table card can I use a value to color code a cell?
use HTML wrapped in a CASE statement. CASE WHEN True then CONCAT( '<Div style ... >'... Note only works with HTML table cards not Mega Tables (therefore will not scroll).1