Skip to Content
0
Former Member
Dec 27, 2007 at 06:14 PM

A few VC questions....

36 Views

Hello Experts, today I have come up with some questions about VC which I could not solve by looking at the different manuals and tutorials found around here (or perhaps I did not check the right manuals?)

1) I'm trying to create a pie chart to compare values A and B, which when added up give me C. The idea is to show the percentage of A that makes up C, as well as the percentage of B that makes up the rest of C. I already did this in the Web Application Designer, using a certain query. I used this same query for my VC model, but no matter what combination of values I put on Category and Series Fields (I started with the combination I used in WAD), I always get a pie chart with the value used in the Category field occupying all the chart, so it says that it covers 100% of the pie. So how am I supposed to place these values so as to show that it is a comparison between them?

2) I am trying to create a simple example of VC's drilldown capabilities. In this example I use a couple of queries and tables. One query is connected to the input of the "first" table, and in this table I am displaying customer's name, amount paid for products A, amount paid for products B and total payment. The idea is that when you click on any row, on the "second" table some more information about the customer's payment should appear, like each date in which he bought any of these products, the amount of A products que bought and the amount of B products he bought on each date. Therefore I connected the output of the first table with the second query (which has the date and amount of products per customer info), put "select" as the event name on this connector, assigned value "@customer" on this connector, and connected the output of the second query with the input of the second table. I run the model and it seems to work fine, when I click on a customer the second table displays a "wait" message on its top right corner, but after a second or two it displays a "non applicable data" on that same place. Am I missing a step or something?

3) I have noticed that VC sometimes uses the technical name of a field in a BI query, and sometimes uses its descriptive name, even in similar queries I've had the same field called differently on each query. This has nothing to do with cryptic or weird names though. The same goes with the BI queries themselves, sometimes when I drag and drop them, they appear with their technical name, and sometimes with their descriptive name. Is there a reason for this? Can this affect me if I try to use these queries and fields for something similar to my second question?

4) Is there a way to "hide" tables or charts and to show them only when a certain even has occurred, and perhaps hide them again if another event occurs?

Well, that would be all for now, thanks in advance.