Comments
-
@jtrollinger does either of your cards have anything in the sort option? Sometimes that can mess with stuff. Also, check if your 2.84 card is filtering by anything else directly in analyzer.
-
Pivot tables also have border options and you would be able to create sub headings by putting different fields in the Columns sections.
-
@ArborRose I have not seen this with HTML tables but another table chart type in Analyzer called Mega table just got a border feature.
-
@SayyedHussain there is a Domostats dataset called Dataset Access that will give you the dataset ID and User ID along with what level of access they have (can edit, can share, etc.). You can combine that with some of the other Domostats datasets to get username and dataset name for a full look at dataset access.
-
@nathankilcrease yes, I was able to add the custom fields but for some reason none of the data is populating for the items of my new property ID. I set up a new GA4 connector and its bringing in data for my non GA4 properties.
-
@ColinHaze I think you either need the Create DomoApps or Use AppDB grant to edit a Domo Brick.
-
@Victoria_G1 I find that if someone put a space or nextline in the source data it may cause it to come through Domo as blank and not null. You can try to do a squash space in your formula and then a case statement that looks for both nulls and single spaces and replaces them with text like: case when COLUMN is null then…
-
@Charlie Bantoft here is more detail on how to do Fixed Functions. I find fixed functions allow for more flexibility then an ETL, especially if you want to do filtering on other fields.
-
@leaflove if you don't want to create a new field you could also do the same thing in your ETL. Using the formula tile just do ifnull(`Brand`, 'Blank') and then you can filter on Blank.
-
An alternative would be to incorporate a line to represent your goal that way you don't need as many bars. I do something similar for the same concept. I made an example in the community Domo instance that looks like this. I think having either the prior year or the goal as the line would make sense to the user and then…
-
@chelsea_ringl Grouped and Stacked bar comes to mind for me but you may need to change some of the settings for it. I think there is a way to customize how many bars you stack so you can have it only stack 2 and then the rest would not be stacked. You may need to do custom sorting so it appears in the right order and…
-
@D_Markley34 ah that makes more sense, this sounds like it would be a perfect use case for Column Masking once that becomes available.
-
@ColinHaze You could use Workbench if the file is stored locally on your network. I believe you need to have admin rights to be able to download Workbench. If you use SharePoint you could also use that to automatically get the files. You may also be able to use some scripting with the Java CLI to do this as well. I think…
-
@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.