ColemenWilson Coach

You can use the GREATEST() function in a beast mode to get the max date across these date fields and then use that as the date filter.

Here are some KB articles with more information: https://domo-support.domo.com/s/article/360043441593?language=en_US

You could correct the nulls by using the following beastmode: IFNULL(`YourValue`, 0) You can also sort any values using a beastmode like this: CASE WHEN `Transaction Month` = 'Jan' THEN 1 WHEN `Transaction Month` = 'Feb' THEN 2 WHEN `Transaction Month` = 'Mar' THEN 3 WHEN `Transaction Month` = 'Apr' THEN 4 WHEN…

The best way to accomplish that would be using MagicETL. Have you used MagicETL in Domo? Or a SQL dataflow if you are more comfortable with SQL.

You can accomplish this using the Pivot Table card.

Sort on descending and then limit to 10 items:

Gothca! Here are the steps: 1. Create a table card and add the fields Name, Age, and Birthday 2. Save and exit the card 3. Click the wrench on the card: 4. Click "Edit Drill Path" 5. Click "Add a view" 6. Repeat step 1 but with the fields you want displayed in the drill down view.

You would create a beast mode with the following code: (SUM(`Paid Amount`) + SUM(`Savings Amount`)) / SUM(`Bill Amount`) Then you'd create a table card with the first column being the Name and the second column being the beast mode you create. Here is a video on how to create a beast mode:

@verytiredgirl did you get this resolved?

Hi Jez, looks like you have multiple posts with the same question. I responded to the other one :)

Hi Jez, could you share a bit more information? Who will be the audience for this report? What metric are you wanting to show? Salary by employee? Salary by position? Salary by age? Or something else?

Gotcha, then multiple policies would be the way to go.

You can add multiple criteria by clicking ADD DATA next to the first criteria added. You can also add multiple policies for the same user/user group. I would also recommend contacting your CSM about Governance Toolkit. There is a tool there called PDP Automation that makes complicated PDP policies a lot easier to manage.

Hmm without logging in and troubleshooting I don't think I can help much more. I would recommend submitting a support case to Domo.

So you aren't seeing the PDP icon appear in the bottom right of those cards? And you've verified that the dataset powering that card does indeed have a PDP policy?

Are you seeing data you shouldn't? Or are you saying that the data is just wrong? I am guessing a filter is wrong and causing the issue not PDP. That would explain why the issue is on the dashboard level but not card level.

PDP is applied to a dataset and impacts cards built using that dataset, so it isn't a dashboard issue, but likely a dataset/card issue. Have you checked each card to ensure it is built using the PDP applied datasets?

BETWEEN is not supported in beastmodes only in Magic ETL formula tiles. You will need to rewrite the beastmode to be: CASE WHEN KPI Attainment % >= 0 AND KPI Attainment % < 25 THEN '0-24%' WHEN KPI Attainment % >= 25 KPI Attainment % < 50 THEN '25-49%' etc…

Hello. This was asked 2 weeks ago: The answer is no, and I recommended @deona720 add the idea to the ideas exchange. Not sure if that happened or not.

For data security no. You'd need to rebuild the integration.

Are you opposed to doing the join using Magic or SQL dataflow? Dataset views are notoriously buggy. Additionally would be impossible to troubleshoot without more information/screenshots/sample data.

Some ideas here: https://www.reddit.com/r/datasets/comments/9eiiv0/us_zip_codetime_zone_dataset/ You could also look at Domo Dimensions:

Is this how your rank is configured? It should definitely not be removing all rows of data. You could instead use the Group By tile and select MAX as the aggregation on Create Date. Keep in mind that you'll need to include all columns in step 1 that you want to remain in the data.

Honored! Huge thank you to @AnnaYardley , @sierrawise and @GrantStowell for all of your support!

@DanBrinton ^

Using filter views is a good option with PDP for strict restriction:

Not without a custom DDX brick. However, you could use hover text for the values and the series as the data label default. So you'd see hte view you screenshot above and then on hover you'd see the values.

Yep! Chart Properties > Data label settings > Text = %_SERIES_NAME > Show On: Last Item Only

You could use the Domostats datset "DataSets History". It has a field called 'Bytes Inserted'.

You could try this: