Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Compare the missing values between two dates in a single table

Hi, My request is below;   From this table I want compare the values missing beween two dates. I want to populate the numbers as well as the values. Date I want to have a slider so based on ...
Need Help
Show and Tell
Tutorial Requests
Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Anonymous 

Thank you for your question, and yes you can show based on what you want to show.

Because the source data was not showing much information, I could come up with something like the below.

For instance, you can show "Not Missed" vs "Missing Value".

Or, you can only show "Missing Value".

It is also possible to show it with other information if there are any.

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up 

 

https://drive.google.com/file/d/18fmECiBWs5VWrDveCiB6wsHLOiR_pF0t/view?usp=sharing 

 

The link is still the same, and I updated it.

thank you very much.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI Jihwan_Kim ,

Data isn't accurate. If you change the slicer to Last Min & Last Max date, the values are incorrect.

Also if the dates aren't continuous then it will populate wrong data.

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, Anonymous 

    Thank you for your feedback.

     

    I think I misunderstood your initial question.

    My visualizations are giving the answer when selecting the dates between those are in your initial question.

    And, if it selects all ranges, it gives all Vause = Missing Value. Because non of them appears on all days. -> I think this is the point that I misunderstood.

     

    Sorry to misunderstand, but if it is OK with you, please share your desirable outcome.