Best Of
View cards but restrict the option to download the data
Hi,
Is it possible to be able to set the permission on card (or pages) so that users can view the data but have the Share options restricted. These options are currently set on our instance to allow users to download the data as csv etc... which is something that we would prefer to restrict for specific user groups.
Many thanks,
Tim
tgalling
Re: How to dynamically return the latest value for a filtered date range
Hi @Mickey - If you come at this from the completely opposite direction you can get to a solution that works. Here are the steps:
- Create FIXED functions for Sales and Units Sold. Example: SUM(SUM(`Sales`) FIXED ())
- Place "Date", "Sales FIXED", "Units Sold FIXED", and "Quantity On Hand" in your table card.
- You should have the sum of Sales and the sum of Units Sold repeated on each row at this point, as well as each discrete Date and Quantity On Hand value
- Make sure to graph by Day
- Sort by Date Descending
- Limit Rows to 1
- In General, go to the Hide Columns property and enter 1 to hide the Date column
Re: My pivot card has this red warning in the header, but when I export to excel there is no warning
If you are not seeing the warning in Excel then you can assume all the data was exported. You can refer to this KB article about limits on exporting and how it pertains to pivot tables as it counts the dataset rows and not the ultimate pivot table rows.
Re: Can we create a custom thank you message for forms in app studio?
Currently this would be a feature request (Post in the Ideas Exchange here in the community, happy to upvote it!)
To accomplish this with current functionality I think you would need to create a custom app that mimics a form, that kicks off a workflow, that would append that row to a dataset.
For example note the Form on the Left here (it is a custom app hooked into a workflow shown on the right):
Then upon submission, the app unhides and displays the Submission message, which could be whatever you want it to be:
For example here I've added 😢 to my Error message and you can see it displaying in the preview:
Re: Week of starting on Monday
@s_f_OTT If the value of your date field is on a Saturday, then the WEEKDAY function will return 7, not 0. So if you change the 0 in the first condition of your case statement it will apply the correct number of days to subtract.
Re: Better date selectors on cards
Hey @oscarfromspain
It's a few steps and if you use publication that adds a complexity.
To summaries:
- 4 date selection variable controls - bottom of dashboard page so users don't see it, all beast modes reference those
- Current Dates (Start & End)
- Comparison Dates (Stat & End)
- Custom DDX Brick that contains bulk javascript code that controls those variables based on the inputs in the brick controls this reference a DOMO Webform, but also builds the the calendar selection.
- DOMO Webform that contains ids of those variable controls mapped to some JS object that DDX brick references.
Thanks
Re: Better date selectors on cards
We had to build a custom date range brick that offered both options that controlled a series of variables.
Re: Why won't my card update?
For the card not to even update in the Analyzer, I would guess that it's not actually being fed by the same dataset, just one with the same name. When you click the down arrow next to the dataset and select "Change Dataset", is there more than one option with that name?
My hypothesis: someone was working on the MagicETL, deleted the output tile, then added a new output tile with the same name. Removing it from the ETL doesn't delete the dataset or any cards associated with it.
Re: Dataset Tags in Workflows Not accessible
@brycec so it is supported in Python as well, I was recommended it by Jace at Domo. I've created a ticket so all good, I'm pretty sure it's a bug.
NateBI