Best Of
Re: Question on Expanding Data to Display Unique Values
You can do this within a Magic ETL.
If you do something like this:
This will do a cartesian join between the list of years and your dataset and then filter the records where the year is in between your original start and end years. Add formula is adding a new column called Join Column with a value of 1 for the join.
I've attached a JSON file with the definition (minus the input and output datasets) so you can copy the contents and then control+v/command+v/paste them into your Magic ETL canvas.
Re: Can I change the color on a running total line for future months?
You can do a running total with a beast mode with a conditional add instead of using the running total on the card.
CASE WHEN `Date` < CURRENT_DATE() THEN
SUM(SUM(`Sales`)) OVER (PARTITION BY YEAR(`Date`) ORDER BY `Date`)
END
This will exclude any future dates today and beyond so you only have a line for the months provided.
Re: Convert String To Date Format
@micheleb just out of curiosity, did you try a beast mode like this:
DATE(yourdatefield)
I don't have a sample dataset to try it on, but wondered if that throws an error, or if it standardizes the data for you.
Re: DOMO Office Plug-In - Excel Filter
I don't recognize where you're doing this from based on your screenshot.
Are you not able to accomplish this task through the creation of a card? If not, can you create a "helper column" within the Data Warehouse that evaluates the necessary fields and creates a True/False condition?
How do I count characters in a string in Domo ETL
ETL: How do I count characters in a string(akin to char_length in mysql)?
Ex:
ABC => Count = 3
ABCDE => Count = 5
Re: Flag percent of change when it goes negative
Are you looking for help calculating the percent change? Or is that already part of your data and you are just looking for help building the card?
Re: Looking to create a benchmarking bar chart showing +/- % from prior year
Hi @Stephanie_Price ,
I made you a video on how I would approach this and it's very possible:
I had to make some assumptions like @ST_-Superman-_ was asking, but I think we got it.
Re: Appending data when using Connector with Sql Query
Thanks so much! This is great! I'm going to try to follow this. I'm new to Domo. The Workbench is the module from Domo that installs on my machine. The Connector is OBDC. I put the transform in. (My first transform). I need you to be my friend! I'll be hitting you and your services up.
Thanks,
John Whited
+1 (740) 260-4569
Re: Looking to create a benchmarking bar chart showing +/- % from prior year
This would depend on how your dataset is structured. Could you share some more info about your data? Is the prior year benchmark in your dataset already? Or would that need to be calculated as well?
I'm pretty sure this is doable with a beastmode and a trellis category.