Best Of
Re: Text column as values in Pivot table.
I wanted to pivot a column's values as columns and use text values from a Beast Mode calculation in the cells. Since Pivot Tables 'values' require aggregation, I applied MAX to my Beast Mode and it worked for me. Thank you so much for your assistance, and I apologize if my question was not articulated properly.
Re: Text column as values in Pivot table.
The values section is meant for aggregation, because it is possible that when your Rows and Columns intersect that there may be more than one value present.
When you place your text field in the values section you're only provided with Count as the method of aggregation, however, if you create a beast mode with the value MAX(`Your Text Field`) then the pivot table will accept that as a valid method of aggregation and display the max text value.
Re: Drill Down From Summary To Detail Records
You can use different datasets in your drill path. They just need to contain the same field that is being drilled into. Here is a note from this KB article that may help.
Notes: 1) The new DataSet must contain the same category and series column name(s) you filtered off of in the original DataSet. The column data should also be the same; however, the column in the second DataSet may contain additional data items not found in the original DataSet. Value columns you have filtered off of in the original DataSet do not need to be present in the second DataSet. For more information about category, series, and value columns, see Understanding Chart Data. 2) If your DataSet contains more than one sheet and you want to connect to the data in another sheet, you must first re-upload the DataSet, being sure to select that sheet in the Review your Data dialog. This creates a new DataSet that you can connect to like any other DataSet.
For your KPI card, test drilling into the card and see what Domo is filtering on. This will tell you which column needs to be in drill path dataset.
Re: Any Function to decode UTF-8 characters available in Domo?
Hello @b_rad,
You can achieve this with a simple Python script. Here's the input:
The script:
Replace 'Domo Forum Answer 2' with the name of the tile preceding the Python Script tile and 'ID' with the column name in your dataset. The result will be:
Re: How can I display data up to the last completed month
The case provided did help however, it wasn't the exact solution i was looking for. I ended up going with the below statement for my exact need.
(CASE when `Date` <= LAST_DAY(DATE_SUB(CURRENT_DATE(),interval 1 month)) then 'Include'
else 'Exclude' end
)
cbishop
Re: Dynamic Date in card tittle
Try this:
CONCAT('<span style="font-size:10px;">Data as of ', MAX(Transaction Date),'</span>')
Auto Refresh a card from Federated source
Hello All,
is it possible to configure auto refresh at certain time interval when we have card ( visual ) in view mode
I am only talking about federated connections in DOMO.
Re: Starting a workflow from a Domo App
Ah ha! That was it. Changing the startName in the manifest did indeed fix the issue. Workflow started up correctly after changing it.
Thanks both of you for the help!
AJOslund
Re: Move multiple cards from 1 tab to another tab in the same App?
While you can't move tabs, you can use the multi select feature to move multiple cards at once from your page to another page. Use Command + Click on Mac or Windows + Click on Windows to select the cards and use the Add to option to add these cards to the app pages/dashboards of your choice at once.
Re: Arrangement in Bar Graph
You can use a beast mode to define a custom sort value to use in the sorting section of your chart
CASE WHEN `field` = 'Ro' THEN 1 WHEN `field` = 'Ac' THEN 2 WHEN `field` = 'Tr' THEN 3 END
