ArborRose Coach

I have suggested this as a serious need. Your wording is much better than mine. :)

If you are trying to graph or count occurrences in a dynamic way. I would suggest something like this… Say you create two calculated fields: field_1 and field_2. Field one representing the abbreviation (ie WBH). Field two being the name of the thing (ie. Wabash). Field_1: SPLIT_PART(Campaign, ' ', 1) Field_2:…

I think you are trying to do too much in one column. I would break those out into separate columns so you can see the information in a table display across all companies. Then filter or group by. Lead_Count: CASE WHEN Status='Unqualified' THEN COUNT(Lead ID) END Lead_Total: CASE WHEN Status='Unqualified' THEN SUM({amount})…

And yet, this ideas exchange post shows up in the list as if it is an unanswered question.

https://community-forums.domo.com/main/discussion/comment/63979#Comment_63979 I am the original poster of this question but I don't see it on any of the responses.

@RobSomers - That's what I expected (for it to be under the responders post). But, as in this case….I don't see that anywhere other than your comment suggesting it should be there.

@Zel. You don't need to force your current column to date. If your data is in datetime, create a new field for the report using date() but keep your original so it is maintained for your recordkeeping.

@RobSomers - There's no intuitive button appearing for accept an answer. You have answered my question and I see links for Flag, Quote, Insightful, Agree, Like, Awesome, and LOL. Where is the accept answer link?

Without seeing a dataset or column values, I have to generalize and create some fake data. Let's say I have two tables represented here by webforms. The one one the left contains headers or something representing the titles or bigger things. The right being the detailed raw data. If I am joining the data, there needs to be…

I haven't been using the ODBC driver myself. “Transaction was deadlocked” happen when 2 or more sessions are trying to lock a resource which has already locked by another session. The sessions cannot complete and SQL Server has to intervene. It gets rid of the deadlock by choosing one of the sessions as a victim and kills…

There is no need for pivot tables. Assume you have a webform (in your case the incoming dataset gathered from the alarm system software). You would just put those fields on the card as healthcare name, alarm received, and count(alarm received). Then add sorting and format your labels. And the final result would be a list…

The way I did it in SQL, it doesn't matter how many commas there are. In ETL, I'd have to create something recusive to make sure you can get any number of elements typed into a string. If you know you won't exceed the number of delimited items you show, something like this will work. Using that flow, I then went out and…

As @MichelleH mentions, in the ETL I'd be looking to use split to get the pieces from the string. I don't have a chance right now to try it in Domo, but I did a quick mock up in SQL with code shown below. As I mentioned, I would split the strings to create a table as shown below. Then aggregate the table using count to get…

I'd need to ponder a bit. First instinct - try to break up the string by the delimiter, in this case a comma. Feed the pieces to a table (aka a list) and then aggregate using count.

I had the same issue and was told we can't remove nor customize the information. You might try saving the dashboard to a powerpoint where you can remove that part and then send.

I believe damen is correct and qualifies for this badge. It appears that the comment came after Dani became a deleted user. Who at Domo assigns the Domo admin badge to those of us who admin our Domo domain?

Seems like you would have gotten D and E. Can you change the “What happens when column types don't match?” to show type errors and see if it gives any indication?

I don't believe this can be done without a change to the Domo chart code. It's the way the period over period is coded. The value you circled in green is also the value represented in the area circled in red. Filtering it from one also removes it from the other.

I think excluding 0 and 12 would just remove it from the bars, not the lines. He's probably got a range set for 1 through 12 to prevent 2023-Mar from showing.

As Michelle mentioned with the case statement, I was thinking you would need to do something like that for both the current year and the previous year. So when any year/month falls into the scope of your chart, there would be an on/off bit preventing both from showing.

Have you tried period over period chart type? Select your date range and how you want it graphed (by week, month, qtr, etc). And then select compare to 1 year ago.

I had not tested with Powerpoint. After responding to Jessica's comment, I created a new image card using the code I pasted in this conversation. It worked. I re-tested export as PDF and it worked as well. Then I saw that I still had the original profile image card so I put it back onto the original dashboard..and it also…

Thanks for the comment. I have since removed the photo from the dashboard. Our need was for pdf or graphic output, not Powerpoint. My guess is that if it failed to export on PDF, it would probably fail on PowerPoint as well.

Is it possible the source material/data changed? For example, if you have a pdf with an image referenced via a URL, the source in that url may have changed.

Can you parse the values using a CASE statement? Something like the following would create three columns: date, model, serial number containing the values found in the data. CASE WHEN Label='Date' then value as 'Date' WHEN Label='Model' then value as 'Model' WHEN Label='Serial' then value as 'Serial' END

I think we'd need a bit more information to help with the question. I use workbench from importing Excel files. You can select the worksheet and add transformations to perform the type of filtering mentioned.

Sounds like a conflicting thought. The Domo role for admin is described as having full access to everything. So the answer would be “no”.

The select limit was just a test command to identify whether it could see beyond 500k rows. The process I need to create is much more complex.

Thank you MichelleH. The entire data flow was an input table (12 million rows) and a single SELECT where id=XXXX with a limit of 5. I tried a second time to do the output without the limit but for a single person's records and it ran for 25 minutes before I cancelled. That output would have been less than a hundred rows.

Sounds like you are exporting from the dataset rather than viewing it on a card/dashboard. As @MichelleH points out, when you view it the other way the filter is applied.