Best Of
Re: Calculated Column using Current Date
I would use the DateDiff function to do this. Something like this:
case when DATEDIFF(CURRENT_DATE(),Credit Release Date) <6 THEN 'Recent' ELSE 'No' END
Returns the number of days between two dates from datetime values.
DATEDIFF(CURRENT_DATE(), 'lastmoddate')
Re: Calculated Column using Current Date
@JenHarrison It looks like your missing a ) after CURRENT_DATE which is resulting in the syntax error. Though you will probably want to use the DATEDIFF() function instead as in your current beastmode it's just subtracting the day of the month so you might run into situations where it results in a number greater than 6 but it is actually within 6 days. DATEDIFF() will give you the number of days between two dates.
VIDEO TUTORIAL: How to calculate Percentile Rank (for A/B testing)
Percent ranking answers what "% of values were less than Y." Kudos to @GrantSmith for the question.
This is useful for comparing test results in two populations. Imagine 67 respondents tested 75% or les whereas in group B 99 respondents scored 75% or less.
To calculate % rank, you calculate the rank and divide each rank by the count of values.
Here's the video tutorial on 3 different ways to calculate the result (using MagicETL, Analyzer and Dataset Views)
Re: REGEX Extracting Names
Are you simply looking to just remove the open and close brackets and the double quotes?
Re: REGEX Extracting Names
I would use the formula tile and use the replace function multiple times to remove those characters.
Something like this:
REPLACE(REPLACE(REPLACE(fieldname,'[',''),']',''),'"','')
Re: URL in a card
@ALCIIAAZV Have you tried adding the link to the summary number instead? Then you can hide the chart from the dashboard and only show the summary.
Re: Ranking card
@zuchu You would use RANK() or DENSE_RANK() in a beastmode on your card. It would be something like this:
RANK()OVER(ORDER BY SUM('Sales') DESC)
Then put your companies as a column and your beast mode as a column. Here's and article about the difference between RANK() and DENSE_RANK():
If you end up with ties and you don't want any, you can a second aggregation after SUM('Sales') that would be used as a tie breaker.
Re: Count Unique IDs by Month-Year
HI @tmerchant You will need to first create a calculated field using a Formula tile that extracts the month and year of your timestamp column:
concat(YEAR(`Timestamp`),'-',MONTH(`Timestamp`))
Then use a Group By tile to group by the Month/Year and Unique ID, counting the Unique ID field.
Re: Cant edit the ETL, beside I'm the owner
@camila What user role do you have? If you are not an admin, then I suggest reaching out to somebody who is an admin for your instance to verify your permissions. If you are an admin, then you should reach out to Domo suppor to troubleshoot.