ckatzman Contributor

We import all of our date data in the 'YYYY-MM-DD' format, though i will admit that we do not use Google Spreadsheets. The one thing i note from your date example, is it looks like maybe you are doing YYYY-DD-MM... (ie, there is no month 13) The other thing you could try is pulling the pieces apart and using the…

I had a similar issue a couple of months ago. I put in a ticket with DomoSupport, turned out there was something corrupt behind the scenes that they were able to resolve and my Output dataset was fine thereafter.

For every inquiry you can see on this topic, there are probably 100 more that haven't spoken up. Hiding in the walls, like roaches...

Can you post an example of the format that your date field values are showing? Do they look like properly formatted dates, but they didn't pickup a date data type during import, or are they representative of dates but not in a date format (ex: 20160720).

Add the date field that represents your X-axis value to the Sort criteria in edit mode, select Ascending, and depending on your card you'll need to determine whether it's No Aggregation or which Aggregation to use. Most likely, No Aggregation. If the date value you are uising is not a Date data type, then you may want to…

I don't think it's a move so much as a re-enter in the correct area (link here: https://dojo.domo.com/t5/Ideas-Please-suggest-ideas-to/idb-p/Ideas). That said, I did have another idea, similar theme as the first, but a different approach. This may or may not work depending on the level of functionality your users…

Depending on the nature of your data, dataset, and the overall analyzer capabilities you wanted a user to have, if you had a preconstructed, pre-aggregated dataset with a numeric rank based on some ordering (Sales, descending for example), you could apply Analyzer against that rank ordering number. That's probably not…

How about setting a parallel date value field to whatever date you really want your view to be based on, but only populate values through the end of the prior week. Leave current week date values empty, and set your lookback to 5 weeks. "Last..." naturally wants the current period to be inclusive - you are forcing the…

@jeffcavallo, see this previous post which may help. The naming convention is very specific, but it looks like you've got that part ok. It is also my understanding that it may not work if there are any records with incomplete or invalid values. In that case, it may be necessary to create a pre-filtered Dataflow to…

Thank you, that view helps. I was locking myself into thinking about "Series" with No Aggregation. But instead, having two separate measures to represent the Series components, and no Dimensional Series value, totally makes sense. Thank you (again!)

Oooohhhh... so there will be a horizontal offset between the two columns. Not Stacked which is how I was thinking about it, but rather done as a Grouped Column, one will go up, the other down, and they'll share an X-Axis value. Got it! Not exactly the visual I was going for, but I can see how to do it now, and an…

Hi @DaniBoy, thanks for the follow-up. Yes, there are several active map-related posts in the Ideas Exchange, at least one that I wrote, and another that I've piled-onto. The ability for map cards to have a persons name listed by state, county, or zipcode Improve United States Map Card functionality Product Manager has…

@kingaaronj, nothing yet. @Gavatar, I think you are the Product Mgr for this area, aren't you? Can you enlighten on any maps-related enhancement that may be in the works? There are several different Ideas and discussion threads on topic floating around the Dojo. Thanks!

Been a while on this topic, had to move on to other things, but have had occasion to circle back and work on this. I now have a dataflow created with Magic ETL... Essentially, each segment is looking at the entire population, but based on a different attribute, so that I can create a stratified view of the overall…

Table cards don't currently "Total", but I believe there is already a request submitted for this functionality to be developed. One of the product managers should be able to confirm that, or you may be able to search/find in the Dojo. We had a similar quandary though, and we solved it through a DataFlow. By creating one…

@theCliffs, sure. Let's say you have a field called 'Signal' that results in 3 potential values, 'Green', 'Yellow', and 'Red'. In order to better control the stack order and structure of a stacked bar, rather than just bringing in 'Signal' as your 'Series', you need to create the fields separately as individual Beast Mode…

This functionality does not currently exist in Domo that I'm aware of. In fact, there have been several Dojo posts in the past about implementing this type of "limitation" for the end-user. The only suggestion I might make for the time being is to create a dataflow from your source data, containing only the data elements…

@AaronS and DomoSupport were able to provide a solution here. Apparently for the State Map card to work properly in the zoomed county & Zip code view, it is very particular in terms of the naming of the fields. They MUST be exactly, 'State', 'FIPS' (including capitalization), and 'ZipCode'. Other variations will not work,…

Working on getting some more details... there is a "developers" page, with reference to developer API content, just validating that that's the right source and will repost as soon as I confirm. Today, the manager has to login to a site and manually select/retrieve various reports that provide customer service queue call…

As shown immediately below... yes? Then for the drill path, the next level map card type is also United States is I think what @smurray said, but the "State Name" is instead set to use the FIPS category value...? The FIPS code works fine with the US Counties map card type, but is returning no values when applied to the…

Ok, now i'm even having problems with my Dojo post skills... I swear I'm having my own personal iD10t kind of user-experience day. @smurray @Rich I've made some dataset edits, added a filter to eliminate some records where my state value was blank in the top level card. Went into my drill path, Edit, changed the card type…