Godzilla Contributor

You should be able to do it as stacked bar as well, without any horizontal offset. You would do something like this:

I've done this many times. You will have to keep your Active counts and Cancel counts as separate columns in your dataset in order for Domo not to net the results. Like you mentioned, the Actives will have to be positive and the Cancels negative. I've also added a Net line in some cases by just creating a beast mode field…

try removing the %_SERIES_NAME from the 'Text' box and leave it blank. if you have interactivity on, it should highlight the line as well as the series name in the legend.

Yes.There are lot of combo chart types (i.e. stacked bar + line or grouped bar + line) you can do this with where you can have a bar one right Y axis and Line on the left Y axis. 

There is no way to stop the card from updating if the datasource is going to continue getting refreshed. I think you're only option is to create a new dataset for the new card. could be identical to the old one just with a different name. Once you duplicate the card go to the new card, scroll to the bottom of the page and…

have you tried the 'Running Total' chart types? there are couple of them (bar and line charts) that you can use which should give you the YTD numbers. 

I don't think there's a way to do this out of the box. You might want to put this in as an enhancement idea or contact support to see if what they have to say as it might be on the roadmap.

have you tried adding the field that contains the year values as a second sort? So if you look at the Sorting area in Edit mode, you should have two fields in the Sort area Month and Year. 

are you sorting the charts using the field has the year values?

You can do a case statement inside a Count() function and that should be equivalent to a countif() Count(Case when `Field1` = 'text' and `DateField` = '2016-04-01' then `Value` else 0 end)

not sure what you mean by web archives. if you mean deep linking to a web based system, you should be able to as long as you have the informaiton needed in your dataset to reconstruct the URL. 

can you provide a screenshot? we can't get to a chart that's in your instance of Domo.

i was going to say the same. you should just load in the data at the daily granularity and then use the time grain at the top to group by year/month/week/day. or if you really want to have drill throughs, you can have the top level chart grouped yearly, then the next drill through level grouped, monthly and and the next…

Yes

Not at the same time. The closest thing to that is to use the buttons on the top right side of the chart which allow the user to toggle between a table and chart. that's what I tell my users to do. However, that table only shows the fields used in the chart.

I've ran into this before and what i had to do was include the the hours in the data source with 0 orders. For example: if you have orders in the 9,10,11,12 oclock hours but want to also show 8 am (where there are no orders), you will have to add a record in your data set with that date/time with 0 orders.

make sure the field is being loaded as a date or datetime data type into Domo. then you can add a sort in your chart using the field. 

under chart properties, go to General and in the "number of lines" box, type in the number of lines you want on the chart. 

This might be due to settings on your machine. On IE, when i export to excel, it behaves as you desribed in your future state. On Chrome, it allows me to open the file without having to save. 

why don't you create a drill through that looks like the final data grid minus the sensitive column and then mark the 'Prevent drilling to final data grid view' to Yes. 

i completely agree with you on having the ability to set the default date format. it's something I have to modify in almost every card. On a card by card basis, you can also use beast mode to convert it to the format you want. You can do something like this: DATE_FORMAT(`MyDateColumn`, '%m/%d/%Y') this article covers date…

you can change the format back in the chart properties. Go to Category Scale (X) under CHart properties and hover over the Date Output Format field. It will give you examples of how to format. if you want to change it back ot the format you had in your first screenshot, i think typing in the following in the Date Output…

sorry i'm not familiar with Version4 yet. This help article might be of some use. http://wiki.domo.com/confluence/display/428BA51/Understanding+the+Workbench+4+user+interface#UnderstandingtheWorkbench4userinterface-Settings.1

No you can't. The next closest thing to another level of sub pages is 'Collections'. you can create a collection on a page and group the cards together by dragging them into the Collection areas. To create a new Collection on a page, click on the wrench icon and from the drop down select 'New Collection'

you can use the time grain at the very top of each card to do this. Make sure you use the date field you will be using for your x axis as your 'Date Range field' and then you should be able to use the time grain to do this.

If you have trouble with this wth the latest version of Workbench, try Workbench V2. As long as you can create an ODBC DSN entry on the machine you're running workbench on, I think you should be able to connect. I haven't tried DynamoDB specifically, but i haven't had any issues connecting to any system using a DSN entry.

I would add these to the idea exchange to get votes by the community members and get it on their roadmap.

if it's a sub page/tab, make sure they have access to the main page/tab.

Make sure you don't have 2 colunns with the same header or columns with blank headers.

is this an existing dataset your trying to refresh and are you using Domo workbench or something else?