-
Pivot Table
Is there a way to do conditional formating based on another column directly in pivot table? Example: color in green if value in column A > then in column B Thanks
-
Calculated field in a new Best Mode calculation
Hello, If a created a new calculate fied caled 'Data Calculated' can I use is for another calculation? When I am writing the formula below, I get A column in this calculation did not exist. case when `= Data Calculated` = 'test' then '1' else 0 end Thank you!
-
Card Label Calculation
Hello, is there a way to add a calculation in the card label setting? if for ex I want ti show (Current Value / Next Value) Thank you
-
Expend table to create subcategories
Hello, How can I transform my table 1 to the format of table 2 ( as seen in the attached docment) I am doing it with magic ETL by maping values and then replacing it the first column , but it takes a lot of time! I hoped there would be a more efficient way of doing it. Any suggestions? Thank you!
-
Link Cards
Hello, If I have in one page multiple cards , but I want to link some of them with the same filter: First card is a map. when I click on NY I want the next card to filter NY too. But I would like the filter to come form clicking on the map and not from a filter in the page. I can't use drill path as the data are different.…
-
Magic ETL equivialent to "Group" in excel
Hi, If I have an excel sheet with grouped columns in multiple layers as in the screenshot: Food is the big category ( that is the total of the others) , food at home is a sub category (total of the others) etc.. Is there a way to re-devide the data that way in domo? Thank you!
-
Convert Column Type: ETL or SQL
Hi, I have a column that contains letters from a to k and also numbers. I would like to replace the letter with 0 and change the column type from text to numbers. While doing this on ETL the run fails. The way I did it was: 1- replace text and enter each letter to be replace by 0 2-set column type I don't understand why I…
-
Graph behind a graph
Hello!! Is it possible to create a card with for example the US map and when I click on any state I get the couties and when I click on the countie I want, I get a another card or a graph a built? Thanks!
-
Percent increase/decrease
Hello, If I have many columns for ex: "2010 population" "2012 population" "2014 population" and I would like to show the % evolution between each of them on the graph how can I do it? Thanks!
-
Percent Increase Decrease
Hello, If I have many columns for ex: "2010 population" "2012 population" "2014 population" and I would like to show the % evolution between each of them on the graph how can I do it? If beast mode is the way to do it I will then have 3 columns "2010 population" "2012 population" "2014 population" then 2 columns "10/12…
-
Join 2 data sets based on multiple column
Hello, If I want to join 2 datasets, but the matching column can be multiple, how can I do it with ETL? When using join data and selecting "match another column" it is not working as an "or" condition. What I would like it to find all the matches between 2 columns, and then go to 2 other and do the same. Is that possible?…