Comments
-
@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…
-
Done!
-
@RichardM are you using filter cards or the default filters at the top of the page? I usually try to use filter cards which bring my users attention there instead of the default filter menu.
-
@domoexpert sorry for the late response! It def sounds like it could be something buggy, I would double check notification settings and maybe set up another alert to see if that one gets triggered.
-
what was your alert criteria?
-
Since they are all their own beast mode that is why the drill won't work since you are trying to drill on a calculation. Try doing the mega table like Mark mentioned or using a Pivot table, the pivot table won't have the heatmap options though but you might be able to use color rules.
-
Is each one of those columns a different beast mode ?
-
What chart type are you using?
-
@derekok what does your top card look like? Sometimes it depends how the card is built or what the user clicks on which could prevent it from giving the desired outcome. If you have a BM for each calculation then it won't let you drill. Can you show a picture of what analyzer looks like for your top card?
-
You may also be able to select your date field and do a unique count or maximum and have it alert you on that
-
For me it shows up at the top
-
Are you trying to set up the alert on the card or on the dataset?
-
You can also set a dataset alert that tells you when a new row is added. Just select whatever options make your rows unique in the last section.