ColinHaze Member

@ColemenWilson I thought that was the only way. Its the exact same schema, will this have a negative effect on beastmodes?

@DavidChurchman & @ArborRose No idea what the issue was. Without making any changes it now works. Guess it was just throwing a fit lol.

@Stu5677 I had a similar issue. The way I solved it was make it a tiered chart and I put the date filter as the category. When I click on 2024-04-01 it drills down to all the data that powers the chart.

ArborRose Thank you for the advice, Straight out of college and the only one in my company that uses DOMO so thanks for answering the most basic questions LOL!

ArborRose I guess the issue I am having is that I am using two different cards. Would you recommend just having one card with a user input box at the top with the table below?

GrantSmith The ddx Bricks are using two different datasets, would that be a problem? The DDX Filter Brick strictly just has the locations for filtering, the table Brick has columns with values like sales, cost etc…

ArborRose Its sorting, I figured out the filtering issue. Ideally Whatever Location is selected first in my filter Brick, I want to display first in my table Brick, Then when a user selects the second location it is displayed second in my table.

DataMaven Here is the dataset that has every possible lane location joined together, its around 1.3 million rows and it looks like this. The Dashboard I am working on looks like this Which allows the user to search whatever lane they want. Once selected it will appear on the map and lane breakdown. Now based on this…

ArborRose Would you recommend the filter being a beastmode? I am having a hard time creating that filter without doing it the way where the dataset would be too big.

Zen and ArborRose Thank you for guys for the help and Example Solutions!

Worked great! Thank you

ellibot and MarkSnodgrass, I appreciate yalls advice, as someone who has 0 JS experience I was unable to solve this simple issue. Its frustrating because I know its so simple LOL. I think Im going to just use a simple table instead of using a DDX Brick to display this sentence. "Today is the [column1] of [column2]"

The solution I was able to work out was to make it a tier chart and put the location as the category so the user can click on the location and it drills in place to the next metric.

Thanks Mark!

@MichelleH Thank you so much!

Great Solution. We need it to only show one product at a time so this works amazingly. Thank you!

Agreed, I didnt set up this dataset nor do I have access to go and change it at the source system.

I believe Its only for a few, however, I was trying to future proof it in case new names are added.

Those questions allowed me to answer my own question. Thank you

ColemenWilson Same thing happens when I try to save it to overview. Do you know what grants I would need? I have View DomoApps, Create DomoApps, and Create DDX Apps. I am missing Manage DomoApps. Do you know if thats what might be causing this.

ColemenWilson I click the wrench, save as, select dashboard and I check the box that says take me to the card when done and then nothing happens. It just sit there.

marcel_luthi That seemed be the issue. I had a > sign in the Lane. My workaround was to replace > with "to". Thanks for the help!

GrantSmith I tried replacing all the %22 to %27 and that had the same result. Its weird because if I take out the first `Lane` the link displays the correct information but on the page it takes me to, it does not filter it by lane.

trafalger Same issue

MichelleH I actually just watched your video on "Proximity Matching." We use a load board to capture market rates. I really want to find a way to integrate the load board into DOMO without having to manually import the data.

ColemenWilson I just read about that one but we dont really use one drive. I was thinking either the Excel SFPT connector or workbench. Im not quite sure what the difference is.

Thank you, woulda never thought of that!

Jessica I am new to variables so Im not sure what you are asking. I am using one drop down variable with a chart to the left. If the variable is selected to show x then it will display the value corresponding to that KPI (if its related to a percentage then display a % at the end or if its related to a dollar amount then…

In the ETL version, Would I have to use a group by tile and then join that back to the data set?

When I tried that idea (making all the lines a comment besides the one I wanted to test) none of them had the correct format. I even tried taking it out of the case statement and taking CONCAT(ROUND(100*(1 - (SUM(PUPSTOPCOUNT_LATE) / SUM(PUPSTOP_COUNT))),0), '%') but the % would not show up.