imbar's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: How do you convert unix epoch time to time?
Hi @Ilan Perez , There is a PQL function you can use: https://help.pyramidanalytics.com/Content/Root/developer/reference/fx/PQL/Common/Date-Time/TimeStampToDate.…
- imbarmarinescubar_pyram
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Hide unwanted subtotals
Hi, @Sergio Galimberti This will be available in the next major version release. should be in the next few weeks (I cannot promise a specific time line). Imbar
- imbarmarinescubar_pyram
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Negative number formats
Hi @Sophie durrant , Do you mean that you want the color to be red? If so, you can use the color drop zone, to color positive/negative values. Drop the measure that you are using into the color…
- imbarmarinescubar_pyram
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Hide unwanted subtotals
Hi @Sophie and @Janneke , This feature is being built and should be available for you in the upcoming versions:
- imbarmarinescubar_pyram
- 3 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Show Empties - In Memory
Hi @Alec Mason , The show empties options returns all the combinations that exist in the result set even if they are empty (null values). In an MDX data source (like tabular) all the members from…
- imbarmarinescubar_pyram
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Custom sort ordering - order by top N but leave "other" at bottom
I'll attach here an example from the start of what I think you meant using states instead of brokers and sales instead of premium. Let me know if it worked for you or if you meant something else. 1.…
- imbarmarinescubar_pyram
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Custom sort ordering - order by top N but leave "other" at bottom
Hi @Nicholas Campbell I'd tried reading the questing a couple of times but I'm still not sure i understood all the details. Could you maybe add some images or more detailed explanations?…
- imbarmarinescubar_pyram
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Folder & sub-folder in Measure group
Hi @Angela Musić , In general, if there are any display folders set, then they will be used to arrange the measures. Any measure that is not under a folder is placed outside (like in your image).…
- imbarmarinescubar_pyram
- 5 yrs ago
- 2
- Questions & Answers
- Reported - view
Re: Range List Using Two Date Hierarchies
@Sophie durrant ohh I see. 2 things are missing then: 1. the caption function was added on version 2020 2. the "dot" function option was added on that same version.…
- imbarmarinescubar_pyram
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Range List Using Two Date Hierarchies
@Sophie durrant could you share the error? did you make sure the set you are trying to create is under "ClosedDate"? it should be selected on the size panel when designing it: also,…
- imbarmarinescubar_pyram
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Range List Using Two Date Hierarchies
Hi @Sophie durrant , If I understand correctly, the second set you are trying to create is under the "ClosedDate" column, right? So first comment is that the ClosingPeriod needs to be set on that…
- imbarmarinescubar_pyram
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Find Difference between two dates
Hi @Aryat Srivastava , Could you please provide some more details so we could help you? What data source are you using? (SSAS, pyramid in-memory, Sql Server, Oracle...…
- imbarmarinescubar_pyram
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Rank
Hi @Philip Augur Still haven't got to this function. You could add it to the feature requests and get up-votes on it to move it up the backlog.
- imbarmarinescubar_pyram
- 5 yrs ago
- Questions & Answers
- Reported - view
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
- 5 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
- 5 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
- 5 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 yrs ago
- Questions & Answers
- Reported - view

1 2 3 4

Back to top

Home

View all topics