Comments
-
Hi, From what I can tell this is not currently possible. But it would be an excellent feature to add in the future! You can always add this in the ideas section. Regards,
-
Ok I see.. if you don't have it yet, you need to contact support and ask them to activate DomoMetrics datasets. There should be a dataset named: Card Usage with Datasource and Owner Information with the following schema : Card OwnerCard TitleCard IDCard Still ExistsOwner Still ExistsOwner IDOwner Employee NumberOwner Is…
-
Hi @mwade If I correctly understood the question, you have several ways of getting that information: In datacenter/Dataflows you can for each dataflow see which datasets it uses for input and output. In Datacenter/Datasets you can see the cards that the dataset is connected to: You can also use Data Lineage on the datasets…
-
In the Datacenter/datasets you have a delete option on the dataset. Does this help? Regards,
-
Did you try and recreate the dataset in DOMO? Regards.
-
Hi, Did your format the Columns as a number in google sheets? Do you have any value in the column (Other than the header) that is not numeric? I have several googlesheet imports and the column types are correct. Regards,
-
Hi, I went down that path once and got stuck on: The database reported a syntax error. [Amazon](500310) Invalid operation: permission denied for language plpythonu; Maybe support or another user could be able to elaborate deeper. Regards.
-
Great view on the subject @AS . I agree with you entirely, furthermore, DOMO still treats RedShift Dataflows as Beta. Here on our platform 98% of our dataflows are redshift and they were enabled since inception, and it's also my personal choice over Mysql, so I do tend to get a little biased. @VictorReye sorry for not…
-
Have you selected "SQL"? After that, you should have what I showed you.
-
Hi, In the data center click after clicking new and selecting SQL, you should have the following choices : This link should help: http://knowledge.domo.com?cid=datacenternew Don't hesitate to ask if you have more questions.
-
Hi, Have you considered trying a Redshift dataflow, if you can do it in mssql it should work in Redshift with minor changes... Hope this helps.
-
Hi, Can you be more specific? Maybe send me a layout of your data and the formula you want to calculate, I could help you further then. Anyway here is some more info on Beast Modes: http://knowledge.domo.com?cid=beastmode Regards
-
Hi, I think your problem is the ELSE clause, you are returning different data types. You should Return Null Or 0. Null Example : CASE When `Stage` = 'Cancelled' THEN 1 When `Stage` = 'Rejected' THEN 1 When `Stage` = 'Not Interested' THEN 1 When `Stage` = 'Invited to Apply' THEN 1 Else IFNULL(1,1) end Zero Example: CASE…
-
Hi, If I correctly understood your question, one idea would be to create an unfiltered BEASTMODE to calculate the percentage and then let the quick filters filter what data goes through. Hope this helps, don't hesitate to ask if you have more questions on this.
-
Hi, I can replicate what you are describing. But I do think this was not the normal behaviour in this cases. Further more if the page is published as a slideshow when you go to the link and see the publication, the cards retain their format (Showing data labels, axis legends and the scale information) I think there may…
-
Hi, I think your only option is to remove both column and row totals by using the show/hide totals button. Hope this helps.
-
Hi Dani, We are articulating this with support and our success manager. Just wanted some insight from anyone who had done this. Thanks
-
Welcome to DOMO! If you need further yep don't hesitate to ask the DOJO community.
-
Hi, Would publications meet your needs? They are browser links to slideshows of cards that can be viewed in any browser. Here's some more info: http://knowledge.domo.com?cid=slideshows Hope this helps.
-
Hi, If your are refering to BeastModes, there's SUBSTRING. Usage : SUBSTRING(String,Start,Lenght) / SUBSTRING('Employee Name',1,3) Some more info can be found here : http://knowledge.domo.com?cid=beastmodereference Hope this helps.
-
Hi, From my point of view, you will have to create a Beastmode for each of the series like this : Open Orders SUM( CASE WHEN `STATUS` ='Open' THEN `Amount` END Closed Orders SUM( CASE WHEN `STATUS` ='Closed' THEN `Amount` END Adjust field names to your case .Then you can use them as your series and add the forecast as…
-
Hi, Have you checked if the field is still a text field after importing? You can insure that domo treats that field as text by using the folowing BeastMode : CONCAT('',`Field Name`) Hope this helps.
-
Hi @Kurbz, I'm also interested in this topic. So is it possible to select a BeastMode as the source of the Hover text, even if it is not a serie in the chart? How can i accomplish this? Thank you in advance.
-
Hi, If I correctly understood your question, I think it can be solved be changing the number of series in the left scale. This propertie basically controls the number of lines (from different Series) in your chart. Then the first "N" series on your chart will be your lines. Trying to illustrate this: Don't hesitate to ask…
-
Hi, Try it like this: Case When year(`FULL_DATE`) = year(curdate()) then 'This Year' When year(`FULL_DATE`) = year(curdate())-1 then 'Last Year' End Hope it helps.
-
Hi, I don't think that what you are asking is possible. The closest thing would be the regression lines, but it would not meet your needs i think. Hope this helps.
-
Hi, You can solve that on the Chart Properties /Value Scale (Line) or Value Scale (Bar) and set the max and min for the scale. Be sure to uncheck the Sync Value Scales properties in Chart Properties / General. Hope this Helps.
-
Hi, You can share it as a Publication. Here's the link to a great publications overview Video: https://university.domo.com/videos/watch/JqY2x5djqgc7fKQZyOjA6z0Fn_2wwaic/cat/7e63adb502d244c0b4e056db8a00be1d Hope this helps.
-
Hi, On the chart properties in the general tab you can set the max number of slices before other, that can help you achive the behavior you want. Sending an example. Hope this helps.
-
Hi, Look for missing fields, divisons by zero, Field names changes. Normaly the card editor gives you some ints or you can remove fields from the card one by one and isolate where the problem is. Hope this helps.