Best Of
Re: Report Schedule Management
Completely agree! It would also be helpful to filter by expiration date or whether the report is enabled to better manage expired reports.
Re: Highlighting "current" on slicer
You could do something with an HTML table and use the color rules but it would be a table with a column header, then, provided the field is in the data on the page, have the table card impact the rest of your cards so when that row/cell in the table was clicked on it it would filter the rest of the cards on that page.
Otherwise anything else is DDX bricks or developing an app with coding to create colored buttons that function as filters and I don't believe anything is packaged with that deliverable.
Jessica
Re: Using admin to add owners to multiple cards at once
@louisshh Can you confirm that you actually have the admin role?
Magic ETL Joins - include table name as prefix
Hi All,
When joining tables in the MAGIC ETL, how do I include the table name as a prefix for the columns?
Sometimes the 'Select Columns' transformation offers a rename suggestion in the format, 'TableName.ColumnName' but it is not always suggested and requires using the 'Select Columns' transformation before each join.
Currently renaming columns but surely there's a better way:
Let me know!
Kind regards,
NateBI
Re: Month over Month Comparison on mega table/pivot table
Hi @Jackie96 ,
I got this question earlier today so I guess it was you! Here's a video for everyone else to see how I approached this problem:
John Le
You're only one dashboard away.
More video solutions at: https://www.dashboarddudes.com/pantry
Re: An unknown error occurred
Problem has been solved, the issue was: duplicated columns in Snowflake table ( 2 columns with the same name)
Pau
Re: Email Connector - csv headers import, but not data
@dgsinclair It most likely is the CSV file you're using. I'd suggest reverting your dataset back to the last successful execution from January 5 and starting your changes again from scratch.
On a side note, did you edit the csv file in a text editor, like your screenshot, or did you use Excel? If you did it in a text editor, it's possible that you may have accidentally mis-aligned your columns while manually editing and Domo is unable to read it properly.
Re: Calculations using analyser or beast mode
Can you provide a little more commentary about what exactly you are looking to solve for here? It looks to me like you've already figured out the solution.
If you're looking to calculate numbers based on different filter criteria I'd recommend using a CASE statement on a beast mode or in magic ETL to solve.
Pretend I'm running a fruit stand -- I have 3 apples (that are red), 2 peaches (that are pink), and 5 blueberries (which are blue). I want to lump anything that is red or pink into a 'red' bucket.
I can write a beastmode called 'red fruits':
CASE WHEN fruit color IN ('Red', 'Pink') Then SUM(Quantity) End
This would add apples and peaches together.
G_Grey
Re: Data format from Jupyter to Dataset
it's unclear what your output from (presumably) magic etl scripting tiles looks like. can you send intermediate screenshots?
