Best Of
Period Over Period Waterfall
My idea is for you to introduce a period over period waterfall bar, which allows the user to easily create a waterfall to reveal the drivers of variance between 2 periods.
Re: Stop code: System_service_exception (the new blue screen of death)
Definitely reach out to Support [support.domo.com] so they can be across this incident and have a deeper look on their end (via the dev team)
amehdad
Re: How to use a calculated field in a SUM function? (Statistics)
Hi @ramoshe, you'll need to use the 'Group By' tile to get your average (or any aggregation) field. Have a look at this article [https://domohelp.domo.com/hc/en-us/articles/360044876094-Magic-ETL-v2-Tiles-Aggregate-Beta-] to better understand how to configure 'Group By' before adding it in your ETL.
amehdad
Re: what does the delta symbol mean on my data flow ?
Hi @Kalyan, there could be one of a few things happening for you.
When you look at the 'Lineage' of your dataset, and you click on the dataflow that is highlighted in Orange, it should mention under the name/heading of your dataflow the reason for this needing your attention (i.e. Field "xxxx" does not exist).
It could also be that there is a temporary server issue during data processing (i.e. Many dataflows are updating at the same time or an external issue on Domo side).
Another thing to check is, in 'Accounts', whether one of the account credentials used to pull your data is showing the attention symbol. If so, you would need to reconnect your account (i.e. Re-Authentication on the platform/app side).
Hope that helps. Let me know how you go.
amehdad
Re: How to indicate story pages and regular pages on page list
Hi @eriena, the Governance Dataset connector currently doesn't have the field 'Page Type' or similar, so it's worth making a request for that in 'Ideas Exchange' or asking your Customer Success representative to investigate in anticipation for the next version update (It looks like it was last updated in April). As a workaround, you can create a beast mode. An example is:
CASE
WHEN 'Page ID' = '1234567' THEN 'Story'
WHEN 'Page ID' = '2345678' THEN 'Regular'
ELSE 'Not Mapped Yet'
END
You would continue to manually add in different instance of your pages. Hope that helps.
amehdad
Re: How to include include Pie chart inside Map Chart
@Dharshini, you could also look to use Tooltips [https://domohelp.domo.com/hc/en-us/articles/360043429693-Formatting-Data-Label-and-Hover-Text-in-Your-Chart] to show the percentage allocations as a hover text. For example, when someone moves their mouse over 'CA', it can show as:
California: 56 Universities
Private: 55%
Public: 45%
amehdad
Re: How to convert a Beast Mode with a CASE function in it into an aggregation?
Hi @user030119
The error is occurring because there's an aggregate function (i.e. SUM) on top of an aggregate function (i.e. AVG), which isn't possible to process in a beast mode.
What could work is to set up AVG(`Probability of Accident in Decimals`) as a separate calculation before Analyzer (for example, as a calculated field in the ETL) and then write your formula using the newly created measure.
There's also the consideration of whether summing up averages is going to give you the right numbers to solve your business problem/situation.
amehdad
Re: Beast mode calculation for aggregating data
Hi @Lashes, could you please share your code and the full error message?
Here's a start:
SUM(CASE WHEN 'days until due' >= -9 AND 'days until due' <= -1 THEN '1-9 days'
...
END)
amehdad
Re: Export Dashboard to Excel
@ChaseFinanceData, considering that there's multiple unique datasets you're working with, you're better off doing the bulk of the work through that Excel plug-in. It offers a 'Query Builder' so you can re-create your table views across the different Excel tabs once and then continue to refresh the data via Domo Datasource Download Wizard. Definitely read through the link Mark provided before trying it out.
amehdad
Re: Domo- Tableau conection.
Hi @Tsharma8724, there's currently no Tableau connector in the existing Domo Appstore, although there could be an add-on connector that your customer success rep could inform you on (albeit additional cost if it exists). Otherwise, you can look through the Appstore to connect to the native data source(s) that feeds into Tableau or look at Workbench, depending on your use case.
amehdad