Is it always "/RF"? If it always starts with a slash, you can say LEFT("Table"."Country", LOCATE('/',"Table"."Country")-1)

1 - You'll have to adjust the width and alignment settings for the dashboard sections and columns. Experience/trial-and-error are the best teachers, in this regard. 2 - You can put table C in a conditional section. You will have to have a separate condition query that will tell you if table C will have no values.

Yes, because you are trying to combine two records into one. Since column B (saw_2) is the shared column, each result column must will look like max(saw_1 by saw_2) or sum(saw_1 by saw_2). Keep in mind there will will still be two records for each Col B, so you'll need to work with pivot tables for presentations.

Thanks again, I'll ask the system administrator to dig into it.

Thanks, Gianni, In the old versions, you could see the complete file name there, and it was much more helpful than the current truncated banner.

That is the expected behavior for that kind of union. You can combine the record pairs into single lines either by using a pivot table that uses column B as the row definition, or use Result Columns that are calculated outside the union using the position of the columns. (saw_0, saw_1, etc.)

1. I believe you need a separate query for top customers, since TOPN acts like a filter, you can't have both in the same query. 2. Instead of TOPN(Profit Amt, 5 by Month), your formula would look like TOPN(SUM(Profit Amt by Merchant,Month), 5 by Month)

You can use either the TOPN function or the RANK function to identify or isolate the top 5 performers. A column would look something like TOPN(Profit Amt, 5 by Month). This is assuming Profit Amt is aggregated at the merchant and month level.

1. The formula for a null column is CAST(NULL AS datatype), usually with datatype=DOUBLE for numeric columns. 2. You need a separate column with a formula that sums your values by year only. SUM(values by year)

Actually, since Line-Bar charts place the data marker above each bar, you can simply use a null column for the line value,, as I did here:

This is a line-bar chart. I created a Totals column, then set the line format to 0px width so it wouldn't show. Then, I offset the line axis by 5 units, as you can see on the left-hand chart below, so the data marker for totals wasabove the other data markers. The right-hand chart is the final product, with the scales…

It's shown under "Recent" because it was one of the latest dashboards that you looked at. It will no longer appear under the "Dashboards" drop-down at the top of your home page.

I can't see your link, either. You can use a variable prompt, perhaps with radio buttons for USD or EUR. The choice will be a pres variable, say P_CURR. In your analysis, include a case statement column like CASE '@{P_CURR}{USD}' when 'USD' then '$' when 'EUR' then '€' , etc. Use a formatted narrative view for your title…

I believe you need to move the filter function inside the Count Distinct formula. If that doesn't work, A case statement like CASE WHEN "...Common OU Opportunity Flag" = 'Y' then 1 ELSE 0 END always works.

My answer is only based on experience. I haven't looked at that particular documentation in quite a while, but if it is a little misleading, I wouldn't be shocked.

Hi Marc, When using "Navigate to a web page", you have to explicitly include all of the columns you wish to pass. In your prompted url, you'll need a val, col, psa triplet for Org Code as well as Resource group. Jerry

Hi Regis, By naming the subject area, I assume you're using OTBI? We don't know your data models. But your formula looks like it should be: CASE WHEN "Salary Basis"."Salary Basis Name" ='USHOURLY' THEN "Salary History"."Salary Amount" * "Worker"."Normal Working Hours" * 26 (of course, you also need ELSE and END clauses).…

That is exactly what I showed you except my original had an extra dimension. My "Count(Crash ID)" column is the frequency of occurrence of "Type". After adding the TOPN column, the COUNT column is showing the max frequency of occurrence of Type by DOM. Maybe this is clearer: I don't include a column for "Crash ID" itself…

You are showing accurate counts in that example. To address your original question: If I have data that looks like this: Adding a TOPN column will serve as a filter on the query, and return only the rows that have the highest count:

COUNT is an aggregate functions applied to Col B, so if you include Col B in the result, the Count of any one row will be 1. Remove Col B from the query to see the aggregate result. Refer to the field name of Col B in the formula, only.