7 Replies Latest reply on Mar 27, 2020 9:15 AM by Deepak Rai

    LOD Questions

    Davis Wei

      Hello,

       

      Questions on LOD, hopefully I can get some great ideas here!

      I am trying to use the Supermarket data as the example.

      Goal: I want to create a measure that only count the Order Days in New York Sate regardless which attributes I am using.

      So I created a FIXED LOD, Screenshot below, chart 1. I got 428 Days, which is expected.

      No photo description available.

      However, when I dragg another dimension, Category, the trading days is still 428.

      I am expecting, for each category in each country, I would expect the Furniture has NY Furniture Days Count, Office Supplies has NY Office Supplies Day counts

      Below I am expecting 173/352/155 for each state, instead of 428.

      thank you in advance!