Difference between variable being attribute or measure

unknown

Hi,

Could you please clarify what is the difference in terms of visualiser report when the same variable exists as an attribute or as a measurement.

I try to determine the best variable for my report and the report gives me mostly empty cells when varaiable (arsc.salesytd) is classified as a measurement.

My question is why sometime  there is value but most of the time not.

It has something to do with using time dimension for filtering and with other measurements from oeeh table.

I am straggling though to understand the connection here.

Please see the details in the screanshot below and the query.

SELECT USING OUTER JOIN [ARSC.arsc_name] 'COL0' , [ARSC.arsc_salesytd] 'COL1' , [ARSC.arsc_slsrepout] 'COL2' , [ARSC.custno] 'COL3' , [MTD oeeh_invoicedt: Sum: oeeh_totlineamt] 'COL4' , [arsc_crestdt: Sum: arsc_salesytd] 'COL5' , [oeeh_invoicedt: Sum: oeeh_specdiscamt] 'COL6' , [oeeh_invoicedt: Sum: oeeh_totlineamt] 'COL7' , [oeeh_invoicedt: Sum: oeeh_wodiscamt] 'COL8' FROM [ALL] WHERE ( ( [ARSC.arsc_statustype]='true' ) AND ( [ARSC.custno]=23761 OR [ARSC.custno]=23638 OR [ARSC.custno]=19695 OR [ARSC.custno]=10721 ) AND ( [Time.Months Ago]>=0 AND [Time.Months Ago]<=6 ) )

I will appreciate any comments on that.

Regards,

ALina

Dan Rosen

A measure is something you want to aggregate (sum, count, avg, etc.) like sales. A dimension is something you want to slice that measure by, like customer (sales by customer). With a measure, you can choose an "analyze by date" which you want to see that measure by when using the built in time series. For example, if you have both a shipment date and an account create date, and you filter sales for 2020, you will get vastly different results for the sales you shipped in 2020 as opposed to the sales from accounts that were created in 2020

0712131256598360.doc