ST_Superman Domo Employee

You could try this: (COUNT(DISTINCT case when `useractivity_status` = 'Active User' then `usersid` else 'Inactive User' end)-1)/ (COUNT(DISTINCT `usersid`) over ())

My first thought is to perform the percent calculation in the dataflow. However, then the calculation will not change with any filters applied to the card.

I think this has more to do with the dataset. My guess is that if you look at the events that 'occurredat' the time frame you are graphing, you will find that the users that performed actions in that time are all still active users. You need to identify a way to identify the users that don't have activities

(COUNT(DISTINCT case when `useractivity_status` = 'Active User' then `usersid` else 'not active' end)-1)/COUNT(DISTINCT `usersid`) You could try something like this. The issue might be that the case statement has no where to go if the status is not "Active User"

Can you share the rest of the settings for that chart?

You can use the Chart Properties "Data Label Settings" to accomplish this:

@Cartergan is correct. You need to provide some aggregation in the beastmode for it to be available as a summary number. CONCAT(sum(`Total_Sales`),' Total Sales and',sum(`Total_ROs`),' Total ROs for all')

There is a "Mega Table" card beta that would solve this issue for you. If you are a part of the beta program, send Chuck Irwin (@chucki) an email to be included in the mega table beta. I believe that these mega tables will eventually just replace the regular table cards, but I'm not sure about the timetable.

I'm not sure if the picture that you shared is the table you are using this metric in, but if it is then the issue is with how you have built the table card. You need to remove the `useractivity_status` field from the table. As it is built now, the beastmode is being given a list of all 'Active User's first, of which 100%…

I agree that a vertical line would be helpful. You can also use background colors, or change the color scheme between the two graphs to help seperate the visuals.

You should be able to use a Line and Grouped Bar chart here. As for the how, that really depends on the structure of your dataset. Would you mind sharing a sample of your dataset? Feel free to change any values you need to, as long as the schema stays the same as what you are working with, we should be able to produce your…

I have also noticed that Domo cards will behave strangely when using generic field names like YEAR or WEEK, etc. You may want to try renaming your field to `Year of Survey` or `Survey Year`

You can create a calculated field and use that as a summary number; SUM(`Amount`) / COUNT(DISTINCT CONCAT(`Account Name`,' ',`Close Date`))

At first glance I thought this was pretty straightforward. Then I started writing my solution and realized an issue. For today and yesterday you can just write a calculated field statement like this: case when `date_field`=curdate() then 'today' when `date_field`=curdate()-1 then 'yesterday' end however, the issue I…

If that doesn't work, you can try to alter your beastmode a bit: COUNT(DISTINCT CASE WHEN `weekoffiscalperiod`='1' THEN CONCAT (`DataSourceDB`,'_',`phoneid`,'_',`actionid`,'_',`reason`,'_',`date1`) END)

Change the aggregate for each value in the chart to SUM or MAX

I have two thoughts here. 1. Does the `Event_OccuredAt` field exist in dataset B? Even though it is not being used in a card, if the field exists, then it will filter for those values. 2. When you are editing the dashboard, you can set the interaction to only filter certain cards. Try only allowing the date filter card to…

We pull the Opportunity data as one dataset and the ISO Codes and Conversion Rates (from our Salesforce instance) in another data set. We then use a dataflow to recreate the Amount (Converted) field. I don't know why Salesforce does not expose certain APIs, but this along with Current Stage Age are to fields that we had to…

Hi Helen, Thanks for the questions. I'll answer your first question as best as I can, but I am actually not all that good with dynamic SQL. Everytime that I have had to write a dynamic SQL query, I have just modified an example that I stole from someone else online. I don't recall the website now, but it had to do with…

I'll take a stab at this one... I think I would try this in three transforms. Then I would join these two fields to the rest of your data by joining on the lead id Step 1: Ensure that you only have one date for each of the three fields per Lead Id SELECT `Lead Id` ,max(`Created Date`) as `Created Date` ,max(`Converted…

Three settings come to mind here. * Allow text to wrap * Set Column Widths This is a percentage of the screen real estate. For example, if you have 4 columns, but you set this to "20,50,30" then there won't be any room for the 4th column. If you set it to "20,30,30" then the remaining 20% would be evenly split between the…

When you add the artwork to Domo as a .svg file, you are using that artwork as a custom map that then has a dataset applied and mapped to it. You may want to try adding a map widget with your AI plugin and then see if you can alter the layers to change the artwork from the map image to your custom image. Not sure if this…

Good news and bad news for you @helenh There is a solution to this problem. However, you are going to have to use some MySQL to do it. I will show you how to set it up. I am just going to bring in the header of the first cell into a column. Then you can put this dataset into and ETL and make any changes you need to. I had…

This is another case where it might be best to understande the question being asked rather than just the report being requested. If you need to have the data displayed in a pivot table as you posted, then I do think you will need to make the calculations in a dataflow environment before building your card. However, have…

This seems like either a bug, or a design choice. If it's a design choice, then there should definitely be an option to include all labels as well. @DaniBoy could you try to get this feedback in front of the right team at Domo?

Hi @AvinashK It's a little difficult to provide clear guidance here because I am not sure what your dataset looks like. But I believe that you can accomplish this by creating a calculated field (also known as 'beast mode'). `Segment B Field` / `Segment A Field`

When you drop the beastmode in the y-axis (the one that gave you 1 as a result) can you confirm that you have the format set correctly? The default is for it to be a number with no decimals so .95 would be rounded up to 1 Another question I would have is can `draw id` be null? Also, if `successful/unsuccessful` is null, do…

How many days of data do you need to be able to compare to? There are a few approaches here. Do you always want to look at a set group of dates to compare to? For example, you always want to compare the value from one snapshot date with the previous date, with the value from 30 days ago, the value from 90 days ago, and the…

The issue with this beast mode is that you are trying to aggregate the data while also not aggregating the data. Let me try to explain... If you have a list of scores and names: Clark Kent = 100 Bruce Wayne = 98 Peter Parker = 97 Bruce Banner = 85 Berry Allen = 92 **bleep** Grayson = 81 Tony Stark = 94 Steve Rogers = 89…

This sounds more like a bug. Have you contacted Domo support? support@domo.com In the meantime, would you mind sharing what your analyzer settings look like for the card? Might help to identify what is going on.