Bar Chart Total Automatic to SUM

jyanik — Wed, 24 May 2023 18:58:44 GMT

Have you seen that in a table chart, the default Total Function of a measure is 'Automatic' and you can change it to another function? Like Sum, Count, Avg, etc.

I have a bar chart that shows the total bar, calculated with the 'Automatic' function (I know because I have a table chart with the same expression that shows the same number in automatic), and I need it to show the total in SUM function, which is not an option for the bar chart. Does anyone know a way to do this?

IF(

ISNULL(GETFIELDSELECTIONS(Fecha)) AND

ISNULL(GETFIELDSELECTIONS("Mes Año")) AND

ISNULL(GETFIELDSELECTIONS(Mes)) AND

ISNULL(GETFIELDSELECTIONS(Año)),

IF(

Sum({<"Mes Año" = {'$(=v_MaximoMesCerrado)'},Tiempo={"*"}>}[Tiempo]) - SUM({<"Mes Año" = {'$(=v_MaximoMesCerrado)'},"Tiempo Teorico"={"*"}>}"Tiempo Teorico") > 0 ,

Sum({<"Mes Año" = {'$(=v_MaximoMesCerrado)'},Tiempo={"*"}>}[Tiempo]) - SUM({<"Mes Año" = {'$(=v_MaximoMesCerrado)'},"Tiempo Teorico"={"*"}>}"Tiempo Teorico") , 0),

IF(

Sum({<Tiempo={"*"}>}[Tiempo]) - SUM({<"Tiempo Teorico"={"*"}>}"Tiempo Teorico") > 0

Sum({<Tiempo={"*"}>}[Tiempo])- Sum({<"Tiempo Teorico"={"*"}>}"Tiempo Teorico"), 0)

)

Re: Bar Chart Total Automatic to SUM

Digvijay_Singh — Thu, 25 May 2023 00:55:53 GMT

You may want to try by embedding your expression like below but not sure as I don't know much about your data model -

Sum(Aggr(<Your expression>,<Chart dimension>))

Re: Bar Chart Total Automatic to SUM

jyanik — Tue, 30 May 2023 12:07:55 GMT

Hello! Thank you for you reply! I tried your suggestion but I encounter the following issue:

Putting only the expression by [Name] Gives me the Automatic Total Function, but embedding it as you described gives a a 0 in the chart.

topic Bar Chart Total Automatic to SUM in App Development

Bar Chart Total Automatic to SUM

Re: Bar Chart Total Automatic to SUM

Re: Bar Chart Total Automatic to SUM