ST_Superman Domo Employee

I think that you have a misplaced parenthesis in your equation. Try this instead: (SUM((CASE WHEN (`Segment Name` = 'Conversion Activities - Overall') THEN `Unique Visitors` END ))) / (SUM((CASE WHEN (`Segment Name` = 'Overall') THEN `Unique Visitors` END )))

Yes,

Sure, Here are the two options you asked about. The macro for the Data label settings goes in the text field and you have to type it in all caps %_VALUE ... not %_value or %_Value How to Abbreviate the data labels Data Label Macro %_VALUE

You could create a Symbol and Grouped Bar. One key thing here is to apply the General Chart property "Sync Zero Lines". Otherwise the accounts negative numbers can still look like a positive growth if you aren't paying attention to the scales. You will also want to use the "%_VALUE" macro in the Data Label Settings. An…

I haven't played a whole lot with quick filters yet, but did you try sorting the data by your date field first? It may just be pulling in each weekday name as it encounters them in your data set.

Can you provide some more information about what you are looking for? Are you wanting to build a separate dashboard for specific users, or just a general dashboard, customized with your content? The way that Domo creates "dashboards" is by creating pages. On the far right of the screen you will see the Manage pages button.…

You should be able to accomplish this with a beast mode calculation: You will need to make a separate calculation for each type. Type A: sum(case when `Type` = 'Type A' then `Count` end) / sum(`Count`) Type B: sum(case when `Type` = 'Type B' then `Count` end) / sum(`Count`) Type C: sum(case when `Type` = 'Type C' then…

Yes and No. The filters are saved to the page, but not the specific selections that you made for the filters. Here is an example: The filters for 'Product Family' and 'Account Name' are saved to this page. If I filter the page for a specific Account name and click Save Filters, Domo will save those filters for my view of…

I agree with @PodiumMason. I would just add that you can do quite a bit with Domo without any real programming language using the Magic ETL blends. There are limitations to what you can do with these blends, but they can be a great place to get started if you are not comfortable with MySQL yet.

I did hear back from Domo support on my issue. My issue was that the data set being used in the drill path had not been shared with my users. I had incorrectly assumed that when I shared the card, all data sets in the card / drill path would get shared as well. As a work around, I simply created a card using the unshared…

I believe you need to use the library(DomoR) and then the command would be > DomoR::create(...)

I'm getting the same message. Have you contacted DOMO support?

I think you might be right... did you try saving the card so that it renders the code? Try that with your original code that you posted case when sum(`YTD Actual`) > 0 then CONCAT('<div style="position:relative;"><img src="https://mitel.domo.com/page/1441105090/kpis/details/251281079" style="width:40px;height:40px;"\><span…

I would try something like this then: case when sum(`YTD Actual`) > 0 then CONCAT('↑ ',round(sum(`YTD Actual`*100),1),'%') when sum(`YTD Actual`) < 0 then CONCAT('↓ ',round(sum(`YTD Actual`*100),1),'%') end <<I used (alt24) for the up arrow and (alt 25) for the down>> You could also use alt 30 ▲ and alt 31 ▼

@sgraham are you wanting this in a table? or in the summary field? I don't believe that the summary field supports html coding. which means that you will need to use an alt code character for any symbols. You won't be able to add graphics or web images. I believe that @evanbench was using a table in his example.

Sure you can, you would just have to write it into the case statement. case when ..... >0 then '↑' when .... <0 then '↓' This was actually in @scherbelr 's original code: concat('$',round(SUM(Case when (`Contracts__r.Date__c`<= curdate() and `Contracts__r.Status__c` = 'Accepted' and `Account.Account_Status__c` = 'Active')…

I believe that an alt code was used. You can use ↑ (alt 24) or ↓ (alt 25) in your concat statement.

Thanks for the info. I will look forward to the upcoming release then.

That's a good point. The two query tables were pulled in within 5 minutes of each other, and are looking at sales data from last year, so the data did not change. Each table has the same number of rows. Both pivot tables are using the entire data set to summarize the sales data.

Maybe I should provide some more info to clarify. I have a table that lists Sales Reps, Customer Accounts, Dates of Invoices, Sale Amounts, etc. I would like to only allow the users to drill down to the next level by clicking on the Sales Rep. The drill down card that I want to lead them to will only make sense if filtered…