cwolman Contributor

The security policy was not working as expected on Friday but now is working. When you say update script - is this an update dataflow or is there a scripting tool that will allow me to build and maintain security policies across multiple datasets? Doing it manually through the UI is very tedious and would love to have…

To my knowledge it is not possible. This has caused confusion with our users as well. I like the insights but I agree that the Quick Filters tab should be the default, especially on cards that are not supported by Insights, such as Table cards.

Would this new functionality work for this scenario? Basic recursive dataflow Dataset A - contains 25M rows (base data) Dataset B - contains 1M rows (new data) transform dataset B and union to Dataset A for final output. Dataset A now contains 26M rows. Rinse and repeat daily. Could I edit this existing dataflow and remove…

Workbench has a service that runs the jobs. Workbench does not need to be open on your PC but the PC must be on and the service running for the file watch to continue uploading files.

Data Fusions are so much faster than dataflows especially when you are dealing with many millions of rows. It would be awesome if there was a way to apply PDP but unfortunately I do not think this will be happening anytime soon.

The size of the dataset will affect the time it takes to complete. The data needs to be loaded, transformed, and then uploaded and indexed in the presentation layer. Large datasets will take time to go through the process even if the transforms only take seconds.

My recommendation would be to create cards of charts that you commonly use and set the base default properties. Use these cards as templates and always start a new card by creating a copy of the template for the card you are building.

2 years later and I have the same question. 95% of our users are participants and would like the ability to add collections to their favorites page. Anyway to allow this ability without making all users editors? I cringe at the thought of doing such a thing.

I marked solutions by both @Property_Ninja and @ST_-Superman-_ as they both helped me in arriving at the final solution. Thanks again.

It is important that the totals remain calculated on the fly due to PDP policies and applying card filters. I was able to create the card with the correct totals and the drill down functionality by editing my dataflow to stage the data differently so I could sum all of the fields. Thank you all for the feedback and ideas.…

Brian, sum(distinct `staffing_level`) will not work correctly if two departments have the same staffing level. We are attempting to sum all rows and divide it by the number of employees. This works for each row but the grand total row for some reason is not a whole number. In this example using the Main Bar department the…

Getting closer but still a strange total on the staffing_level beast mode. Here are the beast modes I am using staffing_level sum(`staffing_level`)/count(distinct ifnull(`EmpID`,1)) number_employees count(distinct `EmpID`) ** I had to remove the ifnull() because it was causing null records to be counted as 1 **

Brian, I could create and add total rows to the dataflow but then my card has no dynamic capabilities and any card filtering at the department level will not be reflected in the totals. Originally this card was summarized at the daily level and subtotals/totals worked fine but users are requesting the ability to drill down…

In the data center you can click on the check mark next to multiple datasets, click on the gear icon and choose delete.

The beast mode validates fine when I tried it by replacing the `Transactions` column with a numeric column from my dataset. Are you sure `Transactions` is the correct column?

Thank you Aaron. It is not pretty but it does add the additional filtering options we require. If Domo gave us the ability to 'Select All' on searched filters it would make it a little better. Thanks again for the different perspective to solve the problem. Chris

Thanks for the ideas Aaron. Unfortunately the salespoint groups are dynamic and I did not believe that 120+ additional columns for filtering would be a good user experience. I could easily put all of the salespoint groups comma separated in a new column but I am not sure how that would help me filter. Could you please…

This scenario is because the data is older than the scheduled refresh of the data. We pull data hourly from a system that only processes transactions in winter months. The workbench job still runs every hour but the data has not changed which in this case is expected. Once that system begins processing again in November…

This is an issue with the Domo App. Css in the summary number is "not supported" but it will work in the web browser. I have color coded text and symbols in summary numbers and they work perfect in the browser but in the app the color is always black. We can hope that one day soon the app will support this functionality…

The beast mode below should help: concat('<div style="color: green">Your text here</div>','<div style="color: white">',sum(0+0),'</div>') This case statement will display an up or down error or nothing based on value of the revenue field. concat( case when sum(`revenue`)>0 then ' ⇧ ' when sum(`revenue`)<0 then ' ⇩ ' else…

Table changes such as adding fields and indexes must be done in their own transforms and you need to uncheck the box for 'Generate Output Table'. The other way to accomplish the table creations and alters would be to create a procedure and then call that procedure from another transform. If I understand what you are trying…

Fantastic solution! I forgot about the beastmodes being utilized in drill down cards. I found the last remaining card and successfully deleted the beastmode. Thank you, Chris

100% reproducible! I currently have a table card setup with 2 quick filters. I select the filters and drill down to the next level and everything works fine. Edit the card and the quick filters are now set to "Not In". If I edit this card I have to change the quick filters back to "In". I will open a support case since…

Domo hass implemented the window and rank functions in Magic ETL. This is another option if you prefer not to use redshift.

You can use the following: convert_tz(Now(), 'utc', 'us/pacific') Using the full time zone name with convert_tz will adjust for daylight savings time.

No problem at all. Glad I could help. You may find this link helpful as you are learning SQL.

I am not sure if this is your problem but do you not have the windows docked? You should see a tab on the left of the screen for Accounts and tabs on the bottom for Preview and Output. Clicking on any of those tabs should open the panels. No other advice to offer since my workbench UI is functioning normally this morning.

Replace the WHERE with a comma. The WHERE clause needs to be after the FROM Try the following: SELECT *, CASE WHEN (FcstName LIKE '%Fcst%' AND 'Rev Month' = 1) THEN ('Margin EV'*0.314/GM_Pct) ELSE 'Margin EV' END AS MarginEVAdj FROM sales_pipeline

I was able to get the dataflow running in the 15-20 minute range again by converting the time zones before performing the join. Thank you.

It sounds like your card may have broken. This can happen for various reasons such as changing the underlying dataset or altering a beast mode. It does not happen frequently but the only thing I have been able to do when this happens is to delete the card and create a new one. Good luck.