GrantSmith Coach

Ah, so your data isn't a percentage but an actual number. Have you tried using a beast mode to calculate your percentage and use that as your value? Your target would need to be a percentage value as well so they're on the same scale. I don't know the fields you're using but a simple beast mode like the following should…

Hi @Hedger Have you tried formatting your column as a percentage in the Filled Gauge card column properties?

That should be correct.

Hi @Canioagain Im not a Salesforce user but on other systems sometimes I can export a report from the system to get the historical data and then combine it with the data from the connector using an ETL or view. It depends on the Salesforce platform if they even keep historical records of opportunities. Based on what I’ve…

@Jessica When I create a dataset I'll make sure to add some tags on the dataset denoting the workbench server so I know which workbench server specifically this data came from. It's an extra step and I haven't found an easy way to automated it yet but it's been tremendously helpful to make sure we can track down the source…

Hey @MarkSnodgrass , that's a great article! 🤪 @jordan_platinum Have you tried using a trellis option on your bar chart? https://domohelp.domo.com/hc/en-us/articles/360043428713-Applying-DataSet-Columns-to-Your-Chart#6.

It would be great for both types of tokens - API Tokens (Admin -> Access Tokens) and Developer Client ID and Secrets (developer.domo.com).

Hi @Stefan Since you're wanting to aggregate an aggregate you won't be able to do it directly in a card. I'd recommend using a Magic ETL dataflow to do your grouping based on the `User ID` field and count how many records you specifically have for each user. Then you can use the new activity count field as your series and…

@WorldWarHulk The code I provided should have a Filter -> Group By -> Filter and it should automatically have the code pre-filled out. Do you see it elsewhere in your ETL canvas? I'm guessing because the dataflow I copied it from is quite large it might be off your screen and you'll need to scroll down. Alternatively I've…

I'm glad you got it figured out! I was going to suggest programmatically calculating the number of months to divide by depending on the current year and month (untested - back of napkin): (CASE When YEAR(`EOMDate`) = YEAR(CURRENT_DATE) Then SUM(`TermCount`)/ ((SUM(`ActiveCount`))/MONTH(CURRENT_DATE)) When YEAR(`EOMDate`)…

Hi @user048760 You can do this with a beast mode to cause 0 values to return NULL / nothing: CASE WHEN `Rsvn` <> 0 THEN `Rsvn` END

You can use a group by with the COUNT aggregation to count how many records matches compared to the number of records in your original dataset then use a formula to do total - count to get the difference / records which don't match.

You can use an ETL with both datasets as an input and then left join them together based on your columns and see which ones are are missing values, that will identify where your records don't exactly line up.

You could attempt to use a magic Etl and the pivot tile to process your data into the pivot format you’re wanting and then use a standard table to display that information.

Hi @trevrobwhite It sounds like you're needing to do some custom processing and handle JWT tokens so the JSON Connector won't really solve your problems. You'll likely need to write a custom connector to communicate with your API endpoint. This does have the ability to generate JWT tokens, you'd just need to write the code…

Hi @Emma You need to check for your denominator to be zero, not your numerator. Try this (will return 0 if `Conservative Max Qty per plt` is 0) CASE WHEN `Conservative Max Qty per plt` = 0 THEN 0 ELSE `Total Stock`/`Conservative Max Qty per plt` END

Right however I’m lazy and want even fewer keystrokes :)

@RichYute You can use the Open Exchange Connector to automatically pull the conversion rates so you won't have to make any manual changes. You can join your currency rates dataset with your dataset amount and then use the formula tile to multiple the Eruos by the conversion rate. It'll look something like this: I'm adding…

@Emma Try this: CASE WHEN `Plant`=1302 AND `Line of Business`='Cable' THEN 'QC Fibre' END

Hi @RichYute You can use a formula tile to multiple your Euros by your conversion rate to get USD. I'd recommend having a lookup table with your conversion rates in it so it's easier to update where you can join your currency and filter to what you're converting to. I'm not certain there's a specific Domo Connector which…

@User_32265 If you're simply wanting to do a translation stating they're authenticated you can use a Beast Mode on a card or a Formula Tile in a new Magic ETL dataflow to define a new column. I'm not certain what you logic would be to determine if they're "Pre-Authenticated" but assuming the user ID is populated means…

That’s it.

If you’re technical you could export your data from Domo and build your own excel spreadsheet using pydomo and a Python script. R might also be an option.

You'll need to talk with your CSM to get Window Functions turned on as it's a feature switch they need to do.

@DANIH Do you have some sample anonymized data I could play with?

I'd recommend reaching out to your CSM/Support in this case as this is a Domo architecture question at this point and they'd potentially have a better answer for you.

@nshively I'm not certain what all information you need displayed on your card but you could utilize the LAG window function assuming you don't have any missing months: Average Head Count (Beast Mode) ( SUM(SUM(`EmployeeCount`)) OVER (PARTITION BY `EOMDate`) + LAG(SUM(`EmployeeCount`), 1) OVER (ORDER BY `EOMDate`)) / 2

Unless you know each of those events are for the same user you won’t be able to tie different sessions together because each visitor to your website will get a new session ID if they haven’t visited your site within 30 minutes or whatever you have your Google analytics configured to. I am not certain if you can use googles…

I'd recommend using a custom date dimension with offsets so you can easily have this month and last month together based on your current month. I've done a more detailed writeup on it here: A more flexible way to do Period over Period comparisons You may need to tweak it if your data is on a monthly cadence instead of…

Hi @DANIH Have you tried a window function with a case statement since you're attempting to only look at data from today? Last Year: SUM(SUM(CASE WHEN DATE(`Timestamp`) = CURRENT_DATE - INTERVAL '1' YEAR THEN `Net Sales` END)) OVER (PARTITION BY HOUR(`Timestamp`)) Last Year (With day of week aligned) SUM(SUM(CASE WHEN…