Best Of
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?
Re: Weighted Averages of Summary Data
I think it would be something along the lines of...
sum(`N` * `X-Y Average`) / sum(`N`)
Re: Query to create a condition on a database
you can easily created a beastmode case statement as
CASE
WHEN `PPG` = 'MPA 90GRS' THEN 90
WHEN `PPG` = 'CTA 90GRS' THEN 90
END
Adding as many conditions as you want individually or this is another option
CASE
WHEN `PPG` IN ('MPA 90GRS', 'CTA 90GRS') THEN 90
WHEN `PPG` = 'CLUMINOUS 70GRS' THEN 70
END
now if , PPG contains a lot distinct values , you could ETL a table with those values and join it to your data.
anyways, there is a lot different ways to do that. hope this helps
Godiepi
Re: Getting an SPC card to track data by the Day
@slewis1 Does it still show the axis at an hourly level if you change the filter to "Previous Year"? It's most likely due to the fact that we are only 3 days into 2023, so it's trying to fill the gaps.