#URL0 debatiendo

Trying to count unique URL's for a given month that have "overdue" in the overdue status field. Has to be broken out by month and I want the overdue status to be from the line that has the max scan date for that particular URL for that particular month. Some URL's are scanned multiple times and the first scan date might say "overdue" but the next will be blank which means it would not be in the count. Also, will break out by Region and Sector.

I tried using a calculated max scan date for given month in formula but not sure that formula is even right { FIXED [#URL]: MAX([Scan Start Date])}

Then I try to count the # of sites overdue:

{ FIXED [#URL], [max scan date for given month]: COUNTD(IF [Overdue Status]= "overdue" then [#URL] end)}

Right now the count includes all Overdue for that month, not just from most recent scan.

I am not the best at formulas and it has been awhile since I have worked on anything like this. I have spent hours trying different formulas but need help.. thanks to whoever can help. It will be appreciated!!

Hi Everyone,

We've just successfully upgraded our Production environment to Tableau Server 2019.1.2. Is there a way to disable Ask Data for all data sources on the Server?

Thanks.

Muteru Mwangi

Create a URL-Driven Salesforce Activity Report!

This How-To will provide the foundation to generate any URL-driven report on any of your objects’ record pages. All this with the click of a button.

By implementing this feature, you can remove the Activities component from your Salesforce page layout, improving your record’s load time.

You can replicate what you will learn here in your contacts or your leads, and…given it’s a native Salesforce report, you can export it to Excel and send it to colleagues that don’t have access to your org.

Here's the Row-Level formula referenced in the video:

IF(ISBLANK(TASK_SUBTYPE), EVENT_SUBTYPE, TASK_SUBTYPE)

Watch it here: https://www.21knots.com/resources/url-driven-activity-report

Enjoy!

#Reports & Dashboards #URL #URL Hack #Account #Bar Chart

Create a URL-Driven Salesforce Activity Report!

This How-To will provide the foundation to generate any URL-driven report on any of your objects’ record pages. All this with the click of a button.

By implementing this feature, you can remove the Activities component from your Salesforce page layout, improving your record’s load time.

You can replicate what you will learn here in your contacts or your leads, and…given it’s a native Salesforce report, you can export it to Excel and send it to colleagues that don’t have access to your org.

Here's the Row-Level formula referenced in the video:

IF(ISBLANK(TASK_SUBTYPE), EVENT_SUBTYPE, TASK_SUBTYPE)

Watch it here: https://www.21knots.com/resources/url-driven-activity-report

Enjoy!

#Reports & Dashboards #URL Hack #Account #Bar Chart

Create a URL-Driven Salesforce Activity Report!

This How-To will provide the foundation to generate any URL-driven report on any of your objects’ record pages. All this with the click of a button.

By implementing this feature, you can remove the Activities component from your Salesforce page layout, improving your record’s load time.

You can replicate what you will learn here in your contacts or your leads, and…given it’s a native Salesforce report, you can export it to Excel and send it to colleagues that don’t have access to your org.

Here's the Row-Level formula referenced in the video:

IF(ISBLANK(TASK_SUBTYPE), EVENT_SUBTYPE, TASK_SUBTYPE)

Watch it here: https://www.21knots.com/resources/url-driven-activity-report

Enjoy!

#Reports & Dashboards #URL Hack #Account #Bar Chart