Best Of
Re: Comparative Gauge using Scale Abbreviation for Value Change
Agree with @RobSomers that you should submit it to the Ideas Exchange as the gauge should have that feature. I have found the comparative gauge a bit too limited. I tend to use the multi-value gauge, which has a lot more customization options and can show the value or percent difference between two values.
Re: Adobe Analytics JWT v2 Connector Multiple Segments
Hi @t238, how did you go with this?
Admittedly, there's not much resources available online on Adobe Analytics connectors and Domo but what I understand from this article [https://domohelp.domo.com/hc/en-us/articles/360063205353-Adobe-Analytics-API-v2-Connector-with-JWT-authentication-and-Partition-Support], there's a limit to the segments you can bring through your report (i.e. Just 1 segment). Using the OAuth route, you can bring in multiple segments but that has a token refresh limitation. It's worth bringing your case to your Customer Success representative and/or arranging consulting hours if you haven't already and want to avoid the workaround of having multiple reports setup through JWT.
Also, there's the option of creating the report on the AA Workspace and then setting up a email forwarding connector to Domo. Food for thought if anything else.
amehdad
Re: Vertical Symbol + Grouped Bar chart Question
@ozarkram Try changing your beast modes on the Y axis and series so the case statements are within the aggregate.
For example UNITS ON ORDER LY ORD DATE should look like this :
COUNT(CASE WHEN `FISCAL_YEAR` = `CUR_FISCAL_YEAR`-1 THEN `units` END)
Re: How do I create this dual x-axis type of chart in Domo
It's a Trellis Chart. You can read more on those here: https://domohelp.domo.com/hc/en-us/articles/360043428713-Applying-DataSet-Columns-to-Your-Chart#6.
Re: Is there a way to track user reported card issues if you are not the card owner?
You got me moving in the right direction - correct dataset. Action = Created, Object_Type = Huddle
Re: At what stage should column renaming happen
Typically I'll do the same, pull in the raw tables with the actual field names then consolidate the business logic and renaming of the columns to be a standard value in the ETL (Magic or View) this way the same name is used across all cards and I have my actual raw tables with no modifications for easier debugging.
Re: Independent filtering within a dashboard, using the same column
Hi @bradw
Due to how filters function within Domo you can't have a single filter column and multiple values applying to different cards. You could copy the date value into a different column and then have the other cards use the new column instead of the first column so they're separate values to filter on. Because you're using dates you'll want to also disable the global date filter on the page otherwise both will be filtered based on the same date.
Re: Vertical Symbol + Grouped Bar chart Question
Thank you so much @MichelleH ...This works!..Really appreciate your help!
ozarkram
Re: Data Interval Using Business Days In MagicETL
@adamxor - Do you have a dataset that contains a list of days and whether they are a "business day"?
If you are only wanting to exclude weekends, then you could write a statement that changes the number of days to add based on the day of the week of CreationDate.
