Skip to main content

#Tableau Prep22 debatiendo

I have 3 custom SQL's , they are all same queries but due to some filter conditions , i need to separate them into 3 custom SQL's rather than a single Custom SQL,. Is it possible to Union these 3 custom SQLs in tableau  Desktop?  They are from  the same database connection. Thanks

 

#Tableau Desktop & Web Authoring

 

#Tableau  #Tableau Cloud  #Tableau Prep

1 respuesta
  1. Hoy, 1:15

     

    I am combining the 3 custom SQLs  like this in the screenshot with full outer join. Does this work ??  The queries from the same DB and they are similar data but each custom has some slightly different filter considtions, so i want to union all these 3 Custom SQLs.   

     

    I am combining the 3 custom SQLs like this in the screenshot with full outer join. Does this work ??

     

     

0/9000

Hi, 

I have a Date filter, Month and year, i am showing the last month filter ex: showing the July 2026 data in Aug 2026 month , meaning previous month, if i use the relative filter as previous month in the filter, will the filter in the date(MY Month) will automatically change when month is changed ?? using this relative filter previous month automatically change the filter value in the next month, ex: Sep, it will automatically select the aug 2026 data when month starts. Anyone please clarify, Thanks 

Last month default to dashboard and month filter has to be changed automatically

 

 

 

#Tableau Desktop & Web Authoring  #Reports & Dashboards  #Tableau  #Formulas  #Tableau Prep

6 respuestas
  1. 8 ago, 0:32

    This can be done by creating the below calculation, using LOOKUP() function:This can be done by creating the below calculation, using LOOKUP() function:For now, both July and August are in the view just so you can see that July's data for Quantity now lives in August's 'date'For now, both July and August are in the view just so you can see that July's data for Quantity now lives in August's 'date', as shown above.  But, we don't want to have to select two month's data at a time and yet, two month's of data MUST be in the view. somehow.  Screenshot 2026-08-07 at 5.18.22 PM.png

     

    So, we then change the Order Date filter that you originally had into again, a Relative Date filter, again displaying only most recent two months, as I did before:

    Screenshot 2026-08-07 at 5.19.54 PM.png

     

    Then, the question remains, how to show just the current month, but only with last month's data in the current month.  Again, another filter.  BTW, both of these are Table Calculations, so certain fields must be in the view somewhere in order for them to all function correctly and display correctly.  The new calculation will now filter the above result to only the last row in the view:

    Screenshot 2026-08-07 at 5.20.33 PM.pngIt is placed onto the Filters Card and in the dialog that pops up, it is set to TRUE.  So that you end up with a single row of data displaying the most current month's 'date' with the prior months 'data':Screenshot 2026-08-07 at 5.20.58 PM.pngExample workbook attached.  Again, these are table calculations, meaning they can be challenging to work with.  So, if you add additional dimensions, certain settings might need to be adjusted depending on what you end up actually doing with this method - that is accomplished by right-clicking the table calculation in the view and selecting Edit Table Calculation.

      

     

    As to it being automatic and adjusting for next month, it should based on the Relative Date filter..it would automatically adjust to September and pick up August's data. And so on. 

     

    If this response answered your question, please mark it as an Accepted Answer? 

    This way, others searching for similar solutions will find the answer faster in the future.

     

    Best, Don Wise (Tableau Ambassador)

0/9000

I've installed Tableau Desktop free trial and I would like to get the file in order to follow along the sample Excel file used for this Trail  

Thanks in advance it is about furnitures (office, etc;;;) 

 

#Tableau Desktop & Web Authoring  #Tableau Prep

3 respuestas
  1. 9 ago, 17:32

    Are you looking for the attached, Superstore dataset? 

     

    If this response answered your question, please mark it as an Accepted Answer? 

    This way, others searching for similar solutions will find the answer faster in the future.

     

    Best, Don Wise (Tableau Ambassador)

0/9000

I get the error "An error occurred while communicating with the data source all inputs to union must have matching column types" when running my flow. I was using it without problems all 2024, but now I modified it because I had a date filter (show only 2024) that I needed to update. I even rolled back my filter but keep getting the error. Talked to the DB administrator and he says they haven´t made any changes to sources (variable names, columns, DB types). Is it a known error? Please help.

 

PS: I get the error in desktop and in web.

3 respuestas
  1. 5 ago, 21:02

    For me it was that one of my tables in the union had a spatial column and the other one didn't. Once I removed the spatial column it worked. 

0/9000
Venkat M ha preguntado en #Tableau Agent

Hi Team, 

Requirement: Display data dynamically based on the selected Period Type parameter

  • Day
    • When the user selects Day in the Period Type parameter, the Order Date parameter should display all available dates.
    • The most recent available date should be selected by default.
  • Week
    • When the user selects Week, the Order Date parameter should display only the Monday date of each available week (e.g., 27-Jul-2026, 20-Jul-2026, 13-Jul-2026).
    • Upon selecting a week, the report should display data for the entire Monday-to-Sunday period corresponding to that week.
  • Month
    • When the user selects Month, the Order Date parameter should display all available months.
    • The latest available month (e.g., Jul-2026) should be selected by default.
  • Quarter
    • When the user selects Quarter, the Order Date parameter should display all available quarters.
    • The latest available quarter (e.g., 2026-Q3) should be selected by default.
  • Custom Dates
    • When the user selects Custom Dates, the following parameters should be displayed: 
      • Start Date
      • End Date
    • Report data should be filtered based on the chosen date range.
  • Lifetime
    • When the user selects Lifetime, all available data should be displayed without applying any date filters.
  • #Tableau Agent

#Tableau Desktop & Web Authoring  #Tableau Server  #Tableau Cloud  #Tableau Public  #Tableau  #Tableau Prep  #Tableau Community Updates

5 respuestas
0/9000

I've noticed that the values in a Pivoted Fields (Rows to Columns) function does not refresh its values to pivot on when the underlying data changes. I have a monthly dataset update that I need to pivot on the month field. I always have to remove the selected column and add it again for the function to correctly read the new values. Is this a bug? 

 

#Tableau Prep

2 respuestas
  1. 30 jul, 10:45

    @Jes Hunsballe

    not sure yet about it being a bug.   

     

    There is a Refresh 'button' that I'd use to first update the underlying data in Tableau Prep, then I'd step into the Output Step or for that matter the Pivot Step to ensure the data reflects the changes, go forward from there.  But no, you shouldn't have to remove then add the column to make that happen.

    not sure yet about it being a bug.

     

     

    If that's not the case, and you're continuing to see the issue after refreshing, then I'd consider opening a support case with Tableau. 

     

    If this response answered your question, please mark it as an

    Accepted Answer

    This way, others searching for similar solutions will find the answer faster in the future.

     

    Best, Don Wise (Tableau Ambassador)

0/9000

Hi Tableau Community,

I’m experiencing some challenges in combining data to create a hyper file, as I believe this would simplify the process of updating a 3-line chart with a new Excel worksheet each month. In Tableau Prep, one of the worksheets contains a unique column that differs from the others, which I need to retain for comparison purposes. However, when I connect it to Tableau Desktop, the data doesn’t read correctly.

Additionally, I’ve created a bar chart to compare the total number of documents (Actual Submission Total and Publish Date Total). However, it appears a bit unusual because all the months are displayed, which I suspect is due to the way the data is structured.

Could you please assist me with both of these issues?

Thank you! 

 

#Tableau Desktop & Web Authoring  #Tableau Prep

5 respuestas
  1. 23 jul, 15:09

    This latest response is unfortunately a ChatGPT post. Based on the number of responses overnight and through today, the effort might even be automated. We have a BAN on any A.I. posts due to the high error rate.  So, we're considering these posts as spam. Apologies for any inconvenience this may have caused.

0/9000

It seems like E-A-V architecture makes a lot of sense for our data, as different events have different properties, but I haven't worked with E-A-V database in Tableau before. It seems like it would create a mess of Joins, or I'd have to have a pretty over-the-top flow in Tableau Prep to shape it. Searching forums it doesn't look like there's much on using Tableau with Segment,io or E-A-V in general.

 

Does anyone have any thoughts or experience? What Database architecture would you use if not E-A-V, or how did you manage E-A-V with Tableau?

6 respuestas
  1. 23 jul, 15:06

    This latest response is unfortunately a ChatGPT post. Based on the number of responses overnight and through today, the effort might even be automated. We have a BAN on any A.I. posts due to the high error rate.  So, we're considering these posts as spam. Apologies for any inconvenience this may have caused.

0/9000

Hello,

I can't edit any flow directly on the server, yet I am the owner of the flow. When I click the edit flow button, I have the running icon running forever. The only way for me to update my flows is to download them, edit them on desktop and then upload. Any solution ?

Thank you

Unable to edit flows on server

4 respuestas
  1. 2 jul 2024, 4:38

    @Victor Lagrenaudie​  May I know your Tableau server version? Try below options and see,

    1. Clear your browser cache , cookies and try different browser.
    2. Ensure web authoring for flows is enabled on your Tableau server.
    3. Try creating any simple flow and try edit that and see.
    4. Try editing the flow in a different time when server is not busy.
    5. Disable any browser extension

     

    If none of the solutions didnt work, then please reach out to Tableau support for additional help.

     

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

0/9000
Ritik Raj ha preguntado en #Tableau Pulse

I have used fields from Tableau Prep Output in Tableau Pulse to configure Custom Calendar.  

Since 'Day of Year', 'Week of Year', 'Month of Year', 'Quarter', 'Year' must be of INT data type for pulse custom calendar, I have kept these fields as INT in prep flow. But I guess these f

ields are treated as Measures in flow because it is in INT format. And Pulse can't detect these fields as Dimensions

, hence I am not able to set-up custom calendar. How can I resolve this issue ? 

While in extract it is working perfectly as we can convert these fields to Dimensions! 

 

#Tableau Pulse  #Tableau Prep

5 respuestas
  1. 29 jun, 7:12

     Edit the published datasource directly in tableau cloud server move the fields from Measures to Dimensions, and over write the existing datasource instead of creating a new one. Future Prep flow runs will refresh only the extract, preserving your metadata changes. 

0/9000