Best Of
Re: How to Remove Duplicate rows in analyzer?
@SaloniShah is the data actually duplicated in your dataset? If so that's probably something to be concerned about if it's not intentional.
Take a look at the connector that's bringing in the data, is it set to APPEND or REPLACE?
Is the data actually duplicated or are just a few rows duplicates? If you run the connector multiple times do you accumulate a copy of the dataset each time? (if so that implies that you're running an APPEND instead of REPLACE in your connector settings.
Sometimes Domo's datasets are 'broken', to deduplicate a row, you can use "remove duplicates" tile in Magic ETL or use a rank_window tile and apply a row_number to each row partitioned on date then apply a filter. (remove duplicates is probably conceptually easier to understand, rank_window is more precise).
Re: ¿How can I classify an object based on conditions?
@andersson_morales19 i think you need CASE and aggregation.
so something like
CASE
WHEN
count(column) + count(other_colum) <= 3
AND
count(column_3) + count(column_7) <= 3
THEN ...
WHEN
count(column) + count(other_colum) <= 3
AND
count(column_3) + count(column_7) <= 3
THEN ...
END
Re: Freezing card at end of Fiscal Year
@FXM32 Domo does retain dataset history in Vault, but that's supposed to be a recovery tool not dataset snapshots that end users can flip between.
Given that your "freezing mechanism" should tightly align with business logic, it makes sense that you should apply that business logic as an artificat in your dataset that you can control via ETL and filtering.
Re: Why are my filters not working in Magic ETL?
@damen to be more specific, you should (probably) impelment the metric @RobSomers is describing as a Beast Mode in Analyzer.
Typically we recommend against preaggregating datasets in ETL if we don't have to.
Re: Why are my filters not working in Magic ETL?
@damen In your formula, instead of doing COUNT('withdrawn'), do this:
SUM(case when 'fallout_reason' = 'withdrawn' then 1 else 0 end)
As you have it now, the numerator is essentially creating a "column" with the string 'withdrawn' in every row, so the numerator is doing the same thing as your denominator. You need to identify the column your aggregation should be looking at and what the condition is.
Re: ¿How can I classify an object based on conditions?
@andersson_morales19 You're case when statement isn't working because of the waterfall. CASE WHEN statement go through each part of the statement and once a condition is met, it doesn't evaluate anything else. So in the case of your beast mode, if a row meets the 'Basico' condition, it assigns it as 'Basico' and won't evaluate it further, even if it meets other conditions in the statement. So level two and level three will always meet level one conditions, so as you have it right now, you'll never find level two and three, everything will just be level one. You would need to reorganize your case when statement to start with the conditions for level three, then level two, and end with level one. Hope that makes sense!
Re: MySQL Indexing Issues
@trafalger I do wonder if you add the index in the UI if the data is indexed as it's being loaded into the table, or if if the index is added after CREATE TABLE AS SELECT ...
So i i guess if you wanted to be REALLY fancy you would CREATE TABLE, ALTER TABLE and then load data... but then the table doesn't appear in the UI.
Re: Accessing Dataset
The user who you authenticated workbench with is the owner and must either share the dataset with you or make you the new owner for you to see the dataset.
Re: "current year, current month" and "previous year, current month" Beast Modes
You can multiply amount by 1 to force it to be a number or change the data type in an ETL
Re: "current year, current month" and "previous year, current month" Beast Modes
@damen Current month:
case when YEAR('Transaction Date') = YEAR(CURDATE()) and MONTH('Transaction Date') = MONTH(CURDATE()) then 'amount' end
Previous year, current month (assuming this means same month last year):
case when YEAR('Transaction Date') = YEAR(CURDATE()) -1 and MONTH('Transaction Date') = MONTH(CURDATE()) then 'Amount' end