Best Of
Re: October 2023 Community Forum Highlights
Conragts @pauljames !
You might not be getting much sleep then @MarkSnodgrass . The top spot is mine this month. 😂
Re: October 2023 Community Forum Highlights
It was great to help so many people last month! Now, I will go back to "sleep" and let some others get the top spot for the month… as long as they aren't named @GrantSmith 😀
Re: Beast Mode Approach to Eliminate Field Character
@MichelleH has what I would have suggested, but she mistyped the character you are looking for. :)
Should be:
REPLACE(RIGHT(`Sent Email`,((LENGTH(`Sent Email`))-(INSTR(`Sent Email`,'@')))),'>','')
Re: I want to calculate difference between yesterday and day before yesterday.
@Dheeraj_1996 then @MichelleH answer is what you're looking for. From the sample data you've provided, assuming you were running it on the 25th line 1 will return 12 and line 3 returns 5, so the difference would be 7.
If the idea is not to compare this to the current date, but be able to tell how many new files were received each day, then you'd need to use a window function instead, leveraging the LAG version (this will work since you've stated you have entries for every single day with no date gaps), it'd look something like:
COUNT(`local_collect_date_time`) - (LAG(COUNT(`local_collect_date_time`), 1) OVER( ORDER BY date(`local_collect_date_time`) ASC))
And you'd graph by local_collect_date_time grouping by day, with that you can get something that looks like:
Keep in mind that since this is a lag function, the first date in your date range will have no previous day information available, so the delta will be the start date.
Re: Unable to save card with Beastmode active
Domo currently doesn't support filtering with window functions, so you're getting the error. They did previously but recently stopped supporting it without any reasoning or documentation.
how do I convert data time field to yyyy-mm-ddThh:mm:ss
so that when i export the file shows 2020-09-14T11:56:43 instead of 14-Sep-20 11:56:43 ?
Re: HeatMap Chart Colored by Columns
Agree with @execdata. Column based formatting is to cohort tables as Patagonia vests are to finance bros.
Re: Smart Text - Add "Limit Rows"
BVK,
I think you are going to need to elaborate on your idea a bit more in order to get it voted up. :)
Re: Smart Text - Add "Limit Rows"
You are too fast @MarkSnodgrass! It accidentally submitted mid-word, haha
Re: Congratulate our newest Community Coach, Colemen Wilson!
Big congrats @colemenwilson. I want to be you when I grow up.




