Hi Tom, Can you provide more information about your data? You've described your table as covering weeks 1-10, but you're results show quarters 1-4. Are Quarter and Week coming from a structured time dimension? You've described your desired results in detail, but not what you're working with. Jerry

Before abandoning the union query you built, I'm curious about whether it was a two-leg union or a three-leg union. In analogous situations, I've union-ed one query for Grp A, one for Grp B, and a third for "All Weeks". The "All Weeks" query contains its own calculations on the whole time period, so the row percentages are…

How about: ifnull(Raw Materials, MAX(Raw Materials by Item Number)) ?

No. Add a column to your analysis containing 'WhateverTitle'. Then in column properties, set Interactions to Action Link, where you set up the navigation to your target content. Create and format a a single-column Table, Static Text, or a Narrative view containing only the 'WhateverTitle' column. Use that view as your…

Glad I could help! That being the case, would you mark my answer as "correct", so others with the same question will see it? Jerry

The two dates get passed as a string that looks like this: 2019-12-31,2020-01-29 This filter parses the second date using the position of the comma, then concatenates it into: date '2020-01-29' Then casts it as date. "Project Schedule Milestones"."Advertise Actual"<=CAST('date…

If you create a text column that contains your title, you can create an action link from that value to your target query. You can create a faux Title view by formatting the value within a single-column Table, a Text view or a Narrative view. If your target query displays a Performance tile in it's compound view, that's…

REPLACE("yourfieldname",'-','')

If you can prompt using a numeric month, name a presentation variable in the prompt, such as varMonth. Filter your query on "YourTable"."Month" =@{varMonth}{3} OR YourTable"."Month" =(@{varMonth}{3}-1)

One way to do this is with a variable prompt. Create a dashboard prompt, and select "variable". Give it a name like "varSelect", and a choose Radio buttons as the user input. Add two custom values: "Internal" and "External". Build your analysis with a column formula such as : CASE WHEN 'Internal'='@{varSelect}{Internal}'…

If functioning correctly, that function would just return the number of days between each term. date and the current date. Something's amiss.

You could make a column using TIMESTAMPDIFF(SQL_TSI_DAY,"Worker"."Termination Date",CURRENT_DATE). This will create a "Days Ago" column for termination date.

As Christian said, master-detail linking is the way to go, unless there are union queries involved. (it doesn't work on those.)

Hi John, It's not clear to me what you expect to see on the right. Algeria is highlighted on the left and its chart is shown on the right. Can you provide more detail? How are you passing the "Pays d'origine "? Action link? Master-detail? a simple drill-down? Jerry

If you have access to a data model that has a date record for every day, you can union-in a daily record to fill your missing dates. In this example, I want to show how many contracts were awarded on each day between March and November. I know there were many days with no awards, so I union-in filler dates from a financial…

I'm the little devil on their left shoulder.

I just saw Christian's post, and I don't disagree. In my case, the columns for future years were all calculated based on various project schedule and financial attributes. I should also add that I used a two-page dashboard prompt. This requires the user to hit "Apply" before completing the second page of the prompt. Page…

Hi Arie, I struggled with this same issue a few years ago, back in 11.1.9, but it sounds like it's still a problem. My solution was kind of hacky, but it worked. in the columns below, "STIPYear1" is a presentation variable set by a dashboard prompt: In the dashboard properties, I placed a hidden prompt that used the value…

The null values are the result of the ELSE clause that I used as an example. You can substitute whatever is appropriate for your requirements in the ELSE clause. I may have misinterpreted your original question, which makes this a bad approach. Can you just apply the date filter to the query itself?

Hi Steel, Have you tried putting it in a case statement, such as: Case when "Document Details"."Exception Date"<DATE '2019-08-01' THEN EVALUATE('MAX(%4) KEEP (DENSE_RANK FIRST ORDER BY %1 DESC) OVER (PARTITION BY %2,%3,%5)' as double,"Document Details"."Exception Date","Segment1"."Segment Desc1","Item"."Item…