Best Of

Rank Tile Not Grouping, Needs Case Sensitive box

I am using the Rank tile, ordering on a Timestamp and the column that makes up a partition is Customer. For example, I have "CUSTOMER A" and "Customer A." These are in the raw data and represent different clients, but the Rank is treating them as the same. I will probably value map one of variations to be unique, and I'll have to repeat the process for any other Customers with a similar issue. This could be solved with a Case Sensitive check box in the partition section.

a10hall

Re: How to Execute a Workflow From Another Workflow?

Are we talking workflows or dataflows here? Workflows have a service task to start another workflow called START WORKFLOW. You can find this in function library when you go to select a service task.

JosephMeyers

New Filter chart types

Hello Everyone,

I have read below information on Filter chart types, I belive few like me still are not aware of this. Now we can add checkbox, radio button, calender, etc as a interactive chart type. You can find this under "Filter" chart type.

https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Slicer,_Checkbox,_and_Radio_Button_Cards

Thanks,

Neeti

Re: Tracking Datasets connected in other DataFlows

@larryjacobs Here's a screenshot of a dataflow that I use to find unused datasets.

Here's the JSON for it, which you can copy and paste into an empty ETL and then connect your Domo Governance Datasets at each input spot and then see which fields I am using for each. Hopefully, this will help you know which field to use in which spot.

{"contentType":"domo/dataflow-actions","data":[{"name":"Governance Cards and Datasets","id":"33894b88-f1db-4c12-b219-5fc61214ed00","type":"LoadFromVault","gui":{"x":336,"y":396,"color":3238043,"colorSource":null,"sampleJson":null},"dependsOn":[],"removeByDefault":false,"notes":[],"dataSourceId":"c8948098-4d4e-44ea-98b9-1ec27e87201f","executeFlowWhenUpdated":true,"onlyLoadNewVersions":false,"columnSettings":{},"visiblePartitionColumn":null,"versionWindow":null},{"name":"Governance Dataflow Details","id":"65fbdb57-a671-44fb-96b9-c47ca68e1a8d","type":"LoadFromVault","gui":{"x":60,"y":84,"color":3701798,"colorSource":null,"sampleJson":null},"dependsOn":[],"removeByDefault":false,"notes":[],"dataSourceId":"3f42202b-a267-4529-a759-d4bee36bf425","executeFlowWhenUpdated":true,"onlyLoadNewVersions":false,"columnSettings":{},"visiblePartitionColumn":null,"versionWindow":null},{"name":"Governance Datasets","id":"9932cdf4-77ee-46f7-b75a-f6934c295c99","type":"LoadFromVault","gui":{"x":420,"y":264,"color":10827556,"colorSource":null,"sampleJson":null},"dependsOn":[],"removeByDefault":false,"notes":[],"dataSourceId":"45936f76-96e7-41d9-bc14-c4ea8342b113","executeFlowWhenUpdated":true,"onlyLoadNewVersions":false,"columnSettings":{},"visiblePartitionColumn":null,"versionWindow":null},{"name":"Add Formula 1","id":"54019408-04fb-4e51-af88-4c7491434811","type":"ExpressionEvaluator","gui":{"x":516,"y":264,"color":null,"colorSource":null,"sampleJson":null},"dependsOn":["9932cdf4-77ee-46f7-b75a-f6934c295c99"],"removeByDefault":false,"notes":[],"expressions":[{"expression":"LOWER(Dataset ID)","fieldName":"Dataset ID","settings":null}]},{"name":"Get dataset list","id":"ca1e9b38-29e0-4292-80d1-32e3c7640cb8","type":"SelectValues","gui":{"x":624,"y":264,"color":null,"colorSource":null,"sampleJson":null},"dependsOn":["54019408-04fb-4e51-af88-4c7491434811"],"removeByDefault":false,"notes":[],"fields":[{"name":"Dataset ID","rename":null},{"name":"Name","rename":"Dataset Name"},{"name":"Description","rename":null},{"name":"Owner Name","rename":null},{"name":"DataSet Last Updated Date/Time","rename":null}]},{"name":"Add Formula 2","id":"17ea7d42-8c59-463e-8e46-156912fcea68","type":"ExpressionEvaluator","gui":{"x":432,"y":396,"color":null,"colorSource":null,"sampleJson":null},"dependsOn":["33894b88-f1db-4c12-b219-5fc61214ed00"],"removeByDefault":false,"notes":[],"expressions":[{"expression":"LOWER(Dataset ID)","fieldName":"Dataset ID","settings":null}]},{"name":"Select Columns","id":"f774d400-fd50-45c6-b8c9-ac83264ac6bc","type":"SelectValues","gui":{"x":540,"y":396,"color":null,"colorSource":null,"sampleJson":null},"dependsOn":["17ea7d42-8c59-463e-8e46-156912fcea68"],"removeByDefault":false,"notes":[],"fields":[{"name":"Dataset ID","rename":"Card Dataset ID"}]},{"name":"Get Distinct List of Datasets from Cards","id":"27da235a-ba24-4039-8797-703282fef344","type":"Unique","gui":{"x":648,"y":396,"color":null,"colorSource":null,"sampleJson":null},"dependsOn":["f774d400-fd50-45c6-b8c9-ac83264ac6bc"],"removeByDefault":false,"notes":[],"countRows":false,"partitionedAggregation":false,"fields":[{"name":"Card Dataset ID","caseInsensitive":false}]},{"name":"Datasets used in Cards","id":"4a82b468-03b8-46aa-acac-058581359745","type":"MergeJoin","gui":{"x":744,"y":336,"color":null,"colorSource":null,"sampleJson":null},"dependsOn":["ca1e9b38-29e0-4292-80d1-32e3c7640cb8","27da235a-ba24-4039-8797-703282fef344"],"removeByDefault":false,"notes":[],"joinType":"INNER","step1":"ca1e9b38-29e0-4292-80d1-32e3c7640cb8","step2":"27da235a-ba24-4039-8797-703282fef344","keys1":["Dataset ID"],"keys2":["Card Dataset ID"],"schemaModification1":[],"schemaModification2":[],"partitioningInputId":""},{"name":"Add Formula","id":"5182b3ca-c63e-4cb2-9ba8-a86105237049","type":"ExpressionEvaluator","gui":{"x":168,"y":84,"color":null,"colorSource":null,"sampleJson":null},"dependsOn":["65fbdb57-a671-44fb-96b9-c47ca68e1a8d"],"removeByDefault":false,"notes":[],"expressions":[{"expression":"LOWER(Input Dataset ID)","fieldName":"Input Dataset ID","settings":null},{"expression":"LOWER(Input Dataset ID)","fieldName":"Output Dataset ID","settings":null}]},{"name":"Input Datasets","id":"c67400ed-ce79-4c5a-aedb-0540453710a6","type":"Filter","gui":{"x":288,"y":48,"color":null,"colorSource":null,"sampleJson":null},"dependsOn":["5182b3ca-c63e-4cb2-9ba8-a86105237049"],"removeByDefault":false,"notes":[],"filterList":[{"leftField":"Input Dataset ID","rightExpr":null,"operator":"NN","andFilterList":[]}]},{"name":"Select Columns 1","id":"6bbfa462-5f36-40c6-9937-74f95f8e2aba","type":"SelectValues","gui":{"x":396,"y":48,"color":null,"colorSource":null,"sampleJson":null},"dependsOn":["c67400ed-ce79-4c5a-aedb-0540453710a6"],"removeByDefault":false,"notes":[],"fields":[{"name":"Input Dataset ID","rename":"Dataflow Dataset ID"}]},{"name":"Output Datasets","id":"0b6606d8-6fbd-452a-b4c2-d4a827b83f5d","type":"Filter","gui":{"x":288,"y":144,"color":null,"colorSource":null,"sampleJson":null},"dependsOn":["5182b3ca-c63e-4cb2-9ba8-a86105237049"],"removeByDefault":false,"notes":[],"filterList":[{"leftField":"Output Dataset ID","rightExpr":null,"operator":"NN","andFilterList":[]}]},{"name":"Select Columns 2","id":"44d46c42-4d14-48c0-ae80-5fb9a5d4bb05","type":"SelectValues","gui":{"x":396,"y":144,"color":null,"colorSource":null,"sampleJson":null},"dependsOn":["0b6606d8-6fbd-452a-b4c2-d4a827b83f5d"],"removeByDefault":false,"notes":[],"fields":[{"name":"Output Dataset ID","rename":"Dataflow Dataset ID"}]},{"name":"Append Rows","id":"d77f59d1-ba97-40fa-bf07-e12d3a173345","type":"UnionAll","gui":{"x":516,"y":96,"color":null,"colorSource":null,"sampleJson":null},"dependsOn":["6bbfa462-5f36-40c6-9937-74f95f8e2aba","44d46c42-4d14-48c0-ae80-5fb9a5d4bb05"],"removeByDefault":false,"notes":[],"unionType":"INCLUDE_FROM","schemaSource":"6bbfa462-5f36-40c6-9937-74f95f8e2aba","strict":false},{"name":"Get Distinct List of Dataset IDs from Dataflows","id":"ed20cf4d-77fe-438f-b4d2-089ec24f1dac","type":"Unique","gui":{"x":624,"y":96,"color":null,"colorSource":null,"sampleJson":null},"dependsOn":["d77f59d1-ba97-40fa-bf07-e12d3a173345"],"removeByDefault":false,"notes":[],"countRows":false,"partitionedAggregation":false,"fields":[{"name":"Dataflow Dataset ID","caseInsensitive":true}]},{"name":"Datasets used in Dataflows","id":"f3770b41-7fd6-457b-bece-83643a7e16e8","type":"MergeJoin","gui":{"x":744,"y":192,"color":null,"colorSource":null,"sampleJson":null},"dependsOn":["ca1e9b38-29e0-4292-80d1-32e3c7640cb8","ed20cf4d-77fe-438f-b4d2-089ec24f1dac"],"removeByDefault":false,"notes":[],"joinType":"INNER","step1":"ca1e9b38-29e0-4292-80d1-32e3c7640cb8","step2":"ed20cf4d-77fe-438f-b4d2-089ec24f1dac","keys1":["Dataset ID"],"keys2":["Dataflow Dataset ID"],"schemaModification1":[],"schemaModification2":[],"partitioningInputId":""},{"name":"Append Rows 1","id":"be88fa60-c968-4d83-b730-986c5a9bcf62","type":"UnionAll","gui":{"x":900,"y":264,"color":null,"colorSource":null,"sampleJson":null},"dependsOn":["f3770b41-7fd6-457b-bece-83643a7e16e8","4a82b468-03b8-46aa-acac-058581359745"],"removeByDefault":false,"notes":[],"unionType":"INCLUDE_MATCHES","schemaSource":"f3770b41-7fd6-457b-bece-83643a7e16e8","strict":false},{"name":"Join Data","id":"c471c3f1-19a8-476c-be71-2388ab2301d1","type":"MergeJoin","gui":{"x":1020,"y":288,"color":null,"colorSource":null,"sampleJson":null},"dependsOn":["ca1e9b38-29e0-4292-80d1-32e3c7640cb8","be88fa60-c968-4d83-b730-986c5a9bcf62"],"removeByDefault":false,"notes":[],"joinType":"LEFT OUTER","step1":"ca1e9b38-29e0-4292-80d1-32e3c7640cb8","step2":"be88fa60-c968-4d83-b730-986c5a9bcf62","keys1":["Dataset ID"],"keys2":["Dataset ID"],"schemaModification1":[],"schemaModification2":[{"name":"Dataset ID","rename":"Used Dataset ID","remove":false},{"name":"Dataset Name","rename":"Append Rows 1.Dataset Name","remove":true},{"name":"Description","rename":"Append Rows 1.Description","remove":true},{"name":"Owner Name","rename":"Append Rows 1.Owner Name","remove":true},{"name":"DataSet Last Updated Date/Time","rename":"Append Rows 1.DataSet Last Updated Date/Time","remove":true}],"partitioningInputId":""},{"name":"Datasets Not Used","id":"da93d898-e6cc-4123-bf8f-8d08ef34d5f4","type":"Filter","gui":{"x":1128,"y":288,"color":null,"colorSource":null,"sampleJson":null},"dependsOn":["c471c3f1-19a8-476c-be71-2388ab2301d1"],"removeByDefault":false,"notes":[],"filterList":[{"leftField":"Used Dataset ID","rightExpr":null,"operator":"NL","andFilterList":[]}]},{"name":"Unused Datasets","id":"5069208b-aaf1-4006-9a6b-2accdb850590","type":"PublishToVault","gui":{"x":1260,"y":288,"color":null,"colorSource":null,"sampleJson":null},"dependsOn":["da93d898-e6cc-4123-bf8f-8d08ef34d5f4"],"removeByDefault":false,"notes":[],"dataSource":{"guid":"7963e9b8-4642-4e9d-a17b-2b70b64fafdc","type":"DataFlow","name":"Unused Datasets","description":"Uses Domo Governance Datasets to identify unused datasets","cloudId":"domo"},"versionChainType":"REPLACE","partitionIdColumns":[],"upsertColumns":[],"retainPartitionExpression":""}]}

MarkSnodgrass

Re: Beast Mode calculation

I would do it in a dataflow. In Magic you would use the formula tile to get the flag on rows with a 100 in them and then use the group by tile to group on SO # and then join on SO # back to your granular data. Then you'd have a flag for each SO # that has an order product in it with 100 as shown in my last screenshot above. See below and let me know if you need more details:

Screen Shot 2023-06-26 at 1.32.44 PM.png

ColemenWilson

Re: Create a Function to extraxt a specific secuency of numbers

Ash.JPG

Grant.jpg

@GrantSmith @Ashleigh Thank you both. I´ve test making use both method and worth it. I appreciated your support

Vivarafa