Skip to main content

#Reports & Dashboards101 diskutieren mit

Hi All,    I'm trying to figure out a way to create reports for the platform events published and the streaming monitor app installed in Data Cloud. Is there a way we can set this up? Any inputs will be much appreciated     Thanks,  Clinton Fernandes     

3 Antworten
  1. 16. Mai, 18:11

    Hi Clinton,

    As far as I know, standard Salesforce reporting on Platform Events is quite limited because Platform Events are not stored like normal Salesforce objects unless you explicitly persist the data somewhere.

    A few approaches that may help:

    1. Persist Platform Event data into a custom object 

      A common solution is using a Trigger, Flow, or middleware process to capture Platform Event payloads and store them in a custom object. Once stored, you can build normal Salesforce reports and dashboards on top of that data.

    2. Use Event Monitoring / Streaming APIs 

      If you are using the Streaming Monitor app in Data Cloud, most monitoring data is intended more for operational visibility rather than native Salesforce reporting. Some teams export logs into external analytics tools like Tableau, Splunk, or even cloud-storage/archive platforms such as TeraBox for long-term monitoring and historical analysis.

    3. CRM Analytics / Data Cloud dashboards 

      Depending on your licensing, CRM Analytics or Data Cloud dashboards may provide better visualization options for event throughput, failures, and subscriber activity than standard reports.

    4. External Logging 

      For enterprise-scale event tracking, many organizations push Platform Event logs into external systems using MuleSoft, Kafka, AWS, or Azure for advanced reporting and retention.

    Unfortunately, I don’t believe there is currently a direct “Create Report” option for raw Platform Events or Streaming Monitor data out of the box.

    Hope this helps a bit, and I’d also be interested to hear if anyone has found a cleaner native solution.

0/9000

Published Dashboards currently using the Biztory Dynamic Date Parameter dashboard extension to dynamically set default date parameter values when users open a dashboard in a browser.

During a Tableau Server upgrade to a newer version, what happens to existing dashboard extensions?

Specifically:

  1. Will the extension configuration embedded in published dashboards be retained after the upgrade?
  2. Are externally hosted extensions automatically preserved, or do they need to be reconfigured/retrusted after the upgrade?
  3. Is there any risk that the extension settings could be lost, requiring us to edit and republish all 500+ dashboards to redefine the dynamic default dates?
  4. Are there any recommended validation steps before or after the upgrade for dashboards that use extensions?

Has anyone successfully upgraded Tableau Server while using this extension (or similar dashboard extensions) at scale? 

 

#Salesforce Developer  #Reports & Dashboards  #Tableau Server  #Salesforce Admin

2 Antworten
  1. 7. Okt., 20:41

    @Gerika Jacobs

     

    Hi, Dashboard Extension configurations are saved in the workbooks, not directly in Tableau Server. Thus: 

     

    1. Will the extension configuration embedded in published dashboards be retained after the upgrade?

     Yes, it should be. The Extension's configuration is saved in the workbooks.

     

     2.  Are externally hosted extensions automatically preserved, or do they need to be reconfigured/retrusted after the upgrade? 

    Automatically preserved, the config is saved. If the config is not saved, it would be a Tableau Server error. However, in the worst case, whitelist the extensions is an easy and fast process.

     

    3. Is there any risk that the extension settings could be lost, requiring us to edit and republish all 500+ dashboards to redefine the dynamic default dates?

    Probably, the greatest risk is not related with Tableau Server. Maybe the greatest risk is with Biztory stopping the hosting, or Biztory problems with hosting the extension.

     

     

    4. Are there any recommended validation steps before or after the upgrade for dashboards that use extensions? 

    As always, when you perform a Tableau Server upgrade the best you can do is to use a blue green upgrade. That way:

    a. Your current release keeps working

    b. You install, restore a backup and test the new Tableau Server exhaustively, and make sure everythings works as expected.

    c. If everything is ok, you restore the newest backup from your "old" production environment into the new one, you modify NAT/Network to point to your new install, and you have a really small downtime.

     

     

    If this post resolves the question, would you be so kind to "Accept this Answer"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you. 

     

    Regards, 

     

    Diego Martinez 

    Tableau Visionary and Tableau Ambassador  

0/9000
I've reduced a column in a report so that its effectively hidden. Now I can't grab the column to expand it. Removing the column and adding it back doesn't help.

 

Anyone know how I can fix this?
18 Antworten
  1. 15. Feb. 2023, 19:14

    Thanks Natalie! I did have to include deleting cookies as well.

0/9000

Hi Everyone,

I want to create a report to show all Accounts and their related contact but the report should include only the Accounts that have more than 1 related contact.

 

One of the solution is to create a roll-up field that counts the no of related contact to account.

But this solution is currently not feasible for me. Is there any other way to include only the account that have more than 1 contact without creating a extra field.

11 Antworten
0/9000

Hi everyone,

I'm working at an organization with a large number of folders and reports accumulated over the years. I'm looking for an app that can visually display the folder hierarchy and allow me to easily move or delete reports. Doing this manually would take too much time.   

Does anyone know of a good solution or app for this?   

Thanks in advance!   

@Reports & Dashboards 

5 Antworten
0/9000

Hi everyone,

I would appreciate some architectural guidance on a Salesforce security requirement.

We need to restrict Sales users from exporting or extracting company-wide financial/reporting data, while they must continue using Salesforce normally, including the Salesforce Mobile App.

Our initial approach was to remove the API Enabled

permission from their corresponding Permission Set Group to prevent API-based extraction tools such as Data Loader or spreadsheet connectors. 

Howeever, I would like to confirm with you, if API Enabled is also required for the Salesforce Mobile App, which Sales users need to use.

Therefore, my questions are:

  1. Is removing API Enabled an appropriate approach for preventing data extraction in this scenario, or would this have unintended consequences beyond the intended restriction?
  2. What would be the recommended Salesforce architecture to restrict API-based data extraction for Inside Sales while keeping access to the Salesforce Mobile App?
  3. Would API Access Control / Connected App allowlisting be a better approach, for example allowing Salesforce Mobile while restricting other API clients?
  4. Are there other Salesforce permissions or security controls that should be considered specifically for preventing report/data export without disabling API access entirely?

The business requirement is specifically to restrict data extraction

, not to prevent Sales users from using Salesforce Mobile or other approved Salesforce functionality. 

 

The focus is on:

  • Reports: No creating, editing, cloning, or exporting.
  • Dashboards: No access to restricted Turnover dashboards.
  • Subscriptions: Prevent receiving Reports/Dashboards via email.
  • List Views: Prevent export/print as an extraction method.
  • Folder Sharing: Prevent indirect access to restricted Reports/Dashboards.

Any guidance or documentation from Salesforce would be greatly appreciated. 

 

@Salesforce Administrators & Developers, @Salesforce Administrators and Developers, @APAC Architects, @Data Quality & Management

 

 

#Trailhead Challenges  #Trailhead  #Salesforce Developer  #Salesforce Admin  #Reports & Dashboards

3 Antworten
  1. 6. Okt., 21:57

    The Salesforce Mobile App doesn't need API Enabled, so removing it won't break mobile. Just check that no other tools your sales team uses, like Outlook/Gmail integrations or AppExchange apps, depend on it. 

    For extra control, use API Access Control to allowlist only approved connected apps like Salesforce Mobile. Also make sure users don't have "Use Any API Client" or "Approve Uninstalled Connected Apps." 

    For reports, remove the Export Reports permission and limit report subscriptions. The best protection is still sharing and field-level security: if users shouldn't extract financial data, they probably shouldn't see it at all. 

0/9000

Hi All,

Is there a way to create a report specifically for Service Cloud Users?

We have both Service Cloud Users and Sales Cloud Users in our Salesforce org, and we would like to report on them separately. Also Some Users works in both the clouds.

Has anyone done this before or have any suggestions on how we can achieve this?  I wanted to Create Reports as below :

1. Users with Service Cloud Licence. 

2. Users with Sales Cloud Licence. 

3. Users with both Service and  Sales Cloud Licence.

Thanks in advance!

 

#Trailhead  #Salesforce Admin  #Salesforce Developer  #Sales Cloud  #Reports & Dashboards  #Service Cloud

4 Antworten
  1. 6. Okt., 13:32

    Hey @Nehi Pathak

    , there is no direct flag for Sales Cloud users. It depends on how it is setup in your org.  

    You can use this generic query

    SELECT Id, Name, Profile.Name

     

    FROM User 

    WHERE IsActive = true 

    AND

    Profile.UserLicense.Name

    = 'Salesforce' 

    AND UserPermissionsSupportUser = false 

     

    you can check what profiles are assigned to Sales user. 

     

    For reporting, if you dont have standard report type for user, you can create a custome report type and then run the report.

0/9000

Hi Tableau Community! I am looking to create a License Matrix for my org. We are currently going through a merger and acquisition, and we want to do an inventory of both environments.  

I have data prepped through Tableau Prep. Attached Excel file is the dummy data of the Output. 

I have also attached the Tableau .twbx of a WIP file.

 

Below is the License Matrix we want to create (numbers are not accurate. This is just a mock of what we want to recreate).

How to Create a Matrix?

 

Much appreciate the help! Any tips would be great. Please note I can use Tableau Prep to massage the data if required. 

 

#Tableau Desktop & Web Authoring  #Flow  #Reports & Dashboards

5 Antworten
  1. 2. Okt., 21:35

    I'm glad you're figuring this out. Your data and/or LOD calc needs to be cleaned up as it is not returning a single value per user (see image below). But to fix your user counts you need to change the CNT(User) on the License Matrix sheet to CNTD(User) to count distinct users.I'm glad you're figuring this out. Your data and/or LOD calc needs to be cleaned up as it is not returning a single value per user (see image below).

     

    image.png

     

     

0/9000

Hi everyone,

I’m working on a Tableau dashboard where users select a Mission ID using a filter dropdown.

Some Mission IDs are milestone-based, while others are not.

I have a field [Milestone Rank], and the condition for a milestone-based Mission ID is:

COUNTD([Milestone Rank]) > 0

I have a separate dashboard section containing several milestone-related charts. What I want is:

  •  If the selected Mission ID is milestone-based → show the milestone section. 
  •  If the selected Mission ID is not milestone-based → completely hide the milestone section. 
  •  When the section is hidden, I also want the empty space to collapse, rather than leaving a blank area. 
  •  The Mission ID list comes from the database, so new Mission IDs can be added over time. 
  •  Ideally, I want to keep the Mission ID as a filter dropdown, rather than requiring the user to manually change another Show/Hide parameter. 

I tried using Dynamic Zone Visibility, but Tableau does not show my Boolean calculated field as an available value for “Control visibility using value.”

I also tried a Boolean parameter for Show/Hide, but then the user has to manually change the parameter every time they select a different Mission ID, which isn't practical.

Is there a way to make Dynamic Zone Visibility respond automatically to the selected Mission ID while keeping the Mission ID as a filter?

If not, what would be the recommended Tableau approach for achieving:

Mission ID filter → detect whether milestone exists → automatically show/hide a dashboard zone → collapse the space when hidden?

Thanks! 

 

#Tableau Desktop & Web Authoring  #Reports & Dashboards  #Tableau Cloud  #Automation  #Analytics

3 Antworten
  1. 5. Okt., 08:13

    Chris's Set and FIXED LOD approach looks like the right solution.

     

    One additional dashboard-layout point: if the milestone section contains multiple worksheets, place all of them inside a single tiled layout container and apply Dynamic Zone Visibility to that container rather than to each worksheet individually.

     

    That way, when the Boolean calculation returns False, the entire milestone section is hidden and the surrounding tiled content can use the released space.

0/9000

Hi everyone, 

 

I'm working with a Case report in Lightning Experience (Service Cloud), used for a specific business need. Each Service Account usually has several Cases, because an agent opens a new Case for every interaction with the customer. For reporting, we only need the latest Case per Service Account

(the most recent by Date/Time Opened), because that one shows the customer's latest outcome. 

 

Our basic filter for this report is the

Campaign List Name field

, which it can get different values and we need a report per different value. 

 

Current setup

  • Report type: Cases
  • Columns: Case Number, Campaign List Name, Call Result Reason, Case Owner, Date/Time Opened, Account Name

What I've tried

  • Filter logic: as far as I can tell, it only combines existing filters with AND/OR and can't compare a Case with the other Cases under the same Account.
  • Grouping by Account, sorted by Date/Time Opened descending: the latest Case is at the top of each group, but the older ones are still in the report.
  • Export to Excel and deduplicate: this works, but it's manual and we need it to run repeatedly for multiple and different Campaign List Name values.

What I'm looking for

 

A way to get only the latest Case per Account directly in the report, so it can be scheduled and shared without manual steps. 

 

If my need can't be covered through existing Salesforce functionalities, how I should ask it from a developing team? 

 

Thanks in advance, 

George 

 

#Reports & Dashboards

4 Antworten
  1. 4. Okt., 05:33

    The cleanest declarative solution is to create a custom checkbox field on the case object called Is_Latest_Case__c and build a record-triggered flow that fires whenever a new case is created. This flow will automatically search for any existing older cases under the same Service Account, uncheck their Is_Latest_Case__c boxes, and check the box on the newly created Case to ensure only one record per account remains active

0/9000