Skip to main content

#Event0 utenti parlano di questo argomento

Hello Everyone ,

 

I need your help to achieve one task. Please refer below details for problems.

 

I want to apply filter on particular column and the same time I need not allow filter to other column.

 

I have attached .twbx file and also image which help to identify problems.

 

I have one filter which is Activity status and need to fixed this filter for month and Hours column and allow to filter data for event column based on activity status selection.

If Event value is not available then we need put 0 or NULL values against month.Month and Hour value should be fixed at any instances.

 

This would be the desired output when we selected expected Shutdown all other row should be there in the solution but  event value is zero.

 

Any help would be appreciable.

 

Thanks

Saumil Shah

8 risposte
  1. 16 mag 2018, 00:40

    Hi Saumil,

     

    I don't believe it is possible to achieve what you are looking for using filters in one data source. However, there is a workaround with parameters. Parameters are not multi-selectable, so that may be a trade-off you will be willing to accept.

     

    Step 1: Create parameter [Select Activity Status]

    Hi Saumil, I don't believe it is possible to achieve what you are looking for using filters in one data source. However, there is a workaround with parameters.

    Right click on the parameter and select 'Show Parameter Control'

     

    Step 2: Create calculated field [# Events]

    IF [Select Activity Status] = "All" THEN [Events]

    ELSEIF [Select Activity Status] = [Activity Status] THEN [Events]

    ELSE 0 END

    Use this field in your view instead of the original [Events]

     

    See attached workbook. Hope this helps.

    Ossai

     

    pastedImage_3.png

     

    pastedImage_4.png

     

    pastedImage_6.png

0/9000

Hi community,

 

ran into a little problem here.I am trying to calculate the % of events an attendee has attended ever since he 1st joined. Any events that happened before he first joined is obviously ignored.

how can i write a calculated measure to count the number of events that happened after an attendee has joined. that way i can calculate the % attended.

Attached is the workbook. I've only managed to get the number of events an attendee has attended but the number of events that happened after 1st engagement turns out to be the same value which is obviously wrong.

appreciate any comments or help if you know.

thank you so much.

14 risposte
  1. 2 mag 2020, 08:53

    You are right Gavin.  I forgot to put the join back correctly when I played with it   I could not open 2020 ver, so I ended up extract your CSV file.

     

    Let me know if you have any question and stay safe!

0/9000

I'm trying to make a slack app and am struggling to save part of an api response as a local variable.

This is my code:

```

import os

import re

import time

from dotenv import load_dotenv

from slack_bolt import App

from slack_bolt.adapter.socket_mode import SocketModeHandler

 

load_dotenv()

#loading env variables

SLACK_APP_TOKEN = os.environ["SLACK_APP_TOKEN"]

SLACK_BOT_TOKEN = os.environ["SLACK_BOT_TOKEN"]

 

app = App(token=SLACK_BOT_TOKEN, name="SlackApp")

 

@app.message(re.compile("^."))#event listener listens to messages matching a wildcard regular expression

def reply(message, say):

print("Message :"+message["text"])

print("Recieved @:"+time.ctime())

 

#job title check

userid = message["user"]

userinfodict = app.client.users_info(

user=userid

)

print(userinfodict)

```

 

This returns an output of:

 

{'ok': True, 'user': {'id': 'U03PMCY1BUG', 'team_id': 'T03NH2KCQA3', 'name': 'John Doe', 'deleted': False, 'color': '9f69e7', 'real_name': 'John Doe', 'tz': 'America/New_York', 'tz_label': 'Eastern Daylight Time', 'tz_offset': -14400, 'profile': {'title': 'Business Analyst', 'phone': '', 'skype': '', 'real_name': 'John Doe', 'real_name_normalized': 'realfakename', 'display_name': '', 'display_name_normalized': '', 'fields': None, 'status_text': '', 'status_emoji': '', 'status_emoji_display_info': [], 'status_expiration': 0, 'avatar_hash': 'gb8c5320087d', 'first_name': 'John', 'last_name': '', 'image_24': 'https://secure.gravatar.com/avatar/b8c5320087d1218227d9c8f54866a381.jpg?s=24&d=https%3A%2F%2Fa.slack-edge.com%2Fdf10d%2Fimg%2Favatars%2Fava_0014-24.png', 'image_32': 'https://secure.gravatar.com/avatar/b8c5320087d1218227d9c8f54866a381.jpg?s=32&d=https%3A%2F%2Fa.slack-edge.com%2Fdf10d%2Fimg%2Favatars%2Fava_0014-32.png', 'image_48': 'https://secure.gravatar.com/avatar/b8c5320087d1218227d9c8f54866a381.jpg?s=48&d=https%3A%2F%2Fa.slack-edge.com%2Fdf10d%2Fimg%2Favatars%2Fava_0014-48.png', 'image_72': 'https://secure.gravatar.com/avatar/b8c5320087d1218227d9c8f54866a381.jpg?s=72&d=https%3A%2F%2Fa.slack-edge.com%2Fdf10d%2Fimg%2Favatars%2Fava_0014-72.png', 'image_192': 'https://secure.gravatar.com/avatar/b8c5320087d1218227d9c8f54866a381.jpg?s=192&d=https%3A%2F%2Fa.slack-edge.com%2Fdf10d%2Fimg%2Favatars%2Fava_0014-192.png', 'image_512': 'https://secure.gravatar.com/avatar/b8c5320087d1218227d9c8f54866a381.jpg?s=512&d=https%3A%2F%2Fa.slack-edge.com%2Fdf10d%2Fimg%2Favatars%2Fava_0014-512.png', 'status_text_canonical': '', 'team': 'T03NH2KCQA3'}, 'is_admin': True, 'is_owner': True, 'is_primary_owner': True, 'is_restricted': False, 'is_ultra_restricted': False, 'is_bot': False, 'is_app_user': False, 'updated': 1659555324, 'is_email_confirmed': True, 'who_can_share_contact_card': 'EVERYONE'}}

```

 

How do I save a part of this output as a local variable? In particular the job title:

 

```

...'profile': {'title': 'Business Analyst',...

 

```

 

It is not a dictionary, it is of type: <class 'slack_sdk.web.slack_response.SlackResponse'>

How do I iterate though this response and save as a local variable?

1 risposta
  1. 29 lug 2023, 18:06

    Hi @Stephen Cronin​, I don't know python but since Slack is returning you a JSON format it should go like this:

    response.user.profile.title - to get the title value

    response.user.profile - to get the whole section started as 'profile' and so on.

0/9000

Hi Folk's..

I have a requirement where i had implemented using LOD expression .. now i want to know if there is any other way to achieve. Someone can assist me on this below requirement

Dashboard to be considered in Weekly Agg data level analysis. My self used a LOD followed by {FIXED ID, Week: COUNTD(Event_Dt)} As ⌗Event.

 

Now using ⌗Event calculation.. I'm calculating event count followed by ⌗1Event, ⌗2Events, ⌗3Events followed by calculation ..

⌗1Event = COUNTD(if [entry ]= 1 then 1 else 0 END)

⌗2Events = COUNTD(if [entry ]= 2 then 1 else 0 END)

⌗3Events = COUNTD(if [entry ]= 3 then 1 else 0 END)

 

Alternate approach for LOD implementation For Weekly Aggregated with ID wise CountPFA for some data similar data in it.

 

Regards, Sai.

1 risposta
0/9000

📢 Exciting update!

 

Due to overwhelming demand, we've opened up more seats for our upcoming In-Person event: "Architects Meetup - Autumn Edition" where we dive into the world of #SalesforceOMS (Order Management System)

 

Don't miss out—secure your spot by clicking the link - Architects Meetup - Autumn Edition

 

#salesforce #architect #community #event #trailblazercommunity #trailblazer

Lars Malmqvist Kristian Margaryan Jørgensen

0/9000

📅 Save the date: Wed, Nov 22, 5:30 PM (CET)

 

📢 I'm delighted to share that I have taken on the role of Co-Leader of the Salesforce Architect Group, Copenhagen (Denmark), collaborating with my experienced co-leader Kristian Margaryan Jørgensen.

 

To mark my debut as the co-leader, we are thrilled to announce the next In-Person event: Architects Meetup - Autumn Edition

 

Be prepared to dive into the world of #SalesforceOMS#SalesforceOMS (Order Management System) with me as your guide on a journey to explore the art of architecting with Salesforce OMS.

 

We are also honored to have guest speaker Lars Malmqvist, who will inspire us with his invaluable thoughts & and insights.

 

But that's not all! We've also got an exhilarating quiz in store for you, with the chance to win fantastic #Swag#Swag and showcase your expertise!

 

Don't miss out on this golden opportunity. Secure your spot now!

✍️ Sign up here: Architects Meetup - Autumn Edition

 

#salesforce#salesforce #architect#architect #community#community #event#event #trailblazercommunity#trailblazercommunity #trailblazer#trailblazer

0/9000

⌗datapluswomen Zurich is back!

 

Our next ⌗datapluswomen event on June 28, 2023, 6PM, is all about Exasol. Join us for our next ⌗datapluswomen event with two talks by :

 

- Helena Schwenk, VP, Chief Data and Analytics Office at Exasol, who will talk us through her career journey from "Demand to Supply using the Power of Influence", 

 

- Denise Lubaway, Enterprise Account Executive at Exasol, who will show us how to use Exasol to achieve better performances in Tableau in a talk called "Same Tableau. Unsurpassed Performance. Here’s How.".

 

This is also a great opportunity to network and ask questions to our ⌗exasol experts.

 

Sign up here

:

https://lnkd.in/eZa6Ekmy

⌗data #tableau #career #opportunity ⌗event #analytics

Olivia Sliz

lnkd.in

0/9000

Happy to share the wrap-up of yesterday's virtual event. The topic was MuleSoft's Automation Everywhere Bundle and we were fortunate to have Joey Chan (Salesforce MVP, 26X certified). Joey gave a great presentation of MuleSoft and the Automation Everywhere Bundle - and did a LIVE (🙌) demo of MuleSoft Composer. -> The session was recorded and you may find it on Youtube: https://youtu.be/3TSldbDBPuI Thanks a lot to Joey and to all who attended and engaged! ➡ Reminder: Our next in-person event with lots of great speakers is happening on January 23rd - sign-up here: https://trailblazercommunitygroups.com/events/details/salesforce-salesforce-architect-group-copenhagen-denmark-presents-in-person-meeting-2023-group-kick-off/ - All aspiring and seasoned Salesforce architects are welcome! #salesforce #trailblazer #architect #community #event #MuleSoft

0/9000

Excited to share the next virtual event:

🗓️: January 7 @ 10:00 AM CET

🎯: "Introduction to MuleSoft's Automation Everywhere Bundle"

🧠: Joey Chan, Salesforce MVP, 26x certified

-> To register, please RSVP on the event page ✅

https://trailblazercommunitygroups.com/events/details/salesforce-salesforce-architect-group-copenhagen-denmark-presents-we-are-hosting-joey-chan-salesforce-mvp-to-introduce-mulesofts-automation-everywhere-bundle/#salesforce #architect #community #event #trailblazercommunity #trailblazer #MuleSoft
0/9000