Jones01 Contributor

@jimsteph I believe this is the expected behaviour. I had discussed this with someone at domo. I think you end up having the original data with a null partition key. They suggested filtering this out.

@SirishaRani Hi, could you post a screen of this option within the admin settings please?

@user084060 you'll only get the group by functionality on a pivot table if your Date is in the COLUMNS section. It would work using a megatable but you'll lose the pivoting capability.

@Casey_Dorman {Domo} being able to use a formula for this would be a great solution so you could then default the date to the end of the last week or the end of the last complete month.

you'll need to aggregate the data in the beastmode when calculating the variance like below (sum(Column) - sum(Column 1)) / sum(Column 1) *100 I suspect you may just be doing (Column-Column 1) / Column 1*100

@GrantSmith domo had an outage with some part of the identify broker we use. It was just giving back a 503 error. I'm waiting for an RCA on the issue to find out the exact cause. They got it working around 4pm UK yesterday

@Gionniz This can be achieved within company settings. Although it would be nice to be able to choose the language and number format independently as we have users for example n Greece that isn't on the list but require European number formatting. They are happy to view the system in English just need the number formatting…

@GrantSmith thanks. Yes feature seems to work although I need Greek so hoping it is easy for domo to add new formats.

This can be changed in company settings within the admin.

@MichelleH sure no problem, Using a megatable automatically allows the graph by on the date field if the first column is a date or datetime type.

I won't delete the post but will answer myself. A megatable can graph in this way.

@michiko Yes but the other way so Uk to Europe. 28,586.84 to 28.586,84 Thanks for the tip. I am waiting to hear from domo whether this can be something set on the instance.

Have upvoted this as absolutely crucial for us to have this at instance level which would hopefully then impact every element. Our customers love to export tables to Excel and without the separators being correct Excel will not see those cells as numbers!

@Lowell_Walker thanks for your reply. Yes the new Edge version even if third party cookies are allowed it still requires a gesture from the user to allow them via the storage api. domo calls hasStorageAccess and if that fails it calls requestStorageAccess which requires a user to click a button to allow cookies. Safari…

@GrantSmith thanks. I was hoping this could be completely dynamic so we wouldn't have the overhead of maintaining the groups in domo across multiple instances. Hopefully this is something that comes in a future release.

@user046467 contact domo and they can enable it on your account like below.

Hi @Aditya_Jain The user currently has a role with these grants and the share option doesn't appear unless I give the Manage All Cards grant but that seems like overkill.

@Aditya_Jain thanks but looking at the grants available it isn't obvious which one would enable the sharing of pages.

@apurkhardt Hi, we currently have this functionality enabled on our sub instances. Each of our sub instances has different fiscal years loaded into them. We publish cards with the fiscal option selected and this is also published to the sub instance. Hope that made sense!

@MarkSnodgrass thanks. Oddly the history of the ETL was empty but I managed to follow this guide and repoint an ETL at a the dataset using the Java CLI. https://www.youtube.com/watch?v=YgJLijj7vmw

Other improvements / bugs that need addressing are. Dashboard filter options don't get published correctly to our subscriber instances. Also some DEFAULT filters on our boards never show up in the subscriber instances.

Answered via slack group.

@kcoughlan65 other than setting the total shadow to fff and turning off gridlines there doesn't seem to be an option for that.

@SaloniShah try using the alter column tile after the append to cast it into a date.

@damen can you just include AND LENGTH(CONCAT(`LOAN NUMBER`, '')) < 7

@kcoughlan65 Hi, I've mocked up some data and produced this using a nested bar chart. Within the general tab I selected these options which in mind sorts based on the totals of each code and then limits the chart to 10 items. Does this help resolve your issue?

I was going to post the other day but assumed it had been a long week and I just couldn't see it. Definitely gone for me.

@MichelleH thanks. I had a feeling that would be the case.

@Jackie96 have you had a look at the native period over period charts Domo provide?

I'll mark this as resolved and answer my own question as hopefully will be useful for others. To get this behaviour I choose a Grouped bar + line chart. My sales went on the Y axis value and then next part was important. The next series value was budget followed by %. Then to move the budget value onto the left scale I…