Interactive Data to change pricing
Hello,
I am trying to find the limits of Pyramid, so pardon me if this is impossible. I'd like to think that thee has got to be a way... even if it is complicated.
1) How do I get my data to show up on 2 lines within one "cell". In excel this is simple, but in P.A. I cannot find a way
2) What I'm hoping to be able to do is use a slicer (or something similar if there is a different option) in the present that would enable a user to click on one of the options, which would then dynamically change the pricing.
So, first off, can the text be assigned a value?
And Secondly, is it possible for a situation where a user could click on "UpchargeA1" (let's assume the value is $50.00) then the "Base Price" would change to $150.00 ($100.00 + $50.00).
If it can be done, but requires some coding, then could you give me a general idea what needs to be coded and I can pass it off to my counterpart who is much more skilled in coding than I am and have him write some code.
Having this type of functionality would enable me to blend a whole slew of products into 1 dynamic column.
EDIT: The value that would be assigned to the text is available in a separate column in my model. So - I would have column 1 containing the text (UpchargeA1), and column 2 containing the value (50) that I would like the text to represent.
7 replies
-
Hi Ricky, typically if we want to show data like your image above where it's 'grouped by' we add multiple dimensions to the "Rows" drop zone in a matrix grid. I may not be interpreting that first question fully though. If you are looking to essentially change the value of pricing based on whether it's UpchargeA1 or UpchargeA2, I could see this being done by creating a Parameter and then creating a Formula with a logical statement (Case, IF, etc) that returns different calculations based on the parameter or field value for 'Upcharge". In terms of clicking on "UpchargeA1", you could have that Parameter I mentioned take the form of a "Button" type of slicer.
Let me know if I am on the right trail for what you are asking, or if I'm oversimplifying it. I think this can definitely be done primarily within Formulate.
-
I'm putting together a comparison between products (100+) so having everything on separate rows makes it hard to read an gives it a cluttered look. If I am forced to keep the measures on separate rows, is it possible to merge the dimension and then nest the measures together (as shown using excel).
-
-
Thanks, those screenshots are helpful! Since you're In-Memory here, the first thing I would probably do is to add a String Left node in your data flow and take 8 characters (create column & keep original). Then, you can use that as your dimension and it will show the Example1, Example2, Example3 separately but still split out the Upcharges for each.
-
ok - so it groups the products (Example1A, Example1B, Example1C) when I use the string left, but the pricing and upcharges aren't separated. I need them to be on separate lines and not on 1 line separated by commas (,)
I think it should be added as a feature where TXT data can be separated by a line break (ALT+ENTER) instead of a comma.
-
-
From a display standpoint, if you go to the formatting panel and turn on "Wrap Text" you can get each Upcharge on a separate line. You would just want to remove the comma from the string. Then, make the Upcharges column narrower until it wraps the text.
I'll look into a solution for selecting individual upcharges from a single field though.
-
Hi
Pyramid Grids have a plethora of formatting options, but we would concede that it not in the same league as Excel.
For this type of "Last Mile" formatting, we introduced into the Pyramid platform the Tabulate module. This an Excel like spreadsheet built into the Pyramid platform and surfaced through your browser like the rest of Pyramid. Discover queries can be dropped into the sheet and the resultant output displayed. You can then do all the types of formatting that can do in Excel.
Here's an example:
"Visual Areas" can be defined in your worksheets and those are available to display in Dashboard and Publications
However, Tabulate is an additional licencing option, so it may well be that your organisation has not licenced it.
Hope that helps.
Ian
