BlueRooster Domo Employee

It sounds like Publication Groups may be what you're looking for. (A more detailed version of this would be Personalized Data Permissions). Publication Groups allow you to limit the data displayed to only rows where the specific user has access. Here's a link to a walkthrough on setting up a publication group.…

Unfortunately you can't search columns within a Sumo card at this time. However there is an active idea that you could upvote. Perhaps this will be added soon. https://dojo.domo.com/t5/Ideas-Exchange/SUMO-Search-filter-for-specific-column-name/idi-p/25422 Sincerely, Valiant

Your best best is to create an ETL that reads in that sheet and have it use the 'Set Column Type' option to conver the column in question to a text field. That should let you keep uploading the sheet as needed and have it always read that column as text. Then just replace any cards that were using this Excel sheet as a…

You'll need to edit your ETL process to add a column that provides the 'Total' for that metric and repeats it for each row. Example: Measure Total 1 10 4 10 5 10 Then at the card level you can do SUM(`Measure`) / MAX(`Total`) * 100 That will give the 'Percent of Total' you're looking for. Let me know if you have any other…

Give this a shot. I think I ran into this a while back and had to include a CASE WHEN just in case there was the opportunity for a divide by 0. `Retail`/ CASE WHEN COUNT(DISTINCT (CONCAT(`Patient`,'',`Patient Address`,'',`Patient City`,'',`Patient Phone`))) <> 0 THEN COUNT(DISTINCT (CONCAT(`Patient`,'',`Patient…

Yes you can. It applies a page filter at the underlying level that you can then set as the default. That way when a user comes to the page it has the defaulted year already selected, but they can edit the filter by clicking on the slicer card. (At least from my early beta testing, again things may change)

So this may get a lot easier once interaction filters are rolled out. Currently in beta, this not only allows for page filters to be applied by clicking on a specific part of a card (without having to drill into it), but it also includes the new Slicer card type. If you were able to tie the appropriate fiscal year to each…

Your exterior CASE WHEN has some syntax errors, but instead of trying to fix those, you might could try this: CASE WHEN `Sales Week` LIKE '%2018%' AND `Sell_out_value` IS NOT NULL THEN SUM(CASE WHEN TRIM(YEAR(`Date`))=YEAR(CURDATE()) then (`Sell_out_value`) else 0 End) / SUM(CASE WHEN…

I'm fairly certain you would need an ETL process to get that unless you want to use the Running Total Line chart type. Perhaps that will give you what you need? Hope that helps, Valiant **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post that helped you.

Ah gotcha. If that's the case, you'll need to calculate your rolling average via eithe an ETL or SQL transform. That's not something you can accomplish when only using BeastModes. Take a look at this post where they set up a rolling monthly average, you would obviously need to tweak the timeframe to 12 months instead of 1,…

Laurie, I'm seeing the same thing on my end in regards to the date formats. There doesn't seem to be a working native format option to return only the quarter. If that's the case, the only method would be to create a beastmode that returns the quarter # for your date range, something like: QUARTER(`date`) Then use that as…

When you're in the card analyzer, if you click the date dropdown in the top right, one of the options you have is Between. This allows you to set the start and end dates for your visual. As long as you have the 'Hide Date on Card Details' button unchecked, the end-user of the card will be allowed to adjust the timeframe to…

Can you provide an example of what data you have to work with? Column names, fake data? That should help one of us get you what you need. Sincerely, Valiant

Glad to hear it! We all need a 2nd pair of eyes on our code sometimes. 

I think you need to change your grouping. Try this: SELECT `NumProjects`, Last_Day(`Date`) AS 'Date', `PhaseName` FROM `pmat_historical_all_appended` GROUP BY `PhaseName`, Last_Day(`Date`) ORDER BY `Date` desc Does that give you the result you're looking for? Or you might could try: SELECT `NumProjects`, `Date`,…

ok, so in that case, you're going to need to create to do the following steps via either ETL or SQL transforms: 1. Sum your premiums by year SELECT `Year`, SUM(`Premium`) as 'PremiumTotal', `Year`-1 AS 'LastYear' FROM dataset GROUP BY `Year` 2. Add a 'Last Years Premiums' to your dataset SELECT a.*, b.`PremiumTotal` AS…

Ok, so while we could go down a long path of lots of sql transform and beast modes to get this answer, let's see if the simple solution works first. In your data, can you edit the data (either using an ETL or SQL transform) to convert each year (ie, 2013) to something like this (2013-01-01). The end result being that we…

The second statement is incorrect because of the WHERE clauses. Can you give me a few lines of example data using your available column names? That should help me better understand what you're working with and I can tailor my answer to suit. Sincerely, Valiant

In our org, all users are part of the Domo-All group. Would it be possible to share with that for you? Sincerely, Valiant

Can you give a bit more information around the end result you're looking for? What are you looking to do when you mentioned "Sum or Count" your visit types and what do you want returned in your Total Line? From my initial reaction I would suggest doing your classification into Types ahead of time in a SQL transform. (Do a…

I built a walkthrough for something similar on another post. Check out this link: https://dojo.domo.com/t5/Card-Building/Re-Period-over-Period-using-stacked-bars/m-p/30479#M3655 Obviously instead of doing one by month, you'll need to tweak it to show years if thats what you're wanting. For your % change calculation…

Is the existing visualization already using an Excel data source? If so, you can just go into that datasource, click on the Settings tab and then reselect your updated datasheet. Otherwise workbench is a good option, especially if you're going to be doing this fairly often. Let me know if you have any questions, Valiant

Case When `ACTUAL_START_DATE` is null then 'Tracking' WHEN 'ACTUAL_START_DATE' is not null and `ACTUAL_END_DATE` is null then 'In Process' else 'Completed' End Just change elseif to WHEN instead That should work for you, Valiant

Glad it worked for you. Here you go: var res = httprequest.post('https://us3.api.samsara.com/v1/fleet/drivers?access_token=xxxxxx','{\"groupId\": ssss}'); //DOMO.log('res: ' + res); //added .drivers to read further into the JSON file before parsing var data = JSON.parse(res).drivers; datagrid.addColumn('id',…

delete the .features from the parse

You're very close. It's helpful to use the Domo.log to see what part of the array you're accessing when reading the JSON file. Here's a quick tweak: var res = httprequest.post('https://us3.api.samsara.com/v1/fleet/drivers?access_token=xxxxxx','{\"groupId\": ssss}'); //DOMO.log('res: ' + res); //added .drivers to read…

Some of this will depend on how you have your data setup (mainly whether you have already have a YTD column totaling your actuals and forecast through each month) If you don't have that, you'll need to add those two columns ahead of time. So your data may look like this: Once you have that, youll put your Month column as…

Do you have a preference on chart type? Ie, 2 bars for Monthly, 2 lines for YTD using a Bar + Line graph?

Could you provide a bit more information about the chart(s) you're wanting? Currently I'm assuming you want to show Monthly Actuals vs Monthly Forecast and YTD Actuals vs YTD Forecast. Are you wanting that combined somehow in 1 chart or are you looking instead for 2 separate charts? Sincerely, Valiant

Normally when doing something like this, I would use a SQL Transform. Here's what that might look like: SELECT a.*, (SELECT SUM(`Price`) FROM dataset AS b WHERE b.`Customer` = a.`Customer` AND b.`Month` >= a.`Start Month` AND b.`Month` <= DATE_ADD(a.`Start Month`, INTERVAL 2 MONTH) ORDER BY SUM(`Price`) DESC LIMIT 1) AS…