hi it doesn't matter where it is positioned on the dashboard - the prompt column needs to be as a filter in the analysis for it to pass through. ie If your prompt is on the column "journey name", then in your analysis apply a filter "Journey name is prompted"….then then value from the prompt will pass through. Note - even…

Have you tried anything ? Looked at the Case statement? case when Ethnicity like '%Hispanic%' then 'Hispanic' else Ethnicity end

so if category is GP Budgeted , return the Classification name. if thats what you want, then yes seems correct Is it giving you what you want?

Yes i know - above is for OTBI. So create a simple otbi report and get it working like my example above, then add the rest of the detail you want one by one…

Don't thnk there is an easy option. Could maybe do a Union to return custom headers as a "data row", then format that row. Select 'heading1' , heading2'… union select data1, data2 Other option is if Edit formula for each dim/measure and provide the required "Folder headings" to group them together. In the table view >…

Start of with a basic table and get it working, then add in the other dimensions one by one….there must be something causing an issue

Make sure rhe Dimension Class Category isn't in the table, then it will aggregate up and make sure the Aggregation of the measures are set to sum. My simple Example:

yes plenty examples on here -Just create a CASE statment for each one you want case when Classcatgory = 'A' then value end case when Classcatgory = 'B' then value end

Have you amended the formula? create a new report without amending anything > create a pivot table > make sure it is aggregating up > then once that is working can then use the case statement to amend the output

the cog next to the measure

The pivot table should aggregate the data. So you should just have 2 rows for public hol and. regular - but you are getting multiple rows so its not aggregating. Just put payroll type in the row, date in the col, hours as the meaure - then check the aggregation of the hours - click on the cog - try setting it to sum. The…

youve still not provided your desire output. put the table in excel and show how you want it to be in the report

So you no have 4 rows instead of 2, so your orig pivot table was aggregating values. Can you share the output how you want it to look pls

Add payroll time time into your output, so its clear what it is - once know what it is returning, can then work out the correct case statement

Also the intial case statement is incorrect If "Payroll Time Type Name" = 'Public Holiday IN', then this is satisfied by the 1st "When" condition: "WHEN "Reported Time Entry Details"."Payroll Time Type Name" = 'Public Holiday IN' THEN 'PH'" ie it will return "PH", so it will the 2nd condition will never be met because…

hi sorry i can't comment on Work definitions as don't use that but the audits tables return same info as UI for what we've enabled

Hi Audit tables have an underscore suffix. Eg if turned audit on for Salary changes, then the salary table is CMP_SALARY therefore the audit changes are in CMP_SALARY_

Sorry I have't used OAC

hello - I'm sure there are a few possibilities.. This is one way Not sure what your 1st column is so below I've used Assignment type instead, but principal is the same. Create separate metrics for each gender : i) Female : sum(case when "Person Legislative Information"."Sex" = 'Female' then "Person"."Person Count" end by…

Just click on options and choose whats appropriate for the LOV. eg can select "specific column values" and just enter the values you want or "SQL results" to include some logic to what you want returning etc