ST_Superman Domo Employee

 

I'll try to work on this tomorrow. Can I get an idea of how many Items are in your data set? Are you also forecasting for multiple locations?

Do you have access to Redshift? Or does it need to be a MySQL dataflow?

Wow, I'm really sorry that you have had this experience. That has not been my experience with the Domo support team. I'm not sure why they haven't addressed this issue for you yet. Do you have a Customer Success Manager to contact from Domo? Also, have you checked your customer support portal to make sure they haven't…

I did find a knowledge article on this. It looks like you can use some Domo APIs to pull data between different Domo instances. It's listed as a paid service in the knowledge article

I would contact your CSM from Domo. If this is possible, I'm guessing it would be something that Domo would have to wire up from their end. Has anyone else done this before? Let me know how it goes if you are successful, would be interested to know if this was possible.

Can you provide some more details here? I believe that is the default way that the summary number works, it should be updating as you apply filters to the card.

Are you looking for a table card? If so you can accomplish something similar by using subtotals:

My first question would be do the datasets share the fields that you want to filter out? If so, there is an option when you select a page filter to apply it to all datasets on the page. If you have access to the dashboard layouts and interactive filters betas, then you can accomplish this with some of the filter card…

I'm not aware of a way to extend the length of the labels. Have you considered shortening the names, or using a category / sub category approach? Where your first view might display the "Site", "External", etc. level of detail, which you could then drill into to provide the greater detail. That might be a worthwhile Idea…

Just from a best practices approach, I would recommend moving the `Status` beast mode into the data set. The advantage to placing any sort of "Classification" calculations directly into the data set is that you can then use that field in page filters as well as other beast modes. The Status calculation here is simply…

You mentioned that your sample data was only showing one month. Does that mean that your actual card typically shows multiple months? In which case, the beast mode that @Valiant suggested will be calculating the % expired over the entire time period that you have selected. If you only want to show one month's expired…

You can use HTML code in table cards to create images. case when `Web Domain` = '....' then concat('<div style="text-align:center"><img alt="DOWN" height="20px" src="URL of image">','</div>') when `Web Domain` = '....' then etc.

You could also do concat(round((`Month 1` / `Month 2`)*100,1),'%') replace `Month 1` / `Month 2` with the actual calculation. but that would give you something like this for the format 33.3% or 75.0% It would be a text field though, so you couldn't do any more calculations with it.

@John-Peddle - I think it would be easiest if I could get a few rows of sample data. There is a problem with changing the output from a value to a text string. Domo needs to set a value type for each field. If you were to write a case statement like: case when `A` - `B` = 0 then 'NaN' else `A` - `B` end then the beastmode…

If that works, then you can just add similar logic to the variance beast mode. If not, it would be helpful to see some sample data to better understand what your data set looks like. To answer your questions about performance... In my experience, adding these kinds of calculations to a dataflow has minimal impact on…

I believe that the reason the beastmode is not calculating is because there was either an error in the calculation (divide by 0) or the case statement was not fulfilled (in this case, is it possible for a record not have a `Has Discrepancy` value?) You may want to try something like this to make sure that the case…

You can also upvote this idea: https://dojo.domo.com/t5/Ideas-Exchange/Dojo-Forum-for-Beta-Testing/idi-p/35632

Hi @user02072 If you want this data in Domo, my suggestion would be to find a way to get the data set to a flat file. A flat file is going to be harder to analyze, but much easier to use in a relational database. You want the data to look something like this: You can then add a few case statments in a MySQL select…

I might try something like this: CASE WHEN SUM(`Engagement Points`)=0 then 0 ELSE SUM(CASE WHEN `Activity Quarter` = '2019Q1' THEN `Engagement Points` ELSE 0 END) / SUM(`Engagement Points`) END The additions that I made should just help clean up any sloppy data. The outer case statement prevents the beastmode from dividing…

I'll add one thing to @Valiant's remarks. The field that you are wanting to use as a filter has to be on the data set, and not a beastmode. This is true for page filters as well as interactive filters.

I'm assuming that your data set has a date field in it. You could add some transforms in your dataflow that would call out the most recent change per employee. Then you could add that field to your beastmode.

What does your data set look like? This is essentially a pivot table. In order to perform these calculations, you will need to have a "flat" data file. In addition, Domo does not have a great way to present a pivot table like this. I would argue that there could be much more intuitive ways to present this data. When…

I tried to step through this logic in an ETL for you. I think that some of this is more complicated in ETL vs MySQL, but here goes. There are four main steps. Step 1: Assign a value for the date you want to compare to. In your case, you mentioned 30 days prior and 1 day prior. In ETL I used the "Date Operations Tile" to…

I try to avoid nesting case statements if I can. Have you tried something like this instead? CASE WHEN `Marketing Channel` = '1. Event' AND `Primary Campaign`='TS-2018 HIMSS' THEN 'HIMSS' WHEN `Marketing Channel` = '1. Event' AND `Primary Campaign`='TS-2018 MGMA' THEN 'MGMA' ... etc.

I am unaware of a way to do this. You can schedule the data to get pulled into Domo every hour, or even every 15 minutes I believe. Most of our data from salesforce then goes through a dataflow or two before it is ready to be analyzed which means that even if we pull every hour, the data is not updated on the cards until…

The layout frame is a set size because that will be a full page (or slide) when you export the dashboard as a PDF (or power point). I would encourage you to look for a visualization to add or additional metrics that could add more context to the three cards you already have. There is a bit of a learning curve to filling…

If you put your mouse between two cards, you can click and drag to resize:

I would like to add the option to remove the PDP logo as well on these dashboard layouts.

The only way that I know to do this is to create a table card.