Skip to main content

#Screen0 discussing

Hi Guys,

 

I am new to tableau and need on you suggestion on how to compare data between current and previous weekend.

Below is the source data format -

 

Week Start DateTerritory# Locations# Screens7/2/2015Argentina1007/9/2015Argentina057/16/2015Argentina797/23/2015Argentina437/3/2015Singapore1007/10/2015Singapore057/17/2015Singapore797/24/2015Singapore43

 

Week Start Date is always on a Thursday in source system. This is when the current week's data is added.

In the report I need - The user only see this format everytime this report is refreshed in future.

                         Previous Weekend          Current Weekend

Territory          # Location     # Screen       # Location     # Screen

Argentina               7                    9                    4               3

Singapore              7                    9                     4               3

 

Any suggestions will be very helpful. Will relative date work?

 

Thanks for your help,

JC

4 answers
  1. Sep 8, 2015, 6:54 PM

    Thank you Bora for the above solution. I wanted to one more question just for learning purpose -

     

    In the above example if I just create a filter of current week and prior week as status -

     

    IF [WEEK_START_DT] > DATE(DATEADD('day',-7,date(TODAY()))) AND

    [WEEK_START_DT] <= date(TODAY())

    THEN 'Prior Week'

    ELSEIF [WEEK_START_DT] > date(TODAY())

    THEN 'Current Week'

    END

     

    Will this work?

     

    Thanks for your help,

    Jitan

0/9000

Hi all,

 

I am making a #Screen flow where user will enter Postal code and House number in the first screen. When the contact gets updated Apex is run which calls a Postal code API and fills in the Street and City fields.

When the API doesn't get a result, then it fills an error field on Contact.

 

I want the flow to check if the error field is filled and if it is to show a next screen where Street and City can be entered manually. 

 

The problem is that the flow doesn't see that the error field is filled, presumably because it checks before the Apex has finished updating the record.

 

Do you have any idea how I could somehow delay the flow (1 second might be enough) and/or force it to pick the record after the Apex has finished?

 

Any help would be appreciated!

4 answers
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    Nov 22, 2023, 3:11 PM

    That's a bit of a toughie here if the APex is not called by the flow. Woudl it be possible to do so?

    Or, maybe you could add an HTTP Callout in your flow that would call the same API as the Apex class does. This way, you could see if there's an error with a Decision and redirect to a next screen where Street and City can be entered manually. 

0/9000
1 comment
0/9000

I want to know how to create a screenflow or lightning flow with a screen element that looks up an object using object parameters and displays the the object details on the screen.    Any help is appreciated. #Lightning Flow #Screen Flow

3 answers
0/9000