Best Of

Can you create a virtual dataset from a dataset view?

I have a Dataset View from a production instance and I would like to bring that dataset to the Dev instance by creating a virtual dataset of that view.

In Production, I was able to create a job for that dataset view, ran successfully, Run Status: Idle. But when I go to the Dev instance, I do not see the virtual dataset there?

Re: MTD & YTD Toggle

@Data_Devon

What if you used variables to change the different axis and comparisons? Here's an example: https://youtu.be/2xuLwBGM9U8

Re: Subtotals in PivotTables

The thing there is that you have 2 rows, Level and Spend, and I'd guess each level is tied to only a single Spend based from your screenshot, if that is not always the case then you want to keep it the way it is, as the numbers will not always be "duplicated". As a workaround, you could display only one or a single one that is the concatenation of both values, not the prettiest solution but something that you can apply right away. I agree with @MichelleH and having a feature that would allow us to indicate the number of levels at which we want subtotals calculated would be awesome.

Re: View as user or view as role

@JordanJensen - I think the word 'impersonation' has been taken too literally.

We need to be able to see what a particular user or role can see. If someone wants to act on behalf of another user at some point, that is another discussion. A pretty high level of complexity is possible with PDP, and not being able to validate how it is applying is a huge risk.


NOT having this feature is a security risk.

How is it currently handled on the Domo Support side? The idea that people who barely know Domo can impersonate users is pretty scary. Can they make changes as the user or just see what they see?

Re: Analyzer Double Click to Add Dimensions/Measures

Or a shift-click functionality that allows you to select multiple columns and drag them all at the same time

Re: View as user or view as role

Oh no, that would not be secure at all. All we are looking for is a view as user or view as role - "view" being the key word.

Re: View as user or view as role

This would be huge for us. We have tried to do as @swagner recommended but it is limited and time consuming.

Re: How do you add lines to a pivot table?

Hello @kim_barragan0126,

You have to play around with the General, Header Row, Header Column, Total, and Subtotals settings:

Re: Extended DataSet information on DOMOStats

This is a great idea. I think it would also be helpful to show the state of the dataset (Draft, Disabled, Non-queryable, etc.)