RGranada Contributor

That is strange indeed! If you want to send me a sample of your data I will have a look and see how it does on my platform... Regards,

Hi, If I correctly understood your problem and you want to aggregate to the level you are describing, you can't have the "platform" or "productgroup" columns directly on the table, because like that you are setting your grouping to date, platform, productgroup. With every different combination of the date, platform,…

I'm sorry can't quite understand your need. Can you draft the chart you are aiming for? Regards,

Can't replicate your problem.... Try to remove your sort field and add it again, and even do that to the rest of the fields. Every scenario I test I end up with the aggregation option on the sort field and the correct results. Please tell me how it goes. Regards.

Hi, Have you considered using one of the running total graphs? Running Total Bar Graph: http://knowledge.domo.com?cid=runningtotalbar Running Total Line Graph: http://knowledge.domo.com?cid=runningtotalline Running Total Stacked Bar Graph: http://knowledge.domo.com?cid=runningtotalstacked Running Total Grouped Bar Graph:…

Can you show me a screenshot of your card in the analyzer? Regards,

Do you have any aggregation on your `EB Project Risk` field? Regards,

Hi, Do you have any aggregation set in the sort field? It should be set to no aggregation: Hope this helps.

Hi, Try : POWER('Values',2) POWER(base,exponent) Hope this helps.

Hi, You can either setup a scheduled report for an entire page or for a unique card. From my knowledge collection os sets of cards are not possible yet. From my knowledge collection os sets of cards are not possible yet. One foreseeable workaround would be setting up a scheduled report for each of the cards you need. Not…

Hi, From my experience and that has happened to me in numerous times (I try not to trust too much on the Preview feature of Dataflows, just use it as a "syntax checker"), when you preview a dataset or a transform inside the dataflow designer it uses only a limited subset of your data, then when you run it it will process…

No plug-ins needed and it can be shared and part of a publication just as another card. Regards,

Hi, There is no simple way to achieve that. The best bet would be Domo Design Studio. There's great information about Domo Design Studio at the following link: http://knowledge.domo.com?cid=illustratornontech Hope this helps.

Hi, I think there is no straightforward way of doing that. You case use the following beast mode in each column, but you will lose DOMO's native ability to format numbers... Here is the Beast Mode Anyway: CASE WHEN `Your_Numeric_Field`=0 THEN '-' ELSE CONCAT(`Your_Numeric_Field`,'') END Hope this helps.

Just did it to avoid having more than two dates in the x-axis.... If we just try to convert the date to a string, due to a currently identified Bug DOMO would still assume the Beast Mode as a data and show all the dates between the populated records. Is there a better way to achieve it? Regards,

Hi, Try this layout: Where BT_Date is the following Beast Mode: CONCAT(MONTH(`Date`),'/',DAY(`Date`),'/',YEAR(`Date`)) Hope this helps.

Let's make some modifications on the beast modes: Resolved: SUM(CASE WHEN `Status`='Resolved' THEN 1 ELSE 0 END) Open: SUM(CASE WHEN `Status`='Resolved' THEN 1 ELSE 0 END) Don't mind the SUM() as it is just another way of counting the cases.Apply these ones with no aggregation. I did a graf by week and the results seem…

Ok, Can you share a sample of the dataset you are getting the data from? I wrongly thought that the table you sent was it, but it is just the table view of the card. Regards

Ok, So, if I correctly understood the card goal, give this a go: Create 2 Beast Modes like this : BeastMode OPEN: CASE WHEN `Status`='Open' THEN `Case Number` ELSE 0 END BeastMode Resolved: CASE WHEN `Status`='Resolved' THEN `Case Number` ELSE 0 END Then apply them to your card this way: I think this will give you the…

Ok, I'm a little confused here. Does Case Number represent the number of cases that were open or solved in a given Date. What is the goal of the card? If you could enlighten me a little more in order to give you the best answer. Regards,

I see... I think that is because you are lacking dates in your x-axis. Can you send a table view of your data? Meanwhile, I'll think of something to address this if it's the case. Regards

Hi, You can use on a beast mode : IFNULL(YOUR_FIELD, 0) Hope this helps. 

Hi @swagner, If I correctly understood your problem... Have you tried using just nullif? Divisions by 0 do raise an error but division by null equals null (This is what I systematically use), so in your case, I would go with : (Number of Lines / NULLIF(Hours Active,0)) / NULLIF(Standard,0) This way no divisor will ever be…

Hi, If you are referring to the new analyzer, you will need to drop down the toolbar (Green Square) and then turn on Properties (Orange Square), and then you will be able to see Chart Properties (Blue Square) : Hope this helps.

Hi @ST_-Superman-_, From my point of view, I don't think a regular date field could be the issue. Is this the only card you have this problem? Have you tried other field combinations from the same dataset and see if it saves? Regards,

Hi, Have you considered a publication with the card you need? Just share the link and the user can always check the values. Hope this helps.

Hi @ST_-Superman-_, Any Date/Time type BeastMode on your X-Axis? There is currently an issue reported regarding that situation. Regards.

So that's a 4K display, you probably have some scaling going on. Please check your screen scaling options here (Windows 10 settings) : Regards,

Hi, What is your plugin version? Is it the latest? Is your screen scaling set to something different than 100%? Regards,

Hi, Just tried IE 11 ... Can't even render cards... Or get to the Data Center! The top menus do work, Buzz seems to work either... but that's about it... Hope this helps.