-
1. Re: Displaying the results in tabular form using custom SQL
Are you seeing forecast and count in your side bar?
Try adding them to your rows shelf as discrete measures. If that doesn't work, feel free to attach a workbook with real or sample data and I'm sure someone can help you.
-
2. Re: Displaying the results in tabular form using custom SQL
Yes, I see the forecast and count in the side bar. The data is brought into tableau using custom SQL connecting to reporting server ,so even if I attach the workbook I don't think so you will be able to see the data.
-
3. Re: Displaying the results in tabular form using custom SQL
Dylan,
I tried as you said, but it ended up like this. Instead it should be 1413 value for BS and Forecast as shown in my original post.
Name Total Forecast Count A S 987 345 377 B S 667 345 377 C S 677 345 377 -
4. Re: Displaying the results in tabular form using custom SQL
I would recommend posting a sample workbook, like Dylan mentioned, or a screenshot of the Tableau setup. It would help to see what might be happening to allow everyone to better troubleshoot the problem.
-
5. Re: Displaying the results in tabular form using custom SQL
Dylan/Caitilin
Have attached a screen shot. I have blacked out the values for BS,OS and PS. The first column as the names BS,PS and OS. The 2nd column has the values of BS,PS and OS which i have blacked out.(all there are present in measures side bar. Now I should bring a 3rd column where the values of PBS,PRS and PES which is available in measures, should be displayed next to the 2nd column.
Any help is appreciated.
-
6. Re: Displaying the results in tabular form using custom SQL
Sabitha,
we are going to need some more information on this one. The last error you described looks like blending, so I think you've gone down the wrong path.
You are using custom sql, but could you show at least a mock-up of what the original data looks like, as well as what custom sql you are using? If we modify that, creating the view will be a piece of cake.
Andrew
-
7. Re: Displaying the results in tabular form using custom SQL
Ok, you are wanting a cross-tab of measures vs measures. This is definitely not the right route. You should have "Name" (your first column) as a dimension with 3 members.
-
8. Re: Displaying the results in tabular form using custom SQL
Based off how your data is structured, what you want to do would probably need to be done in multiple worksheets and then placed on a dashboard together. Generally to do what you need to do in one worksheet, the original data would look like how you laid it out in your initial post. There would be 3 columns, the names, the total, and the forecast. The names (BS, OS, PS) would be a dimension. The total would be a measure that Tableau could sum, average, however you would need to aggregate the data. Forecast could be a dimension or a measure, depending on whether you want that to be static (dimension) or dynamic (measure). The count could be found by creating a calculated field (something like COUNT([Names])).
-
9. Re: Displaying the results in tabular form using custom SQL
Hi Andrew,
Since it is real-time data, I will not be allowed to share them. Can you share your views on cross-tab of measures vs measures? My custom sql, is a select query which brings the names (BS,OS,PS) is it possible to change them as "Name" (the first column) as a dimension with 3 members?
-
10. Re: Displaying the results in tabular form using custom SQL
Hi Sabitha,
Could you share the database schema? I don't need to actually see real data (you could always mock some up), but the field names are important.
Also, could you share the actual SQL you are using? The best way of doing this will depend on your starting position.
-
11. Re: Displaying the results in tabular form using custom SQL
Andrew I can mock them and send for reference, but as of now I just want to know is it possible to display the results in tabular form (shown in original post) by using custom SQL?
