Best Of
Re: Pivot Table Total Column Position
agree. Being able to also choose which columns you want as total columns would be useful.
Jones01
Re: Pivot Table Total Column Position
Completely agreed, we have pivot tables which has extended beyond the screen width view port, so users keep missing the total column as it is on the far right and currently no option to position it before (left) like you can on rows total.
Re: "Add All Columns" button for Mega Table Charts
and a way to click/multi select to add fields instead of having to drag them over.
Ashleigh
Re: How to stop a dashboard's background change from impacting charts
I see what you mean in the series for the non-hovered bars in the series. I would start with a support ticket and see if they acknowledge it as a bug. If you don't have any luck with that, I would submit it as an enhancement in the Ideas Exchange and see if it gets incorporated into the future.
Glad you are enjoying my videos and thanks for becoming a subscriber!
Re: Data Retention
Surely there must be a way to restore a dataflow?
This seems like an important feature for long term maintenance and accountability.
Thanks, Craig
Re: Domo IDEAs Conference - Beast Modes - Number Formatting
I was surprised when I tried to use FORMAT in a beast mode and got an error "This calculation is using a nonexistent function". Then I was shocked to find threads going back to 2018 asking for a way to format numbers when converting them to text. I believe that FORMAT is even available in the old version of MySQL that Domo is using. It's very disheartening that this has been left unaddressed for at least 5 years.
Marc Aec
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.
