I've done this with a two page dashboard prompt. The first page is simply a variable prompt called varNameSearch. The second page column prompt populates a series of check boxes using SQL and a regular expression to find employee names containing any comma separated values in 'varNameSearch'. SELECT "People…

My method would be really tedious for a page with 12 prompts. I'd encourage you to seek other methods, but here it is in a nutshell: Here's my main analysis. Note that in my prompt and in the query filter I have replaced blank spaces with a "_". This is necessary in order to make the return action link work, and why I…

If you are always returning to the same Main Analysis page from your drill-down page (and that may not be your situation), you can place an action link on the drill-down that returns the prompt settings to your main analysis. You'll have to include the prompt columns in your destination query, which means you'd have to…

Yes!!! You'd think I would have tried that at some point in the last thirteen years. (I'm hoping I did try it back in 10G and it didn't work) Thanks for reminding me try the obvious first. Jerry

I'm working in 12.2.1.4.0. Line-Bar is one of the standard graph options, and "Stacked" is an option: Set-up looks like this:

It looks like you need to add your column Z to the BY clause of your COUNT function. Another option is to use a case logic to null-out records you don't want counted. COUNT(CASE WHEN date BETWEEN X AND Y THEN ColumnX."Description" ELSE cast(NULL as char) END by column Z, Column Y)

Thanks for the follow-up. Glad it's working for you.

This syntax works for me: You might try this alternative syntax and see if it makes any difference: They both work for me, but I have had instances in the past where I had to use the latter. Beyond that, I can't see what the problem is with the information provided.

This is as close as I can get using OOTB tools. It's a stacked line-bar graph, with the line-style set to width=0px and symbols turned off. I offset the line scale to raise the data markers. I left the scale visible so you can see the offset, but I would make it invisible in the final version

You need to name your presentation variable in the bottom box, where you currently have "2019-04-01". It should say "PV-START"

Gianni & Christian, Thanks for your responses. I'll look into submitting an ER. Jerry

Thanks, Gianni. I hadn't thought about conditional dashboard sections. Jerry

Hi Dennis, That message is "baked-in". Can you show them a bar chart, or something that can display negatives? If it's bad data, it's best, in my experience, to daylight the business process/data issue. If they have to have a pie chart, you can again use an ifnull statement to eliminate the negatives. Jerry

This format works for me: "Student Program Detail"."WITHDRAW_DATE"<= EVALUATE('TO_DATE(%1,%2)' as date,'06/30/'||cast(@{sch_enr_yr}{2018} as char), 'mm/dd/yyyy') jerry

Hi Dennis, If you cast your date column as char, you can use an ifnull statement like: IFNULL(CAST(datecol as CHAR),'No Date'). You'll get a line labeled No Date and a subtotal with a label. If you want to maintain the date format, you can use EVALUATE('TO_CHAR(%1,%2)' as char,DATECOL,'mm/dd/yyyy') instead of the CAST…

Would you mind marking my answer as Helpful or Correct? That will help people with the same question find an answer. Cheers, Jerry

There's no need to create multiple compound views. You can simply place a table view in one section, a pivot chart view in another, etc. Each section will show the same No Data message.

Hi Dennis, It sounds terribly redundant, but if you're talking about a dashboard page, you can put each separate view in its own section. Your "No Data" message will appear in each section. I don't know of any way to do that within a compound view. Jerry

It's just a running aggregate function. RSUM("Job Applications"). If that column is text, you'll have to cast it as a number.

I don't fully understand your data or the requirement, but this may work: My "Delta" column is equivalent to your "Job Applications" column. By doing a running sum on that column, it provides a basis for MIN(Archive Date by RSUM). At each "0" in the Delta column the last column shows the date of the previous "1". "RSUM"…