Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Its might be a very basic thing to do but for some reason, I am not able to do it.
I have date Dimension, which is showing in multiple lines, i want to bring total of expression by date in 1 line, as you can see here.
I will really appreciate if someone can help on this.
Regards,
M Talal
Seems like your date is formated as date, but in fact it is a timestamp.... You can fix this in the script or using a calculated dimension
Date(Floor(PVX_DATE)) as PVX_DATE
Load your PVX_DATE the following way (or in a new field)
Load
Date(Floor(PVX_DATE),'DD/MM/YYYY')
From....
This removes any time related info from PVX_Date
Hi Sunny,
If i use it on the script, my other tables will be disturbed where i need all the lines,
any chance i can do this without script.
I think you are using a Tablebox
You should be using a Straight table and PVX_DATE as Dimension and Sum(Container) as Expression
vinieme12 I see totals here, how can this be a table box?
OH didn't see that
I tried this but now
no result as you can see in the pic sunny
Seems like your PVX_DATE is not read as date.... either share a sample to see the issue or go through these the way to fix the PVX_DATE using Date#() or TimeStamp#()