Best Of
Re: Details about, and alternatives to, the DataSet query API
I know for a fact they are working on a project in that space. But TBF the query API DOES work and hasn't changed.
Re: Nested Case Statement
You need to reverse the order of your SUM checks because if the sum is more than 111 it's already more than 35 so it will return Tier 2 first and quit as it executes the first case that matches. Check for Tier 4 then 3 then 2 then 1.
Also with your tier 3 check you only need to check for 71 because by logic all prior when statements are false.
CASE WHEN SUM(CASE WHEN `Status__c` = 'Booked' THEN 'Completed' ELSE `Status__c` END) > 111 THEN 'TIER 4' WHEN SUM(CASE WHEN `Status__c` = 'Booked' THEN 'Completed' ELSE `Status__c`END) > 71 THEN 'TIER 3' WHEN SUM(CASE WHEN `Status__c` = 'Booked' THEN 'Completed' ELSE `Status__c`END) > 35 THEN 'TIER 2' ELSE 'TIER 1' END)
Re: PyDomo - DS_Update to Append Data?
pydomo/ds_update doesn't support append at this time. You could configure a recursive dataflow to append your data.
Re: How do I convert a 12 Hour Time into a 24 Hour time
@Devin_Garrison As a side note, if you just need those timestamps to show up in a card in 24 hour format, it actually displays them that way without needing to do anything. I tried it out with a couple of timestamp columns in my data and it displayed everything in 24 hour format. It seems that when you look at them at the dataset level, Domo displays them in 12 hour format.
Re: String Operation Add Space to Postal Code
Assuming it's always 6 digits:
CONCAT(LEFT(`Postal Code`, 3), ' ', RIGHT(`Postal Code`, 3))
Re: Increasing m x n dimension of a pivot table
Could you take a screenshot of how you're configuring the pivot table? It might be useful to use a dataflow and the Pivot tile to get the columns required before creating a Pivot Table card.
GSTV
Re: Add a column to capture percent of total value for adjacent column
Fixed function is your friend here.
SUM(`Visitors`) / SUM(SUM(`Visitors`) FIXED ())
https://domo-support.domo.com/s/article/4408174643607?language=en_US
Re: Analyzer: Don't Automatically Choose Chart Type and Columns
absolutely. at least, make it a setting option
