Best Of

Compare two peer groups

Hi, I'm not sure if this is possible using DOMO native toolset. I would love to be able to compare two peers groups performance against each other. A super simple select and compare of two things dynamically.

For example if this is my data:

Campaign | Money Made

A | $5

B | $10

C | $20

D | $5

How can I create a card where I can mix/match compare on one chart? Something like the screenshot below.

Basically what I'd like to do is create a filter that's called 'Campaign Group 1' and be able to select A and B. Then have another filter celled 'Campaign Group 2' and select C and D. Then have the chart show two bars -- one showing how Campaign Group 1 performed and one showing how Campaign Group 2 performs.

I know I can make variables that allow selection of specific hard coded strings, but I don't really see a dynamic variable option where I can have two selections based on string values that are in the dataset and it's not feasible to input tons of list items (campaigns) manually.

Hoping there's an easy solution! Thanks all.

G_Grey

1

Re: Adding Hyperlink to table values

Hi, MechelleH, Thanks for help, but I found the exact issue, the issue was that my link was not starting with "Https//" - I chnaged it and the issue was solved.

Thanks a lot to community for great help. Let me share what all important points need to take care whole doing this.

The link in the column should start with "Https://"
In formula the "Link" is the field name of the column in which the links are there - CONCAT('<a href="', `Field name of the column`, '" target="_blank">', '</a>')

Jigar_Thakkar

1

Re: Adding Hyperlink to table values

@Jigar_Thakkar What interaction settings to you have configured for that card in the dashboard?

MichelleH

1

Re: domo.ds_rename not found

You can update the schema (specifically the dataset name) using the update method and updating the schema. There's an example in pydomo: https://github.com/domoinc/domo-python-sdk/blob/dacdee87d9e798f4c83f270b38c8ea2b1b6c7923/examples/dataset.py#L32

GrantSmith

1

Re: Problems with Workbench, ODBC, MySQL and the data specialist exam

Hi, just thought I would update this case. I figured out what the problem was.... There was a missing step in the instructions, Domo should have mentioned that the in the Database Query Editor you needed to insert the following SQL command = SELECT * FROM Transactions. I managed to figure this out as the message was saying there was a blank field and I went through all of the fields to figure out this was the missing information.

Thanks

Ian

Case resolution.png

IanMaddrell

4

Re: Previous, Current, and Next Quarter Date Range in a chart

Hi @gsharma ,

A bit confused so looking for clarification. In your first paragraph you are saying you want to see previous, current and next quarter, but in the second you don't want to do the fitler on those 3 because it would limit the chart to only those 3. I'm not understanding because it sounds opposite of what you want....looking for more clarification to help.

Thanks,

John Le

You're only one dashboard away.

More video solutions at: https://www.dashboarddudes.com/pantry