Best Of
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.)
BCorless
Re: View as user or view as role
100%.
Trust and a more positive user experience will come from our Dev team being able to catch authorization issues. Whether that’s seeing if PDP works correctly to have card/page access set correctly.
Re: Magic ETL Preview Single Tile / Run to Here
Love this idea!
Would also love to have all the heavy lifting of the front end run once and then be able to run a few tiles at the end to tweak things.
Re: How to Find # Customers with X Miles
I like your attitude!
I found this article on how to calculate distance in Excel: How to Calculate Distance Between Two Addresses in Excel. Beast Mode SQL doesn't support the necessary functions, but Magic does. To calculate straight line distance in miles, you'd just use this formula in Magic:
3959 * ACOS(COS(RADIANS(90 - `Latitude1`)) * COS(RADIANS(90 - `Latitude2`)) + SIN(RADIANS(90 - `Latitude1`)) * SIN(RADIANS(90 - `Latitude2`)) * COS(RADIANS(`Longitude1` - `Longitude2`)))
If you're looking for driving distance, that same article talks about using the Google Maps API to do so. Implementing it would certainly be easier with the "coming soon" feature of API requests in the Python tile, but you should still be able to achieve it today with Jupyter Workspaces or Code Engine.
brycec
Re: How to Find # Customers with X Miles
I have a video that walks you through how to calculate distances between cities in Magic ETL. Once you calculate the distance, you can then use a filter to show which cities are within a certain range.
