ST_Superman Domo Employee

Sorry. I guess that I misunderstood your question. Are you saying that you want the ETL to name the input data set something other than the actual name of that data set? In other words, you want to be able to use an input file called 'February Sales' and have the ETL label that 'Sales' or something along those lines? I'm…

I believe that the table name is created when you first assign an input dataset to a tile. If you then change the input data set (but don’t delete the tile) the name of the table does not update. The fix would be to delete the tile and drag on a fresh input dataset tile. 

I'm guessing this is more of a question for your local Domo admin. You should try reaching out to the data set owner via Buzz.

I would try opening up a support ticket for this one so that someone from Domo can get into your instance and view what is going on. Could be a bug?

Do you have access to the dashboard layout feature yet? If you do, then you can accomplish this with a few interactive filter cards. Let me know if you have trouble viewing the video and I will work on some screenshots instead

https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/Doc_Cards/Permitted_File_Types_for_Attachments

This is how I translated your question: Can I not write SQL in ETL I hope you can code all in SQL, Since there is not much knowledge of SQL, I am using ETL. However, for functions that can not be done with ETL, there is a process of outputting once, converting and re-outputting it back to ETL. I hope I can write the…

can you share a screen shot of the scheduling settings? You need to make sure that you select which data sets you want the dataflow to trigger off of. So you need to check two boxes. One to indicate you want the dataflow to fire when a data set updates and then at least one more to indicate which of the input data sets…

I've had a simliar issue when looking at some of our financial data. My solution was to create a webform that would allow me to indicate the Reported Year and Month. I then added this webform to my data set and I can use filters for `Date Field` = `Reported Date` Hope that helps.

I would recommend sending this in as a Feedback item. It is less likely that this will get to the correct eyes if you keep it in the Dojo.

Make sure that your Access Token has not expired: That is the error message that I was getting when I tried using an expired access token

I think the issue is the field name. Can you try renaming it to something like `year of survey`? It is my understanding that certain field names are already being ‘used’ by Domo, `Year` being one of them. Not sure if there is a list of these available anywhere or not. I would try changing your field name though. That…

I’m glad you found what you needed. If possible, could you share what you learned, or post a link to the thread that helped you out?

Good stuff, glad I could help.

There is an option to do this in the Dashboard design beta. If you don't have access to this beta, you may have to wait for the public release (perhaps after DP this year?)

Sorry... you actually want no quotes just [space]-[space] It would look like this: -

Can you try a single quote? ' - ' instead of " - "

I had an old feature request related to guage cards, but I added a comment to include all cards... https://dojo.domo.com/t5/Ideas-Exchange/More-Format-options-in-Guage-cards/idc-p/39460#M7049

I agree with @dthierjung The best option within Domo would probably be the Domo Webform. However, if you are using a third party product, there can be some better options to accept user input and push that through to Domo. We are using Sharepoint and SmartSheets and both options have connectors available to bring the data…

You will want to collapse the columns for sure. Does the column number mean anything as well? Would it matter if col 1 was 05 over col 3 being 05? if so, you would want to collapse your data to have 3 fields; rec col value A 1 05 A 2 10 and so on

Is the `Month and Year` field a text field or a date field? The radio button will always default to displaying the values in ascending order. You may want to try using a beast mode similar to this for the actual radio button: (CASE WHEN `Month and Year` = '2018-August' THEN '1: 2018-August' WHEN `Month and Year` =…

 

Do you have a Domo Success Manager? That is the person I would reach out to

You beat me to it @dthierjung 

The table name is in the top left. (click on the pencil icon to change it)

Have you looked into the period over period graphs?

A case statement works through your data one row at a time. It looks for the first "when" statement that is correct and then evaluates the "then" expression. If no when statement is true then it goes to an "else" statement or returns a null value. In your case, you had one when clause and an else statment. So, when it…

I would stay tuned for releases at Domopalooza... I have it on good authority that this will be addressed in a very near release.

I think that you are subtracting 1 from the wrong year field: try this. sum(CASE WHEN YEAR(current_date())-1 = YEAR(`week_beginning`) THEN `sales` ELSE 0 END)

I would try pulling the aggregate out of the case statement. sum(CASE when MONTH(`Datum`)=MONTH(CURRENT_DATE()) and YEAR(`Datum`)=YEAR(CURRENT_DATE()) then ifnull(`Total`,0) else 0 end)