IntervalMatch, Dimension from result expression

[pirotfab]

We have a production tonnage every day:

01/01: 28T
02/01: 30T
03/01: 27 T ...

I want to dimension on a summary table, the number of days per tonnages produced

ex:
Sup 25T: 12d
Sup 27T: 8d
Sup 30T: 10d

Do you have any idea of ​​the script?

i try a table intervalmatch but it's doesn't work

thanks

[jerem1234]

Hi Pirotfab,

Not Exactly sure how your data looks, but if you have a date for each tonnage you might be able to just use count distinct like:

Table1:

Load

Tonnage,

count(distinct Date) As Days

Resident DataTable

Group by Tonnage;

Hope this helps!

[Kushal_Chawda]

@pirotfab  can you please elaborate with example?

[pirotfab]

Hi @Kushal_Chawda and @jerem1234 

Thanks you for you answer

For each date, it's a su of several production stations

Attached a database.

Thanks

[Kushal_Chawda]

@pirotfab  what is expectations ? what is expected output?

[pirotfab]

I want the count of day per category, like this

month    <27T          >27T        >28T          >29T         >30T
jul.                9                5                 5               9                  3

[Brett_Bleess]

@Kushal_Chawda Just wanted to let you know the poster did come back with expected output if you have time to have another look at things.  I am guessing the Community notifications are still not working all the time, sorry about that.

Regards,
Brett