Imbar's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Grand Totals Not Working with Filters
Hi @Flora Mendiola , Sorry for the late response. Is this still happening? If so, could you attach the definition of the calculation BinCost? And also,…
- imbarmarinescubar_pyram
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: CurrentPeriod & StrToDate in an InMemory Model
Hi @Laurent Jamet , Sorry for the late response. Could you please check again to see if this works for you? If not, could you check in the transaction log to see what query ran?…
- imbarmarinescubar_pyram
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: IF formula trouble
Hi @Nicholas Campbell , I think you are looking to check the caption. And use "||" as an "or" condition. Something like this should work:
- imbarmarinescubar_pyram
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Removing Eliminations.
Hi @Cyan Winter , I'll start by saying that I understand the complication and we'll try to rethink the way this acts. Here is a small overview of elimination and deselection: Deselection:…
- imbarmarinescubar_pyram
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Using Time Intelligence Hierarchy (Regular) cannot use a separate year filter
Hi Nick, If you use the same hierarchy/attribute both on the visual and in the filter (as a slicer), then the value of the slicer drives what is in the visual.…
- imbarmarinescubar_pyram
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Failed while creating Formula
Hi @mangesh desai , It looks like connection/modeling issue - no problem with the formulation but the actual data doesn't connect. Can you run a query against that model?…
- imbarmarinescubar_pyram
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Rank
Hi Nick, We do not yet have a Rank function in PQL, but it should be coming soon. I will try to think of an alternative way to solve that question. In the mean while,…
- imbarmarinescubar_pyram
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Displaying only yesterdays Date
Hi @Katherine Mobley , I believe that the column type is date-time and not date. That means that "current period" is actually generating today's date but also the current time (say, 04:…
- imbarmarinescubar_pyram
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Displaying only yesterdays Date
Hi @Katherine Mobley , Could you attach some images of the data (the column and elements that you are using) and the script that you created? Also which data source are you connected to? OLAP Cube,…
- imbarmarinescubar_pyram
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Displaying only yesterdays Date
Hi @Katherine Mobley , You can calculate "today" for a given column. Then use the AddDays function. 1. Create "New Formulation" -> "List" 2. Go to script mode 3. select the column of your dates 4.…
- imbarmarinescubar_pyram
- 5 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Help with displaying full year and Week To Date
Hi @Alister Hill , We are having a hard time understanding what you mean. Could you maybe attach screen-shots of the 2 reports, so we would have a clearer picture of what you already have and what…
- imbarmarinescubar_pyram
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Grand Totals Not Working with Filters
Hi Flora, Could you please provide some more details on this issue? 1. What data source are you connected to? Pyramid In Memory, MS-OLAP, MS-Tabular, SqlServer, Oracle etc. 2.…
- imbarmarinescubar_pyram
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: 'Lagging' Time-Scale in Discovery
Hi James, If I understood correctly, you need a measure formulation of your CUSTOMERS of the previous year. Generally you could use the AddYears function, with -1 to get the previous year's date.…
- imbarmarinescubar_pyram
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Formula Question
Hi Chris, I'll explain how to get this result and add attached screen shots using "Sales Amount" as your "Total credit hours attempted" and "Calendar Year" as "Academic Term".…
- imbarmarinescubar_pyram
- 6 yrs ago
- Questions & Answers
- Reported - view

1 2 3

Back to top

Home

Questions & Answers

View all topics