formatting

How to undo total column color formatting

I created a few discoveries and color formatted the total and Subtotal columns. I added color formatting to the rest of the table but was then told that this needed to be done in the Total columns as…

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