Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a chart with custom dimension and expression. But the expression total is not working at all.
Can you please help why expression total is not working, i dont want to use sum of records
i uploaded a similar example file
Gautham
Better - create a real derived dimension in the load script and you will not need a synthetic dimension.
Hi Gautham ,
can you make your question bit clear
Hi
are you expecting to see totals like this
Hi Gautham,
Like this????
Please check the attachment.
Thanks,
AS
Hi Gautham,
Please follow following steps
Properties-->Expression-->Total Mode (click on sum of rows instead of Expression Total)
Please find attached qvw for your reference.
Thanks,
Pooja
i know some of rows will work...what i want is expression total...
not sure why expression total is not working
Because you are using a synthetic dimension, your expression makes no sense at a total level. Change the total option for the expressions to:
Better - create a real derived dimension in the load script and you will not need a synthetic dimension.
Great jontydkpi I thought that would be the issue.
May I know how can i convert the synthetic dimension into real derived dimension?
Do i need to change the expression also?
Thanks
Gautham