Godiepi Coach

Comments

  • is the beastmode Blue or Green when you add it to the sorting section if blue = Text that explains the order 1, 11, 12, 13, 2, 3, if green = its a number and should sort properly 
  • Not really ... you can re-assign ownership of pages but, there is got to be always an owner
  • A work around would be to build a beastmode to use as your summary number using a Concat() function this way you can have more than just one metric displaying and adding some HTML formatting to differentiate one thing to another
  • Yes you can lock the X and Y axis to be a one to one match , go to your card properties and scroll down to "Value Scale (Y) and "Value Scale (X) independently see screenshot below for guideance
  • I suggest you go to the app store and run a search under the connectors section for "Facebook" You will find a "Facebook Ads" and a "Facebook Ads Advance" The difference between them is that the Advance version allows you to download more datasets including one called "Ad Campaigns" which Returns information about one or…
  • Hi@JonavilCello , First you will have to have Admin Priviledges or a custom role that allows you to get to it to understand custom roles , refer to this link https://knowledge.domo.com/Administer/Controlling_Access_in_Domo Domo everywhere : To enable this feature, a user with an "Admin" default security role or a custom…
  • Hi @imelendez In the Dojo we have seen this type of question and other members have come up with great solutions and great examples. I am attaching these 2 links below for you to take a look if they help you solve your question. if not, let me know to look at your case further…
  • Let say you have a bar card ploting count of transactions for the last 14 months by month on your summary number if you select "Use current value" it will run the aggregation selected (Count, sum etc) on the very last point ploted , in this example the most current or recent month now if you select "Use all values" it will…
  • That is because you selected the wrong type of chart. Instead a grouped bar you need to use a line + bar chart.
  • I just checked the settings general options for Line+Bar charts and it is still available , you can set "Number of Running Total Lines" and "Number of Running Total Bars"
  • Hi @Akhil you can easily create an ETL dataflow using the "Collapse Columns" option setting up up as shown in the picture below to create a new Dataset that allows you to create that Pie chart you are describing
  • If you dont want to create a new dataset you could use a beastmode to force the number to text concat('',`Sold Price`,'')
  • I'm not sure if I am understanding well what you are trying to do but, you could do a beastmode Count(Distinct `Location`) then in your table , use the 'List of Attributes Field' as the first column in your table and bring the beastmode to the second column .... this will give you the name of the attribute and the distinct…
  • Other than Nulls in your fields , is there anything else that could be forcing the field to be a Text field instead of numeric ? spaces at the end or beggining , maybe a humman error inputing a letter instead of a number etc ?
  • You can do SUM(IFNULL(`ColumnA`,0), IFNULL(`ColumnB`,0), IFNULL(`ColumnC`,0)) 
  • @ST_-Superman-_ its got to take more than one to be able to help the man of steel ? (Superman theme song playing in the backgorund) @DaniBoy should take @cwolman and me up a Belt in the Dojo for doing this LOL ! Have a good day guys
  • The CONVERT_TZ function automatically accounts for daylight savings when using long time zone names for example: CONVERT_TZ(`Date`, '+00:00', '+10:00') CONVERT_TZ(`Date`,'UTC','American/Chicago')
  • Have you tried using the Convert_TZ() fundtion as a second argument ? here it is an simple example of how to use it DATEDIFF(Date(CONVERT_TZ(now(),'UTC','EST')),`TransactionDate`) this give us the number of days from current date/time
  • Oh no problem , Domo is who needs to apologize because we are in the beta program too and don't see that option available for us LOL
  • It does the same thing on my flows so we have to adjust for UTC time since we are in EST time, always substracting 4 or 5 hours depending of daily savings time to prevent that issue
  • @ST_-Superman-_ I think we were both replying at the same time ? anyways, I notice you have the option to create a summary number within a textbox in a dashboard design ? I don't see that option in my instance ... is it in beta ? also the ability to select the Text font ? this is what I have :
  • You can create a Blank Label beastmode to use as the Category in the settings of the Dynamic Textbox that way there will be only 1 value to display Beastmode = ' ' ..... or you can use a regular TextBox card
  • Not the most elegant solution but you can create a beastmode concatenating the Year(`Date`) and Month(`Date`) (if you will be always showing a month trend .... where month = 1 then Enero Month = 2 then Febrero and so on
  • Hi, this is very simple to do in magic etl , take a look at link below for instructions on how to "Collapse Columns" it is in the knowledge base and here it is the link https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/02ETL_Actions%3A_Edit_Columns
  • You should be able to go to the Settings tab in your dataflow to make it run on a schedule
  • If what you are asking is how does drag and drop works in edit dashboardmode ? this might help you There are 2 ways to create a story or dashboard 1) transforming a page already containing cards into a dashboard : on the upper right corner from the wrench menu select Design Dashboard... this action will convert the whole…
  • you can create a custom Role blocking the ability to create,manage, delete datasets . go to Admin>Roles and click on [+NEW] to create a custom new role. after that you will see a list of permissions which you can check and uncheck the level of access.
  • oh , you should see 14 different reports you can connect to in the details report section of the connector. if you can't see the reports or just few of them , you might need to ask your account manager at Domo to make them available in your instance but you should see them as they made them available for everyone already…
  • Hi , Good morning. Take a look at the screenshot attached with this brief explanation for a better sense of what I mean. Taking these 3 datasets as an example from the Domo Governance Datasets 1) Dataflow Details 2) Cards and Datasets 3) Pages and Cards all these datasets have ID fields that allow you to reference back and…
  • It all comes to your company time zone settings and the time zone you are telling Domo your data is in when importing it throught workbench. take a look at this article from the Domo knowledge base https://knowledge.domo.com/Administer/Specifying_Company_Settings/033Time_Zone_Issues_FAQ