Cartergan Contributor

You may be able to do a Beast Mode to help with this. Something like: CASE WHEN ID is NULL THEN 'Unused' ELSE 'Used' END

I tried playing around with this for a while and was unfortunatley unable to find a solution. I'll be following this post in case someone does know a solution since I'd love to use this as well. 

I apoligze, I misunderstood. Is this a filter card for a whole page? 

Good morning! To do this you will want to put your Fiscal Year column into the filter portion on the analyzer screen and select the option to display as quick filter: This should create a new view in the analyzer for the quick filter. In this section you will want to select the filters you want to card to be defaulted to…

I met with one of our account reps. from Domo and he was able to provide me with a list of cards and their last view date as well as some other metrics he was able to pull from the backend Domo side. It may be benficial to reach out to yours and see if they can provide you with a similar list!

You should be able to select the date range that is displayed through the card analyzer You can then add the date as a filter and have it display as a quick filter so that users can enter specific dates:

You could do BeastMode calculations right on the card you are building. One idea coming to mind would be doing some sort of CASE statement to make a new value: CASE WHEN Country IN (whatever specifications you'd like) THEN 1 WHEN Country IN (second specifiations) THEN 2 etc... This way would allow you to group certain…

I may be mistaken, but based on the columns present in your dataset, the BeastMode calculation is using 'New + Reactivated Users' rather than 'New Users' + 'Reactivated Users'. I haven't yet given this a try but I will play around with it now to see if this syntax was the issue or if it's the calculation. Reagrds

Good morning, Would you be able to post a screenshot?

Good morning, After playing around with the Domo Stats data sets I unfortunatley was unable to find any sort of indication to wether or not they have an inactive license. The only thing I could think of at this point is to calculate based on the last day they logged in and if it is after a certain threshold to flag that…

These are great! This definitely gives me a few more ideas. Thank you! 

Thank you! This is exactly what I needed. 

Yes. Since dataset2 has the individual breakdown of employee expenses you can use that dataset for both cards (meaning you'd have to remake one of the cards). On the new CardA, you can sum the individual expenses to show a total amount, and then for the drill down have it show the indivdual amounts. 

You need to create a new CardA using the second dataset, then drill down using the same dataset basically mirroring the previous two cards. There is no other alternative if you do not have access to the datasets or cards.. 

One thought I have is using Dataset 2 as the dataset for both cards. With Card A youo can list the employees and maybe sum their expesnses to show their total YTD. Then for the drill down, using the same dataset, you can show the breakdown of the expenses. Let me know if this would work for what you are trying to…

That's just the answer I was looking for!! Thank you for your help. 

I just came across a way that should be able to solve your problem. Instead of creating the dataflow with the ETL feature, use the SQL feature. Once here, you will choose the same dataset as the input dataset. However, for one of the transforms you will sum the profit column. I attached an image to show what this might…

If you want total revenue (not per customer) you need a new column that takes a sum of all of the revenues and sums them together for one value for the entire column. You can use this against the individual revenues. I feel I am starting to repeat myself now so there is not much more help I can offer. Best of luck. 

That is the number you just calculated on the dataset with the ETL process. 

The first part is perfect. This will give us a column we can use for each individual value/calculation. The next part would be done in the BeastMode section of the card analyzer. You would add a new calculation to give you the % of revenue by each customer. After this, the calculation will show up as a datapoints on the…

In that case, yes, you would do the first calculation on the DataFlow. Doing it there will create a new column in general (it will be the same number the whole column). Once you have this column, you can do a BeastMode calculation on a card to calculate the individual revnue % by each customer. If need be, I can post some…

I am thinking one way you could do this is add a column in which you assign a calculation to be the values. Ex. SELECT SUM(Individual Revenues) AS Total Revenue This would give you a column with total revenue as a number, you could then do one more column in which the calculation would be like [Individual Revenues] /…

Have you tried without formatting the call_date? CASE WHEN 'call_date' = CURDATE() THEN 'Today' WHEN 'call_date' = CURDATE()-1 THEN 'Yesterday' END

Try: SELECT DATEADD(DAY, (DATEDIFF(DAY, 3, DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0)) / 7) * 7 + 14, 1)

I could be mistaken here but I beleive the CURDATE() format is in YYMMDD so it may be erroring out due to the formats not matching. Let me know if this fixes anything!

Are you able to make it work with a Beast Mode CASE WHEN statement? Such as: CASE WHEN user_ip_access BETWEEN ******** and ********** THEN (correlated country) ELSE Country END

Unfortunatley, it seems as though color rules are disabled for flex tables so at the moment this is something that is out of reach. If you find a workaround or a sutible solution I would love to know! Regards

In terms of pivot tables the only thing I found that worked well was a sumo card. It gives you the open to create pivot tables and move around what you want to pivot. I'm not sure if this is what you're looking for, but when I ran into something similar this card helped me achieve what I needed! Let me know if you find…

I too am currently working on a project involving creating a card with info from scraped websites. I do not believe Domo has the capability to do this since it requires some scripting, but I do have some good resources/code I've been working on for basic scraping if you run into any issues! 

Good morning! I am not sure if this will acheive what you are hoping for, but it may after playing around with it a little. In the analyzer under Chart Properties -> Hover Text Settings, you are able to add a value into there. It won't show at the top of the bars but when you hover over each respective area it may will…