-
Pattern for expected behaviour (general Q)
As I am getting acclimated to using Pyramid, one of the things I'm struggling with is the expected behaviour. Specifically, I have a line chart with two lines.…
- Answered
-
Alternate header row shading
I'd like to extend the alternate shading to the header row and not just the data rows. How do I go about that? I didn't see anywhere in formatting to do this.…
- Answered
-
How to Limit Color Logic to a Single Column
In the screenshot, there is a color-coded "Med Surg Supply Cost / Equiv. Patient Day" measure, where the red-green split is based off the average of those values. How do I 1.…
- Answered
-
Formatting For Multi-Select Drop Down
Is there a way to make the search box in the multi-select drop down the same size as the slicer elements? It seems I can change the size of the elements but the search box stays the same size.
- Answered
-
Custom Date Time Format with Time Zone
Is there a way to avoid interpretation of text in the custom date/time format? I am following the Pyramid help reference for DateFormat, where it explains that the masking is based on Java…
- Answered
-
How to define a common scale for primary and secondary Y-axis?
I have a (stacked) bar chart with two measures - one measure on the primary Y-axis, the other on the secondary y-axis. As these two measures should be comparable (imagine e.g. incoming vs.…
- Answered
-
Font color not working on light blue color background .Ex Font color :#FFFFFF, Background Color:#85CCDB
For example see the attachment: I need all the headings in white Font.
- Answered
-
IBCS Waterfall Column Naming
Hey All, I was just wondering if there is a way to name the left and right book end of the IBCS waterfall. I can't seem to find where it is in format, has anyone else managed to get the previous year…
- Answered
-
Option to change the data format to the Europan format: 1.234,56
Hello, it would be helpful to be able to change the data format from 1,234.56 to 1.234,56 as this format is used in Europe. This could either happen in the profile of each user,…
- In review
-
Data Label Formatting on Average Measurements
Hi, I've created a discovery which has two axis. The first axis (bar) to show quantity and the second axis (line) to show percentage of sales. What we would like to do is show another line on the…
- Answered
-
Export to Excel - keep format of conditional formatted grid data
Hi, I'm trying to export the format of conditional formatted grid data to Excel. Columns and rows are formatted but not the data itself. Is there a way to do it?
- Answered
-
How Do I Use A Small Font Size In Questions And Answers?
Is there any way to use a small font size in questions or answers? That is, for the purpose of minor and possibly irrelevant information? I've checked the Markdown syntax but couldn't find anything.…
- Answered
-
How can I convert date hierarchy into specific format?
Hi together, I need a graph with a dynamic changing x-axis (last 12 months) with dates in the format “MM-YYYY”. I am using a date hierarchy to get the dynamic part working.…
- Answered
-
Is there a way to change date formats in a model?
We are located in the US and would like to change the date formats to a format that our users are used to, such as mm/dd/yyyy. I don't see a way in the model to set the date format displayed.…
- Answered
-
Discovery chart - how to show % values to 1dp?
Hi all, In my discovery chart, I would like to show my axis labels to 1 decimal place (they currently show to 3 decimal places). E.g. they show 1.200% when there is really no need.…
- Answered
-
Ordering the Months
Currently when I am displaying the MonthName field it defaults to showing me the names in alphabetical order. How do I fix this to show me the regular order (January, February, March, April, May,…
- Answered
-
Number Formatting in Discovery
Hi all, I have the attached discovery prepared from the attached data model. I am having trouble displaying the variance information as a percentage rather than a number format.…
- Answered
-
Importing data from Excel - formatting decimals
Hello, I have downloaded new version of Pyramid Analytics and would like to make some visuals for a test. My initial inquiry got stuck in the phase of loading data from Excel.…
- Answered