Updating data set

karlysindelar_2023

I am new to DOMO, I have uploaded my spreadsheet and can see my card and chart, how do I update the spreadsheet so the datat is up to date each week. Also I have it listed as weekly revenue but it shows as monthly?

MichelleH

@karlysindelar_2023 Once you've created your dataset you can find it in the Data Center, which you can find by clicking the DATA icon on the top of your screen

Then you can go to your dataset list on the left navigation menu to search for the dataset you've created.

Once you find your dataset, open it and navigate to the Settings tab where you can re-upload the file as often as needed. This will automatically refresh any cards that are powered by that dataset.

Here is an article for more information on the File Upload Connector:

https://domo-support.domo.com/s/article/360043436573?language=en_US

MichelleH

@karlysindelar_2023 Yes, you can change your date groupings by opening your card in Analyzer and changing the Graph by setting to Week instead of Month.

Here is a KB article on how this works: https://domo-support.domo.com/s/article/360043429633?language=en_US

MichelleH

@karlysindelar_2023 Of course! It looks like the values in your datset are negative, but you can display these as a positive number by creating a Beast Mode ( https://domo-support.domo.com/s/article/360043429913?language=en_US ) to use as your Y-Axis value instead:

-1*`Credits issued`

MichelleH

@karlysindelar_2023 Once you've created your dataset you can find it in the Data Center, which you can find by clicking the DATA icon on the top of your screen

Then you can go to your dataset list on the left navigation menu to search for the dataset you've created.

Once you find your dataset, open it and navigate to the Settings tab where you can re-upload the file as often as needed. This will automatically refresh any cards that are powered by that dataset.

Here is an article for more information on the File Upload Connector:

https://domo-support.domo.com/s/article/360043436573?language=en_US

karlysindelar_2023

@MichelleH Can you tell me how to make this chart weekly? So my spreadsheet shows week ending and one axis and its showing it as monthly?

MichelleH

@karlysindelar_2023 Yes, you can change your date groupings by opening your card in Analyzer and changing the Graph by setting to Week instead of Month.

Here is a KB article on how this works: https://domo-support.domo.com/s/article/360043429633?language=en_US

karlysindelar_2023

@MichelleH Thank you for the help. One last question, I think. I am showing a negative dollar amount, is there a way for the chart to look like the bottom? It looks upside down to me?

MichelleH

@karlysindelar_2023 Of course! It looks like the values in your datset are negative, but you can display these as a positive number by creating a Beast Mode ( https://domo-support.domo.com/s/article/360043429913?language=en_US ) to use as your Y-Axis value instead:

-1*`Credits issued`

user04612