Best Of
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: How do I convert a 12 Hour Time into a 24 Hour time
DATE_FORMAT function if your friend in this case. You can format the date as a specific string format.
You can find more information on the codes used here: https://www.w3schools.com/sql/func_mysql_date_format.asp
DATE_FORMAT(`Date`, '%Y-%m-%d %H:%i:%s')
Re: PDP shield
You can't remove the filter or PDP icons but you can change the justification within Analyzer. For your column select it then go to Format - Justification and set it there.
Re: Grant to Share Cards and Page, but not Edit
In general, it would be helpful to separate the actions of 'edit', 'create' and 'delete' into separate grants (across cards, pages and datasets).
Re: Is there a way to nest beast modes in another beast mode without exposing the full calculation
Unfortunately, the beast modes will expand out when you include them in another beast mode. I agree that it would be really helpful if they did not do this, as it would make the code a lot cleaner and more efficient.
I'm not sure if it has been submitted in the Ideas Exchange section of the Dojo, but I will definitely vote it up if you posted it there.
Re: Aggregation on Lag/Lead functions
This isn't possible as you can't aggregate a window function within a beast mode. What you'd need to do is perform your lag in an ETL and then calculate the average in your card. You may lose some filtering abilities as it's going to be pre-aggregated.