No, you wouldn't change the column formula. You'd change the filter to include whichever Fiscal Years you want. Use it as you would any existing-in-the-data model field. If you filter on case when MONTH("Table"."Date")<5 THEN YEAR("Table"."Date")-1 ELSE YEAR("Table"."Date") END IN (2020, 2021) you could then compare Fiscal…

I used the Month and Year functions to create the Fiscal Year column. You can then filter on FY to retrieve the dates you want. Filtering on Fiscal Year=2020 will return May 2020 to April 2021. You don't have to display fiscal year, just filter on it. Of course, the best way would be a logical time dimension in your data…

I don't know how it works on this new site, which I have found to be very frustrating. I think you just marked your own answer as correct, though.

Create a Fiscal Year column using a case statement around your date field, say "Table"."Date". case when MONTH("Table"."Date")<5 THEN YEAR("Table"."Date")-1 ELSE YEAR("Table"."Date") END This places January-April of 2020 into FY 2019. Jan-April of 2021 will be in FY 2020.

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