Create a formula using two different metric sets on chart

#1

Hi,

I’ve a chart with two metric sets and I want to create a formula using a measure from one metric set and another from the other metric set, is this possible?

how to add more then one metric set as a table(into existing metric set) in Dashboard
#2

It is not possible within a normal chart as far as I know.

However, you can create a widget for each of the metric sets, and then create a formula visualisation which references both of these. Then you can create a formula measure within the formula visualisation to do your calculation. Once this is working, you can delete the original single metric set two widgets.

#3

Hi David,

What do you mean by “create a widget”?

#4

The formula visualisation is set up by clicking on other data visualisations. So I create a table for one measure, then a table for another measure. Then in the formula visualisation you click on the measure in each table, which inserts it in the formula visualisation.
After this is done, the initial tables are irrelevant - they are only a way to get the formula visualisation to reference the correct measures

#5

It’s basically what’s explained in part 3 of https://www.dundas.com/Support/learning/documentation/design-view/formulas/using-a-formula-visualization in the support documentation

1 Like
#6

Thanks David for your help on this issue:)

1 Like
#7

Hi @david.glickman,

I am trying to use this functionality but whatever I do O keep getting formula visualization BLANK. One of my metric sets PoP (1-month lag) and other does not (other has another filter). Both metric sets use transaction date as a time dimension. I am to sure why simple variance (measure 1 - measure 2) is not generating (i.e. I see blank for formula visualization). Was not sure if both measures from DIFFERENT metric sets have to have EXACT filters or something?

image
image.png1128×272 5.97 KB

image
image.png723×141 10.5 KB

Screenshots attached.

Thank you.

#8

hi @semir.taletovic ,

No those different metricsets don’t need to have exact filters. You are using measure1-measure2, what if you test measure1 and measure2 independently in the formula visualization, does it return any results?

Can you double check if you are referring to the correct metricset name and measure name in the formula?

#9

HI @jay.gong, thank you for you reply. I think I tried that - if you se in my screenshot I have 2 table grids that produce results (ie 2 different metric sets). The 3rd iris is the formula visualization that I created that comes up blank and all I am trying is to get 4and 5 variance between 2 separate metric sets. I double checked metric set names as well. So one of my metric set sis pulling just one measure directly form Dundas cube. The second one is doing the same except PoP calculation (1 month lag) is applied to measure in metric set 2 - thought this could be causing the issue. In addition to this, filter are the same on both metric sets except metric set 1 has one additional filter. I’ll five it a try one more time.

Thank you.