Best Of
Re: how to exclude all last Wednesday of every quarter?
This is best done in a dataflow. There is a free dataset called "Calendar" that you can find in the appstore by searching "Domo Dimensions" and then selecting "Calendar.csv" from the available options:
Next, you will want to bring this into your ETL and apply a filter to only return wednesday values. Then, use a group by tile to group by quarter & year (`q` & `y` fields in the dataset) and use "Last Value" as the group by type. Now you will have the last wednesday of each quarter. You can then join that with your data. Now in the card all you have to do is create a beastmode (this can also be done in the etl) that says when the date = a non-null value in the last wednesday column, then exclude from the card.
Re: Pivot Table Week over Week % Change
You'll have to do this in the dataflow!
@GrantSmith and @DashboardDude gave great answers for this problem here! You'll just have to use week instead of month.
Re: How to add a Background image to the dashboard
To set the background image for a Page,
- On the Page you want to change the background color of, select Edit Dashboard in the
menu in the top right corner of the Page.
- In the Options menu at the top of the screen, select Change background.
- (Conditional) If Color Fill is selected in the menu at the top of the dialog, choose Image Fill.
- Click Choose Image.
- Locate and select your image on your machine.
- (Optional) To change the default background color (which is only used before the image has loaded on the Page), click Change then choose the new color from the palette (or enter a hexadecimal code in the field at the bottom of the palette).
- (Optional) To change the default text color used on the Page, select the new color in the menu under "Default text color."
- Currently only black and white are available as text colors.
If you want to change your background image, click Choose New Image at the bottom of the dialog then locate and select the new image on your machine.
https://domohelp.domo.com/hc/en-us/articles/360043428433-Creating-Domo-Stories#8.
Re: Fill empty columns based on values in other columns
No because you will break out the group by into a separate line in the dataflow. So from you input dataset there will be two lines:
1. All rows of data
2. 1 unique row for each ID.
Then you will left join the unique rows for each ID with the original input that has all rows of data. No rows of data will be lost.
![[Deleted User]](https://us.v-cdn.net/6032830/uploads/defaultavatar/nZ5X977MOM3Z6.jpg)