Best Of
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 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: 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 add multiple Name Columns to a custom chart
Hi @ChelseaP, the SVG custom chart is only restricted to one name column, and as such Domo will map the values based on whether you drag 'Component' or 'Connection' into your Names field in Analyzer.
If in your data table, there's one primary field and the other is a secondary field, and you don't want to miss out on the additional details included in your diagram, then you can add the secondary field as a 'Tooltip' and it would appear as a hover text along with your primary column and datapoints. Have a look at this link for more information: https://domohelp.domo.com/hc/en-us/articles/360043429693-Formatting-Data-Label-and-Hover-Text-in-Your-Chart#h_01FF3GKJBJ85B75PWWE4Y88V48.
Let me know your thoughts.
amehdad
Re: Anything like Difference matrix, Difference between two pivots, difference within the value field?
One option is to utilize the lag window functions to calculate the difference between the current year and last year. The caveat to this is you can't have missing years between each salesperson and state (going from 2019 -> 2021 missing 2020 for example)
A pivot table would end up looking something like this which isn't ideal but close to what you're looking for I think.
Beast modes:
Last Year Sales:
LAG(SUM(`Sales`)) OVER (PARTITION BY `Seller`, `State` ORDER BY `Seller`, `State`, `Year`)
Last Year Sales Diff:
SUM(`Sales`) - COALESCE(LAG(SUM(`Sales`)) OVER (PARTITION BY `Seller`, `State` ORDER BY `Seller`, `State`, `Year`), 0)
Re: % of contribution
Hi @Adrien
You can use partitions in your window function:
SUM(`TOS`) / SUM(SUM(`TOS`)) OVER (PARTITION BY `Sales Leader`, `Month`)
Re: Domo Maps
Hi @Ashleigh
Are you wanting to the City DC to show up or have data for DC to show up?
Showing the city name can be done with the Cities > Show Cities option and turning it on.
If you're wanting to show the data you can make sure you're using the ZIP to FIPS connector (or the Domo Dimension connector with the zips_to_fips_latest.csv report). DC has a FIP code of 11001 which can show up on the map.
Re: Domo Ideas Exchange - Beast Modes - First / Last Days of the Month / Week
Hi @Derreck
You can just add a day to the date:
DATE_ADD(DATE_SUB(`dt`, INTERVAL (DAYOFWEEK(`dt`) - 1) DAY), INTERVAL 1 DAY)
End of the week:
DATE_ADD(`dt`, INTERVAL (7- DAYOFWEEK(`dt`) + 1) DAY)
Re: Summary Number Format in Notebook Card
Here's a screenshot of a dynamic textbox card in a dashboard if this helps:
