ColinHaze Member

Manasi_Panov & DavidChurchman Thank you both! Im gonna try out this text variable and see how it goes.

Manasi_Panov & DavidChurchman Is there an easy way to populate the variables without having to manually enter all the citys in?

Manasi_Panov Here is some sample Data. CitySelector is a beastmode that is the shipper_city_State Field. DavidChurchman When I select a certain city off the cityselector, only those with matching shipper_city_states appear on the card, none with matching consignee_city_states appear.

I was getting this same error, the way I fixed it was instead of clicking the 'Unnest columns as root', I just 'expanded the array as rows'.

ArborRose Talking about this brick, its one that's already made. The only lines I've changed were these. Just not understanding why none of the cards are being filtered to the correct report number. Again, I really appreciate your help.

Its a custom app already built, it already has that container in the JS. I am just not understanding why its not working.

ArborRose Am I missing something on how to use the searchable ddx brick? I tried going to and using the first brick and none of the cards filter to that location?

ArborRose Thank you sir.

MichelleH I am actually using SQL Transformation.

ArborRose Are you talking about when the dataset updates have an alert on the dataset itself?

trafalger Mainly just to style it the way I want lol. Thank you sir

GrantSmith I added the projected value and couldnt figure out how to get the correct columns to stack. Apparently it has to do with the series order so I figured that out. Thank you sir for the recommendation of append.

Ah, I believe its because you must have the Title of the card showing. Otherwise it will not appear.

ColemenWilson Its configured the exact same way. Im having to reload the page each time I drill down in order to get back to the original card.

Data_Devon, This Card is in app Studio. Im not sure im following. I added a second View on my drill path and its drilling in place which is great but its still not filtering the other cards on the app. It just keeps drilling down. I tried to enable interactive filters but it no longer allows me to drill in place. Does that…

Make sure you are using the "Compare to" selection in the date field.

I was wondering the same thing but I dont believe the Apps have that feature yet. You can always create a test user and throw the test user into different pdp policies, a little time consuming but might be worth it.

I ended up taking Jonathans Advice and just running it through the dataflow. Thanks all!

I did something very similar, and I built it all entirely off of the Calendar Dataset. Ill walk you through how I did it at a high level and if you need clarification let me know. I'm also sure there are better ways but it took me a minute to get this working. I first used a case statement to assign the dates that I want…

ArborRose I ended up just running it through an ETL and aggerating it there. Thank you for the insight!

ArborRose Here is my Console. It works when I remove the Sum distinct part in the query. I change nothing else in my code but adding Sum Distinct, here is what I get. (With Sum Distinct) (Without Sum Distinct)

@ColemenWilson I ending up doing it your way. Thank you

@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…