Ashleigh Coach

@D_Markley34 could you add the control directly to the card instead of the dashboard? What is the reasoning for using a variable here. Usually variables are used so people can change the values being shown, otherwise you can just hardcode the value in without needing a variable.

@luoqianhe did you get a token and enter it into the token variable?

@luoqianhe have you added any HTML or CSS code to the app?

@pauljames You could use the Domostats Datasets dataset and create a card directly from that if your dashboard uses one dataset or if you have multiple you can put it in a flow to determine which date you wanted to use. In the flow just filter for the dataset ID of the dataset you want to get the latest date from (if you…

@GrantSmith you always have the answers, thank you!!

@eddiesmall

@carthur if you share the page with the group it should auto share the datasets

@carthur do they have access to the datasets? You may need to try re-sharing the page with them.

Just a side note, this only works if the dataset is not recursive. If you had a recursive dataset you can't bring back those rows with the 3 dots. You would have to use another data recovery method to restore them.

I did try a waffle but could not figure out how to get it to reduce the waffle size to one row.

YES 🙌

@nathankilcrease I am currently working on converting all my stuff over but I was able to get the tracking ID from the Property Settings and then Property ID. I still need to figure out how to make the custom fields but everything else should work I think.

@PJG Filter cards are the best, glad you were able to set them up! You can also use dashboard settings to choose which card you want your filters to interact with. Just click change interaction to choose how the card interacts.

@jmmc I think Fixed Functions might be useful in your case. You can set it up to where only certain fields can be filtered.

@jmmc if you can't use the one drive connector (like me) you can also use a combo of Power Automate and the Email Connector. I set up Power Automate to read the file and send an attachment via email and then used the Domo Email Connector to bring it in.

This looks awesome, thanks for sharing!

@PJG if its not something that will be impacted by filters then you can add that specific beast mode as a formula in an ETL and then use that field in a beast mode. Formula tiles make it easier to reference actual columns and not just the code.

@PJG this may help

@louiswatson you can also try using the input dataset data handling section. Click on your input in an ETL and then select data Handling, you can choose data type Date and then click the settings icon for more details.

Using subtotals in a table will allow you to make it look like you are grouping your data, especially in a pivot table. You can also utilize Fixed functions to help you calculate amounts similar to a group by wihtout having to use an ETL.

Conrgats @trafalger! Welcome to the club 😎

@Pau you could try using an HTML table and creating a beast mode that adds in a bar for you like this. You might have to calculate the grand total using an ETL so that it gets its own row. Creating a BM might give you more options then a Flex Table. You could also create your own custom chart using a Domo Brick.

@Kristefor yes Observability metrics is perfect for this. I just started using it and its great! @jbandley if you don't have Observability metrics you can ask your CSM to turn it on. Its located under the toolkit section of admin settings. Here is some info on how to use it:

They would look like this. When you select an option in the card it will automatically add the filter bubble at the top.

@PJG always recommend using filter cards instead of the default filters at the top of a dashboard. You can create a card that acts as a filter which uses whatever field you set and then you can customize the name, sorting, coloring, etc. It really helps create a more user-friendly dashboard.

@domoexpert can you create a beasemode that determine if its the last month in the qtr and then filter for that? Something like this should work. Case when monthname in (March, June, Sept, Dec) then 'Last Month in Qtr' else 'Not Last Month in Qtr' end Then apply a fillter selecting Last Month in Qtr.

@colemenwilson thank you for these detailed instructions! I was just trying to do this the other day and it was giving me issues. I was missing the encoding part, I followed your steps and now it works!

In person is a must!! I would like to see more technical topics and deep dives into products and how to use them. Also more workshops not just show and tell. I would love to see more highlights of current features in Domo that don't get a ton of focus and are not widely known about: course builder, webforms, community,…

@RichardM I am not sure if you can hide the controls but you can remove any other filters on the bar and then set up a filter view which would save your current filters.

@RichardM Not card level filters but actual cards that are a filter type. You create a card that acts as a filter and then it can be used to filter all your cards. This helps you make the exact filters you want and you can even customize them to only work with certain cards. They have multiple date option ones as well. The…