Best Of
Unlock 100% of your data across 100% of your business
Modern BI for all whitepaper linked here.
Re: Odd sorting issue when filtering
@user048760 Yes, using SUM would change the sorting. Click on the pencil icon to edit the sorting criteria and choose No Aggregation. That should fix your issue.
Re: DataFusion Colorblind
That's interesting Domo chose those colors as they are usually pretty color conscious. I don't see anything in their documentation that allows you to change which colors are being used. A couple of ideas for you:
- Submit this issue in the Ideas Exchange section of the Dojo to allow for this customization or have them select better default colors.
- Use Dataset Views - If you don't have access to this, talk to your CSM about getting this feature enabled.
- Use Magic ETL 2.0 - This is currently in beta, but I hear it is close to being released to everyone. You can ask your CSM if they can enable this beta for you. It processes data much faster than the current Magic ETL.
Hope this helps.
Re: Dynamic Text on Dashboard textbox?
Hi @user007486
You can utilize a beast mode to dynamically generate some text. If you're wanting to utilize this text as a summary number then you must use an aggregate function (sum, count etc). Beast modes without an aggregate function are not supported as summary numbers.
Assuming you have a value and target columns the following would work on a row level:
CASE WHEN `value` > `target` then 'Increase' WHEN `value` < `target` then 'Decrease' ELSE 'Same' END
To use it as a summary number (your logic will vary):
CASE WHEN SUM(`value`) > SUM(`target`) then 'Increase' WHEN SUM(`value`) < SUM(`target`) then 'Decrease' ELSE 'Same' END
Re: Programmatically run a dataflow/dataset
? ok... so ... tradesies.
i'm taking the time to help you. in exchange, i'd appreciate it if you do a writeup for the community that steps through the final (anonymized) script you develop.
deal?
what you're encountering here, is the difference between using a public vs a private API. hence why it's asking you for a different authentication method.
{"status":401,"statusReason":"Unauthorized","path":"/api/dataprocessing/v1/dataflows/350/executions","message":"Full authentication is required to access this resource","toe":"XXXXXXXXXXXXX"}
In order for this to work you must:
send a POST request to
https://yourDomoInstance.domo.com/api/content/v2/authentication
Re: Convert Week Numbers to Start of the Week Date
You can create a beast mode to calculate the first day of the week with this:
DATE_SUB(`dt`, INTERVAL (DAYOFWEEK(`dt`) - 1) DAY)
You would then drag this field into your table and then change your date filter to group by none.
@GrantSmith did a nice write up about this and other date functions here in case you want to dig deeper.
Re: Are "Joins" case sensitive
Typically joins are going to be case sensitive.
https://domohelp.domo.com/hc/en-us/articles/360043427733-Magic-ETL-Tiles-Combine-Data#3.
https://domohelp.domo.com/hc/en-us/articles/360044876194-Magic-ETL-v2-Tiles-Combine-Data-Beta-#3.
Re: Are "Joins" case sensitive
Yes, I have found that joins (at least in Magic ETL) are case sensitive. You can use the Formula tile (if you have Magic ETL 2.0) or the Text Formatting tile (if you have Magice ETL 1.0) and use the UPPER function to convert everything to uppercase prior to joining.