Aditya_Jain Contributor

Comments

  • Hi @user04906 , You can use beast mode to filter the date to always set it to yesterday. Kindly follow the steps, * Create a beast mode - DATE_SUB(CURDATE(), INTERVAL 1 DAY) * Put the beast mode to filters and select 'In' and keep the check box unchecked. Hope this helps Regards Aditya Jain
  • Hi Suman, If there are only these 3 columns in your dataset, then conceptually what you have done should work. You might see data in not so okay form in the intermediate ETL steps as it becomes dis/un aggregated. I am sure if you plot the graph, you should get all the values in the expected form as you would aggregate (sum…
  • Hi Suman, Please follow the steps, Click on the Sep, 2019 and Nov,2019 columns of you table card as depicted in the pic below and Select 'Sum' under the aggregation options. You are getting 2 sets of values because you have not aggregated it. Hope this helps. Aditya Jain
  • HI @SumanK , As per the info provided by you, there are 3 columns Date, Addition and Depriciation. DateAdditions during the yearDepreciation for the yearNov-19394182139.1-433876572Sep-19-433876572-352870676 You can follow the steps to pivot the data in Magic ETL, * Collapse the 'Addition' & 'Depriciation' columns and give…
  • Hi @user099612 , Yes,It's possible to adjust the colour, you can set the conditions under the Colour Rule settings of the graph. Hope this helps. Aditya Jain
  • Hi @Ron , This could be a useful feature. You can go ahead and input this idea on the 'Ideas Exchange' forum.
  • Hi @AvinashK You can directly use 'Comparative Gauge' Card for achieveing this without the need of using images. It's available under Chart Type 'Gauges'. * Please follow the below mentioned steps, * Select 'Comparative Gauge' Under Chart Type 'Gauges' Here, you can put 'Current' Value as 'A' and 'Previous Value' field as…
  • Hi @hamza_123 , The query that you have written has a syntax error. SUM (MAX ('Age')) OVER (PARTITION BY 'Animal') AS 'Age', SUM(MAX ('Weight')) OVER (PARTITION BY 'Animal') AS 'Weight' Aggregation of already aggregated column (SUM(COUNT)) can not be done this way. Also, It would be great to check with Domo Support if…
  • Hi Sivaranjani, If the data you get every month does not have previous months' data then you can follow the steps mentioned below, * Go to the dataset settings tab * Under the options, go to scheduling, * Check for update method, and set it to 'Append' Doing this, whenever you refresh the dataset, new rows would append to…
  • Hi @user022663 , If you are still getting 0, then it could be because the numerator part of the formula is 0. So I think you should check the data for the numerator, i.e., 'Action' = 'Lead' part.. Also, please check if you are using your column 'Action' as a filter and you have not put 'Action' = 'Completion' as a filter.…
  • Hi, Generally Dashboarding of the cards depends on what storyline your business aims at . Also the target audience plays an important role. Let's say your dashboard users are top executives, then they might not be interested in granular data and would mostly see top level data. Second point of consideration is how you want…
  • Hi @user099612 , As such you can not add a line on the progress bar, but I can suggest you another chart type, Under horizontal chart types, select bullet graph (this is available in vertical chart type as well, whicherver suits your need) Here we have a target line by default. Hope this helps, Regards Aditya Jain
  • Hi Giolaj, I am not getting into the logical part of the solution, just trying to suggest a syntax here, Please try doing this, SUM(TIME_TO_SEC(`Time1`) / 60) + SUM(TIME_TO_SEC(`Time2`) / 60) + SUM(TIME_TO_SEC(`Time3`) / 60) + SUM(TIME_TO_SEC(`Time4`) / 60) Hope this helps Regards Aditya Jain 
  • Hi, The reason for it to return blank rows could be, * There could be a spelling error in the 'WHEN' condition, so kindly check the spelling (it's case sensitive too). * The condition is never true and since there is no ELSE condition, it would return null, so kindly add ELSE 0 in both the condition or give an appropriate…
  • Hi, You can set the alerts by following the steps as mentioned below, * Go to your dataset overview in Domo Data Center * Click on the wrench icon on the top right corner of the screen, and click on the notification option * In the popup that appears, select the option 'Send email only when this dataset fails to update'…
  • Hi Hamza_123, For activating the feature, if you are an Admin, please follow the steps, * Got to Admin panel * In the left hand side menu, go to 'Company Settings' * In the subsequent menu, go to feature management and toggle the button on Please note : if you roll-back the featue/ turn off the feature, the third level…
  • Hi, Changing the name of Workspace or Model does not have any impact on the connector. Shifting(changing) of workspace or model will have an impact. Hope this helps Regards Aditya Jain
  • Hi, Please try this , SUM(CASE WHEN `Action` = 'Lead' THEN `Unique Events` END) / SUM(CASE WHEN `Action` = 'Completion' THEN `Unique Events` END) So basically, type the first part but aggregate the entire case statement instead of aggregating it inside the case. Then divide it by the second formula, here also, please…
  • Hi, Yes, you need to check all the beast modes, no matter you are using the beast modes in the graph or not. Also, you should check if you are filtering anything on the top card (card with dataset A), then the same column should be present in the dataset B, this might also cause the same error. There is another way you can…
  • The link provided by @BrendanH is correct, but the stacker feature has to be turned on for your instance. One can reach out to Domo CSM for further details on it.
  • Hi Ron, I suggest you to take a look at 'Activity Log' report DomoStat Dataset. There you can get the info of user Logged in through SSO, under the column 'Action'. Please check it, this might solve your query,as a suggestion, be careful with log out time also to see if user was still logged in or logged out. Along with…
  • Hi, There could be a couple reasons for this behaviour, * Please check for spelling errors,including case as column headers and fields are case sensitive * Please check all the beast modes, there is a good chance that a beast mode was created on a column which was altered by any means in the source dataset / ETL etc. Hope…
  • Hi Sonya, If I have got this right, you want to get notified whenever your dataset update fails. You can turn on the notificaitons by following these simple steps, * Go to the data center, * Open the dataset you want to enable notifications for * On the top right corner, click on the wrence icon (settings menu) * Click on…