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…

In the example below, I formatted the timestamp value as YYYY-MM-DD in the column properties. the narrative view is simply @2____________@3______________@4 This is what I meant - the narrative will display the data from a column as it is formatted in that column. Format of column 4:

If you have default values for these presentation variables, enclose them in the same curly brackets as the variable name, like this: @{startDate}{2019/08/04}. That will set the format. Alternatively, include them in a properly formatted column, and reference the column in your narrative view, using the @x syntax, where x…

Great! Your answer hadn't hit my inbox when I posted the above. Cheers!

I just did this simplified version of your analysis so you could see what I'm talking about. It is based on a list of 11 Project IDs. The first one listed is "Proj A". This is a pivot table with a nested chart: This is the union. No external (saw_x) columns were needed. "Proj A SubQ" is a simple query that lists the…