-
Generate Date Range Column from Two Date Columns
Hi all ! Im trying to generate a date column with a range of dates from two columns: Table I have (date format (mm/dd/yyyy) ) Id start_date end_date field1 1 01/01/2019 07/01/2019 text1 1 07/01/2019 12/01/2019 text2 2 01/01/2019 02/01/2019 text3 The idea is to generate a list of dates between start and end date with an…
-
Creating a constant value for each month
Hi all! I want to build a Pivot Table Card with columns being each month from start to current date , rows as IDs and each value to be a constant number. However, in the dataset there's one row per ID showing start date, its status and the constant number (ID-1 ; 01/01/2016; active; 150). So, when building the card the…
-
Is there a way to create Running Total using Beast Mode?
Hi, I'm building a table card and I would like to create a column that performs a cumulative sum, like the following: | Week | Amount | Running Total | 1 | 100 | 100 | | 2 | 50 | 150 | I tried to do this using SQL Dataflow, it works fine. However, I want to be able to add filters that modifies the Running Total and thus,…
-
Is it possible to formatting the style of a report that is sent via email?
Hi, I've my domo dashboard with a specific background, however when sent it as a report via email, it's not showing the background in the email. Any ideas if this is something I could change? Thanks