0

How to I show data point that do not have a value

Hi,
I have a report, where we don't have sales data for the time period, but I want to show the empty cells on the report . Like in this example 123456 didn't show up. Who could help me to solve this.

Anderson

3 replies

null
    • Senior Director of Product
    • Ian_Macdonald
    • 2 wk ago
    • Reported - view

    Hi  ,

    I am guessing that your time period hierarchy is derived from your sales data. Thus it will only contain the time periods that are present in your sales transactions. Therefore you cannot plot something that does not exist.

    This is why production data warehouses and dimensional models use system derived time dimensions rather than relying on all the time attribute members being present in the actual data.

    There is a data source in Model called "Date Range" where you can generate a full set of datetime values, then use the "Time Intelligence" block to generate all the date and time attributes and members. Have this create a new table in your model called "Time" and join it with  a left outer join using date and hours to the date and hours fields in your fact table. Then in your Discover, use the "Show Empties" button to display the hours that have no presence in your fact table.

    If this is a Direct Query Model, than someone will have to do a similar thing in your underlying database, or build a custom SQL query that does the same thing in your model.

    Hope that helps.

    Ian

      • Anderson_Chou
      • 2 wk ago
      • Reported - view

       My time format is like this 

      2022/12/16 11:38

      Is there a suggested order of operation, please
    • Senior Director of Product
    • Ian_Macdonald
    • 2 wk ago
    • Reported - view

     I don't understand your question. Can you explain a little more fully what you require?

    Ian

Content aside

  • Status Answered
  • 2 wk agoLast active
  • 3Replies
  • 27Views
  • 2 Following