Same metric different value..

[debcorne]

Hello

In my Dashboard in Sense I have a table with a metric and a bar graph with the same metric,

I want to get the result expressed in Millions for it I divide the metric by a million in the pivoting

table gives the correct result but in the graph of bars No,

I attached the chart below.

Enero Value  5,53K in bar chart

Enero value 5.529 M in Pivot Table.

Please Help..

[ahaahaaha]

Hi Debora,

The bar chart in the settings, select the expression in the "number format" element "Setup", and then in the space provided "sample format", add the required number of zeros after the decimal point. For example, # ##0,000 - for the accuracy of three decimal places.

Regards,

Andrey